function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
ArchestainArchestain 

Salesforce entity tables

How i can able to query the salesforce core entity tables such as validation rules ,Escalation rules, Field Table of an object etc.



 
Rowallim TechnologyRowallim Technology
Hii Archestain
Validation Rules are metadata, so are not query-able using Apex / SOQL.  You canuse the Metadata API to query for the ValidationRule element (http://www.salesforce.com/us/developer/docs/api_meta/Content/meta_validationformulas.htm).
The Metadata cannot be accessed from within your Salesforce Full Site nor with any Apex/SOQL. To retreive the Metadata, you'd use the Metadata API.

Now, external IDEs like the Force.com IDE[1] uses the Metadata API to fetch all information from your Orgsuch as the Custom Object Fields, Validation Rules, Workflow Rules etc.

So in essence you might wanna use Force.com IDE to fetch all the Validation Rules of may be one Object or even all of them. You can then do a Search All Files to catch hold of the culprit!

[1]: Force.com IDE (https://developer.salesforce.com/page/Force.com_IDE)

Hope this will help You.
If you think your question is answered mark it as best answer.
Thanks