Share Your Experience With Others

How to see all picklist controlling fields ( dependencies ) using SOQL

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’

2 responses to “How to see all picklist controlling fields ( dependencies ) using SOQL”

  1. Kalerine Avatar
    Kalerine

    This is great!. How do I get the controlling value and not just the controlling field name?

    Like

    1. Kamaal Ahmad Usmani | Salesforce Certified Developer & Data Cloud Consultant | Avatar
      Kamaal Ahmad Usmani | Salesforce Certified Developer & Data Cloud Consultant |

      For values just play with the query, meanwhile I’ll also check it.

      Like

Leave a reply to Kamaal Ahmad Usmani | Salesforce Certified Developer & Data Cloud Consultant | Cancel reply