[SalesForce] Get a list of Pick List Values

Via the SOAP API, can I get a list of the Pick List values from an Objects Field's type that is a pick list?

For example,

The Object Opportunity has a field called Type which is a Picklist. I would like to be able to query this Pick List. Is is possible?

Best Answer

Yes, you can. There is a method called describeSObjects() which can be used to retrieve picklist values.

https://developer.salesforce.com/docs/atlas.en-us.api.meta/api/sforce_api_calls_describesobjects.htm

A code example is also provided there. Here an excerpt:

        // Determine whether this is a picklist field
        if (field.getType() == FieldType.picklist)
        {                            
            // Determine whether there are picklist values
            PicklistEntry[] picklistValues = field.getPicklistValues();
            if (picklistValues != null && picklistValues[0] != null)
            {
                System.out.println("\t\tPicklist values = ");
                for (int k = 0; k < picklistValues.length; k++)
                {
                    System.out.println("\t\t\tItem: " + picklistValues[k].getLabel());
                }
            }
        }

Related Solutions

[SalesForce] Query single pick list with values from multi select pick list

Multi-select picklists look like a semi-colon delimited string to your code. So, you can just use split(';') to get an array of all the picklist values. You can then use the IN operator.

SELECT Name from Object__c where PicklistField__c IN :multselect.split(';')

[SalesForce] Trigger to validate selection of Pick-list values

Can you try the following code.It should work.

trigger Triggertovalidate on category__c (BEFORE INSERT,BEFORE UPDATE)
    {
        LIST<category__c> li = [select id,type from category__c where type != null]; 
        for(category__c c :trigger.new)
        {
         if(c.type != null){
          for(category__c existrecord :li)
          {
              if(existrecord.type == c.type){
              c.Type.adderror('Type is already used please select another one.');//If you need specify the SObject field also
              }
          }
         }
        }

    }

Best Answer

Related Solutions

[SalesForce] Query single pick list with values from multi select pick list

[SalesForce] Trigger to validate selection of Pick-list values

Related Topic