-
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); - [adinserter block='9']
-
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.
