You need to sign in to do that
Don't have an account?
SherryA
Using API for Queries
I'm maintaining some existing code that uses the API to make query calls to the db. (My background is a web developer using standard SQL). I have a query that I need to modify that uses a field that is a datatype of 'Picklist'. I need to get only rows where value in the picklist field starts with a certain value (perfect scenario for a 'like'). I don't want to hardcode a list of 6 values, plus I don't want to be tied to what my users might change later. It looks like I can't use a 'like' on this type of field? Can I get to id's of the picklist so I can use that so I don't hard-code values that my user could change? (I'm guessing I should just give it up and hard-code a list...but it looks like I can't use an 'in' either...correct?)
Thanks for any thoughts.
Benjamin_Pirih
Check this out..
http://www.salesforce.com/us/developer/docs/api/Content/sforce_api_calls_describesobjects.htm?Highlight=picklist|Picklist|picklists|Picklists|PICKLIST
it will show you have to parse over the items in a picklist.. not sure if this is what your looking for?
ChrisGountanis
How do you parse a specific picklist for example products under case?