Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Sell-On DevSell-On Dev 

How do I get a Sales Process selected stage values using SOQL

Does anyone know if it is possible to get the selected stage values using SOQL ... see screen shot below:

User-added image

My thoughts were that this information would be stored in a Picklist, but I have only been able to get to the various Sales Process values:

Find the FieldDefinitionId 
SELECT EntityDefinitionId, QualifiedAPIName, FieldDefinitionId FROM EntityParticle WHERE EntityDefinition.QualifiedApiName LIKE '%Business%' AND DataType = 'picklist'

Get the Picklist values based on the EntityParticleId which will equal the FieldDefinitionId​ 
SELECT DurableId,EntityParticleId,Id,IsActive,IsDefaultValue,Label,ValidFor,Value FROM PicklistValueInfo WHERE EntityParticleId = 'BusinessProcess.TableEnumOrId' ORDER BY label

How do you get those Selected Values ... if it can be done on the Sales Process page you would think you'd be able to use SOQL to get that information.

Thank you in advance for your time and input.
Best Answer chosen by Sell-On Dev
Sell-On DevSell-On Dev
I was able to get a solution for this with some help from JSforce.
Here are the details that I logged under a GitHub Issue: https://github.com/jsforce/jsforce/issues/672

All Answers

Shashikant SharmaShashikant Sharma
May be this post (https://salesforce.stackexchange.com/questions/120515/get-opportunity-stages-for-specific-sales-process) can help you.

Thanks
Shashikant
Sell-On DevSell-On Dev
I was able to get a solution for this with some help from JSforce.
Here are the details that I logged under a GitHub Issue: https://github.com/jsforce/jsforce/issues/672
This was selected as the best answer
Shashikant SharmaShashikant Sharma
Thanks for sharing details.