If you want all values in picklist field on object then it is not possible from SOQL. You need to use the describe call.

Here is the code :

            //use GlobalDecribe to get a list of all available Objects
            Map<String, Schema.SObjectType> gd = Schema.getGlobalDescribe();
            Set<String> objectKeys = gd.keySet();
            for(String objectKey: objectKeys)
            {
                //Iterate through all objects to locate ACCOUNT Object
                if (objectKey == 'account')
                {
                    Schema.SObjectType systemObjectType = gd.get(objectKey);
                    Schema.DescribeSObjectResult r = systemObjectType.getDescribe();
                    Map<String, Schema.SObjectField> M = r.fields.getMap();
                    Set<String> fieldNames = M.keySet();
                     //iterate through all fields of the object to locate the field
                    for(String fieldName: fieldNames)
                    {
                        if (fieldName == 'industry')
                        {
                            Schema.SObjectField field = M.get(fieldName);
                            Schema.DescribeFieldResult fieldDesc = field.getDescribe();
                            //extract the picklist values
                            System.debug(fieldDesc.getPicklistValues() + ' ::::::::::::::::::::::::::::::::::: ') ;
                        }
                    }
                }
              }

 You can change the object name here :

 if (objectKey == 'account')

 And the picklist field name here :

if (fieldName == 'industry')

Thanks

Ankit Arora

Blog | Facebook | Blog Page