SELECT EntityParticle.DeveloperName, Label, Value, IsActive, EntityParticle.IsDependentPicklist, EntityParticle.FieldDefinition.ControllingFieldDefinition.DeveloperName
FROM PicklistValueInfo
WHERE EntityParticle.EntityDefinition.QualifiedApiName = ‘Account’
AND EntityParticle.IsDependentPicklist = TRUE
ORDER BY EntityParticleId, Label
Use the relevant object API name here EntityParticle.EntityDefinition.QualifiedApiName = ‘Account’
Leave a reply to Kamaal Ahmad Usmani | Salesforce Certified Developer & Data Cloud Consultant | Cancel reply