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



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.

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



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.