You need to sign in to do that
Don't have an account?
SFDC@007.ax1656
Fetch picklist values through SOQL query?
1. Is it possible to fetch all the picklist field names along with the picklist field values available in Salesforce? Is there any object available in salesforce to query picklist values? Eg: Select Name From Picklist_Table ?
2. Using SOQL query is it possible to fetch the picklist values? instead of using getDescribe().getPicklistValues() through apex ?
I don't believe you can access picklist values through SOQL.
Here are some ideas:
1)
Check out workbench for reporting on metadata:
http://wiki.developerforce.com/page/Workbench
2)
Custom SOAP metadata API to describe objects and look for picklists and get values.
3)
appexchange packages such as : https://appexchange.salesforce.com/listingDetail?listingId=a0N300000018leZEAQ
Thanks,
Dan