+ Start a Discussion
Ewa FrystEwa Fryst 

running a query on field value

Hi All,

I wanted to run a query on a Opp Stage value = Closed Won. I wanted to see in what automation tools that value is used. Is it possible to do that in Developer Console and if yes, could someone helo me with the query?
Many thanks in advance
Ewa
PrasathPrasath
Hi Ewa,

We can do that in the Developer console. go to query editor and run the below query,
 
SELECT Id, Name, StageName FROM Opportunity WHERE StageName = 'Closed Won'

I hope you find the above solution helpful. If it does, please mark as Best Answer to help others too.

Thanks and Regards,
Prasath
Ewa FrystEwa Fryst
Hi Prasath, 

That worked, thank you. But all i got was all the opportunities that has Closed Won Stage. I wanted to see what automation tools use that value. Is that possible?
PrasathPrasath
Did you capturing that automation tools name in Opportunity? If yes then we can!
Ewa FrystEwa Fryst
I'm sorry, i'm not sure what you mean. What i want is to see which process builder or workflow is using the Closed Won value as a criteria
PrasathPrasath
No that is not possible.
Maharajan CMaharajan C
Hi Ewa,

Using Eclipse Force.com IDE you can achieve this. 

Get the Salesforce Metadata files in your Eclise then from Eclipse use the Search  to find your Values where it is used.

Link to creates the salesforce Metadata files 

https://developer.salesforce.com/docs/atlas.en-us.eclipse.meta/eclipse/eclipse_quickstart.htm

https://mytutorialrack.com/force-com-ide-improve-the-performance-of-force-com-eclipse-ide/ 


Can you please Let me know if it helps or not!!!

If it helps don't forget to mark this as a best answer!!!


Thanks,
Maharajan.C