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 ’25

  Manage Included Permission Sets in Permission Set Groups via Summaries Update user access more efficiently by specifying which permission set groups include a permission set directly from the permission set’s summary. Previously, to manage included permission sets, you were required to navigate to each permission set group’s page. From Setup, in the Quick Find box, enter  Permission Sets , and select Permission Sets. Select a permission set, and then click  View Summary . In the Related Permission Set Groups tab, click  Add  or  Remove . This change applies to Lightning Experience and Salesforce Classic (not available in all orgs) in Contact Manager, Group, Essentials, Professional, Enterprise, Performance, Unlimited, Developer, and Database.com editions. Sort List Views by Multiple Columns To see your data in a more intuitive way and make your list views more actionable, you can now sort list views on object home pages by up to five columns. Select the c...

Maintain Your Platform Developer I Certification for Winter ’25

  Make Invocable Actions Easier to Configure with New InvocableVariable Modifiers Simplify the configuration of invocable actions using new modifiers from Salesforce. Both the defaultValue and placeholderText modifiers will appear in Flow Builder for the Action elements that correspond to an invocable method. Here’s how to use them. defaultValue Modifier : Set a default value for an input parameter. When the action is used, the input parameter will have a predefined value unless changed by the user. placeholderText Modifier : Set custom placeholder text for an input parameter. Text can provide examples or additional guidance to help users understand what to enter in the input field. Accessing these modifiers in Flow Builder makes it easier to configure and use the actions within your flows. This change applies to Lightning Experience and Salesforce Classic in Performance, Unlimited, Developer, Enterprise, and Database.com editions.

Salesforce Architect Certification Maintenance (Winter '25)

  Update Records Using ISO State and Country Codes Standardize and simplify updating address records with two new fields that store the ISO code for country or territory and state or province. Improve data quality and accuracy using this new support for ISO codes, and reduce the risk of errors and inconsistencies that can occur when using names. Previously, the Address component stored only the name associated with the user’s selection. With this new support for ISO codes, you can update the country or territory and state or province fields on records with ISO codes instead of names. This feature can be used for new or existing screen flows. Here are the steps to create a new flow. In Setup, on the State and Country/Territory Picklists page, ensure that Enable Picklists for Address Fields is enabled. In Flow Builder, create a screen flow. Add a Screen element to the flow. Include an Address component in the Screen element. Optionally, specify a default value in the Country Code and...

Translate