Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have lookup field for country in many object is it possible to check in one place in Salesforce in how many object this field is being used

share|improve this question
    
Do you mean how many objects are children of "country"? Or what Visualforce/apex pages and classes is the field being used on? – Sebastian Kessel Jan 6 at 7:52
    
One of the SFDC Admin asked if there is a way that she can check how many object in Salesforce using a lookup field i.e. Country in one place rather opening every object and checking if that field is there or not. – Rohan Sharma Jan 6 at 8:16
up vote 5 down vote accepted

One of the possible solutions could be the following:

you could use Force.com IDE and search your objects metadata for the wished field name. So you can get the quantity.

share|improve this answer
    
I have run the eclipse and it worked just fine with search all. But if I would like to refine my search for e.g. I want if that country field has a name as united kingdom can I run a query on developer console to find how many object has a company name as United Kingdom and at the same time get there record id as well. Thanks for all the help. – Rohan Sharma Jan 6 at 9:36
    
@RohanSharma You can search for labels <label>Field name</label> or just use a regular expression, it is really powerful. – Sergey Utko Jan 6 at 10:16

Perhaps less intuitive than you'd like, there is an app on the Salesforce AppExchange called Metadata Search which seems to do exactly what you want.

This says you can:

Quick search Approval Processes, Workflows, Validations, Fields, Objects, Reports, Dashboards, Custom Settings, Apps, Roles, Profiles, Permission Sets, Templates, Groups, Queues, Sites, Record Types, Assignments, Links, Classes, Triggers, Pages etc.

So it seems to do more than you're even asking for here.

share|improve this answer
    
Thanks lot App worked saved lot of time than Eclipse appreciated. – Rohan Sharma Jan 6 at 10:04

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.