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
Adam KrausAdam Kraus 

How to View All Validation Rules

Hi, how can I view all my validation rules on one screen as opposed to having to go through each object?
Mani RenusMani Renus

Hi Adam,

Follow below steps

Go to Workbench (https://workbench.developerforce.com)

Utilities -- select get

Paste below url on search box then click on Excute

/services/data/v31.0/tooling/query/?q=Select+Id+From+ValidationRule

Then you'll find all the Validation rules(click on records) on Salesforce

User-added image



Hope it helps YOU !!!
Adam KrausAdam Kraus
Hi, thank you for your response, however it doesn't help.  I need to be able to see an actual readable list of all validation rules within salesforce.

All this is is a bunch of record IDs that I need to manually copy and paste individually at the end of my salesforce URL to find out which validation rule each one is.
Mani RenusMani Renus

I'm not sure but hope follow links helps you

https://success.salesforce.com/answers?id=90630000000gxvwAAA

http://salesforce.stackexchange.com/questions/60113/migrate-objects-and-fields-using-sublimeapex
Adam KrausAdam Kraus
Hi Mani, those links are actually very helpful, however how do I install SublimeApex/Sublime Text 3 plugin?
Samet Atik 3Samet Atik 3
Hi @adam
You can also click on 'Expand all' to see all records with their url's. Clicking on them one by one does not display their url but when you click on expand all, everything is listed.
BraneBrane
You can Use Tooling API from Developer Console and write SOQL query to retrive all validation rules from all objects.

User-added image

Here is the example of the query: 
SELECT Id, CreatedDate, CreatedBy.Name, EntityDefinition.DeveloperName, ValidationName FROM ValidationRule

Here is the documentation for more info: 
https://developer.salesforce.com/docs/atlas.en-us.api_tooling.meta/api_tooling/tooling_api_objects_validationrule.htm
 
Karim Gabriel 3Karim Gabriel 3
Try using this string - ?q=Select+ErrorMessage+From+ValidationRule 

In the workbench REST Explorer...
Karan_JainKaran_Jain
hey @Adam
if you are working on validation rules and if you want validation rules so
you have to use Tooling API because normally you can't access that object 
thank you 
Nikita Meshram 2Nikita Meshram 2
Hi Adam Kraus,

This is easy to find using the Standard salesforce option like Workbench or Developer Console using SOQL Using this you can check all your Validation Rules in one go.

You may also attempt AppExchange Solutions for this, such as the Satrang Metadata Search AppExchange App, which offers all search possibilities for Components. You can also use particular Keywords to search for results. You may download the search results in Excel and PDF format.

AppExchange App URL - https://appexchange.salesforce.com/appxListingDetail?listingId=a0N30000009wgF7EAI&channel=recommended&tab=e

Disclaimer: I work at Satrang Technologies, the publisher of this Satrang Metadata Search App Exchange App.