-
How can I know that the profile is custom or standard in salesforce through query?
Hi All,
How can I know that the profile is custom or standard in salesforce through query?
Through query I want a list of custom profiles in a org.
Please give suggestions.
Thanks
-
2 Replies
-
Hello Pranav,
You can do like this:
List<String> stdProNames= new List<String>{'System Administrator','Standard User','Read Only','Solution Manager','Marketing User','Contract Manager'};
Profile[] customProfiles = [Select Id, Name from Profile where Name NOT IN :stdProNames];
System.debug(customProfiles); -
Below SOQL will fetch you all standard profiles.
SELECT ProfileId, Profile.Name FROM PermissionSet Where Iscustom=false AND ProfileId != null
Below SOQL will fetch you all custom profiles.
SELECT ProfileId, Profile.Name FROM PermissionSet Where Iscustom=true AND ProfileId != null
Log In to reply.
Popular Salesforce Blogs
Why is Salesforce Revenue Cloud Best for B2B Channels?
Last year Salesforce launched Revenue Cloud specifically targeting B2B channels to take complete charge of their revenue growth. Many businesses' revenue cycles were thrown into…
Optimization of Salesforce Org - Everything You Need to Know
In this blog we’ll learn about Optimization, why is it necessary, how can we optimize apex class, the highest execution duration of an apex class,…
Reports and Dashboards in Salesforce | The Ultimate Guide
Here we will study One of the key features of Salesforce that is the ability to generate reports and dashboards that provide valuable insights into…
Popular Salesforce Videos
Salesforce Sales Cloud Basics
This short video shows how easy to create & manage leads and to convert it to opportunity, contacts & accounts using Salesforce Sales Cloud. Please…
Salesforce Advanced Code Searcher | Productivity Hack
By using the advanced quick find you can get your code a few clicks shorter. Also, you can search any string your code. Using this…
What is Lightning Web Components (LWC) in Salesforce?
LWC is a collection of modern framework which has lightweight features and we can create a reusable code. Watch this video and let us know…
