Skip to main content

Object/Action name present in Org with Queryable/Retrieveable/Searchable and many more Status in Query

We always want to know what are the objects present in salesforce so we can utilize any existing if needed or to understand the structure more. Here are few ways which help you to do that.

Basic Code to get all object without any query:

Schema.DescribeSObjectResult objResult = o.getDescribe();
            String obj = objResult.getName(); 
            System.Debug(objResult.getName());

Basic code to get Object record count, don't run for all object you might get exception of 101 SOQL. Try to run this in a loop of first 100 then 100-200 and more based on need.

{

            Schema.DescribeSObjectResult objResult = o.getDescribe();
            String obj = objResult.getName();
            Integer count = 0;
            q = 'SELECT Count() FROM ' + obj;
            try{
                count = Database.countQuery(q);
            }catch(Exception e){
                continue;
            }
            mapdata.put(objResult.getName(),count);
            System.Debug(objResult.getName() + '-->' + count);
    }

Now I'll sharing the Query which can be used to get even more detail about object such as whether object is Queryable or Retrieveable via metadata or Searchable or not.

SELECT  QualifiedApiName FROM EntityDefinition order by QualifiedApiName 

EntityDefinition: It is very necessary to understand the capability of this object. To use this object and query efficiently one should use This Link  to understand the available options and the object structure.

Query to get all Fields of any object:

select QualifiedApiName, Label, Description, DataType, RelationshipName 
From FieldDefinition 
where EntityDefinition.DeveloperName='Account'

 To get all relations fields please add the below query to where clause of above:

and RelationshipName != null


Comments

Popular posts from this blog

Maintain Your Administrator Certification for Spring ’24

Maintain Your Administrator Certification for Spring ’24 Intelligence Views Intelligence views are now available for leads, contacts, and accounts in Sales Cloud. Turn on a view in Setup and then add the Intelligence View button to the view-button layout for the applicable page. New Salesforce organizations include the views by default, but admins for existing orgs can enable: Lead Intelligence View Contact Intelligence View Account Intelligence View Find specifics about these views in the next three topics. Turn on Contact Intelligence View in Contact Intelligence View Setup and add the Intelligence View button to the Contact List View button layout. To view engagement metrics, enable Email Tracking in the Inbox section of Sales Engagement Setup. To see the Intelligence View, users go to the Contact home page and click Intelligence View. To view engagement metrics, choose Engagement Metrics from the Metrics menu. To see the Account Intelligence view, go to the account home page and cl...

Platform App Builder Certification Maintenance (Winter '24)

 Maintain Your Platform App Builder Certification for Winter ’24 The Enable Reactive Components for Screen Flows running API Version 57.0 and 58.0 setting expires in Winter ’25. Before that release, upgrade your flows to run on API version 59.0 or later to take advantage of reactive components. Build Screen Flows with Reactive Global Variables Save time by referencing global variables in reactive formulas on flow screens. Use custom labels in reactive formulas to display translatable text to your users. For example, create a custom setting called DiscountPercentage, which specifies org, profile, and user discount percentages. Reference the variable in reactive formulas across a screen flow. The screen flow applies the correct discount value for the user running the flow and recalculates the value as the user makes changes.   Build Screen Flows with Reactive Selections Use choice components to respond to user selections elsewhere on the same screen. For example, on a flow ...

Administrator Certification Maintenance (Spring '23)

 Maintain Your Administrator Certification for Spring '23 1. What information is listed in the Details panel for recently used reports? Answer: A, B, C 2. What is used to give sales reps access to a guided process to import contacts and leads? Answer:  Sample CSV file 3. Which feature efficiently removes inactive picklist values? Answer: Bulk Delete Unused Values 4. Which type of Process Builder processes can be converted using the Migrate to Flow tool? Answer: Record-triggered Get Hands-on with Enhance Record Pages With Dynamic Forms Follow steps show in Screenshot also highlighted with Red Box:

Translate