-
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.
Popular Salesforce Blogs
An Introduction to Salesforce Consumer Goods Cloud
Salesforce has introduced Consumer Goods Cloud, a new industry product that enables companies related to consumer goods to optimize revenue growth and maximize ROI with…
How Does Salesforce Data Cloud Improve Operational Efficiency?
Table of Contents What is Salesforce Cloud Data? Salesforce Data Cloud enhances operational efficiency in several ways Data Unification Real-time Insights Personalization Automation Segmentation Third-party…
How Does the Store Work in B2B Commerce? | Salesforce Guide
The primary thing to get done with regards to understanding the B2B Commerce information model is understanding the part of the store. The store in…
Popular Salesforce Videos
5 Tips: How Events Can Help You Drive Value for Your Business | Salesforce on Salesforce
Events are at the heart of every major launch moment and announcement. They offer opportunities to connect with customers, providing experiences that grow loyalty. And…
Saving Journey History in Marketing Cloud
We explore how to leverage Marketing Cloud REST API and its automations to save all the journey history data for your organization. Includes a video…
Summer '20 Release - Release Updates Page
Check out the new Release Updates Page. Salesforce Summer '20 is full of amazing features for #AwesomeAdmins! Check out what's new when you follow and…