function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Jennifer.SchnellJennifer.Schnell 

Is there a way to query a field to see which reports it is used in?

We have a field we had to replace "Customer_Origination_Date__c" with a new field.  Is there a way to query for that field to see what reports it is being used in?  I do not think it is possible to do a mass replace at all.
Best Answer chosen by Jennifer.Schnell
Alain CabonAlain Cabon
Hello,

Could you try force.com CLI ( force.exe for command lines )?
  • Download one executable program from here:
https://github.com/heroku/force/releases/tag/v0.22.77
  • Then you can download all your metadata (including all the custom reports) from cmd (windows) 
  • (key) Windows (or Windows+R) and then type “cmd”:  Run the Command Prompt in normal mode. 
  1. force login -i=test.salesforce.com -u=<user> -p=<password + token>
  2. force export
  3. force logout
  • At the end of the export of your metadata, the folder of all the exported data is clearly indicated (command 2 above)
  • With any editor (PSPAD or NotePad++) , you can search in the folder Report the value: Customer_Origination_Date__c
  • Unfiled Public Reports Folder could be missing by default but the custom reports should be in other folders normally.
  • select id,name,foldername,developername from report  (request for the query editor tab in the developer console "Public Reports"?)
Regards

All Answers

Alain CabonAlain Cabon
Hello,

Could you try force.com CLI ( force.exe for command lines )?
  • Download one executable program from here:
https://github.com/heroku/force/releases/tag/v0.22.77
  • Then you can download all your metadata (including all the custom reports) from cmd (windows) 
  • (key) Windows (or Windows+R) and then type “cmd”:  Run the Command Prompt in normal mode. 
  1. force login -i=test.salesforce.com -u=<user> -p=<password + token>
  2. force export
  3. force logout
  • At the end of the export of your metadata, the folder of all the exported data is clearly indicated (command 2 above)
  • With any editor (PSPAD or NotePad++) , you can search in the folder Report the value: Customer_Origination_Date__c
  • Unfiled Public Reports Folder could be missing by default but the custom reports should be in other folders normally.
  • select id,name,foldername,developername from report  (request for the query editor tab in the developer console "Public Reports"?)
Regards
This was selected as the best answer
Alain CabonAlain Cabon
The downloaded folder is exactly the folder reports. 

If you have "Public Reports", the default package.xml should be changed.

Personal folders — Users' personal folders, for both reports and documents, are not exposed in the Metadata API. To migrate reports or documents you must move them to a public folder.