You need to sign in to do that
Don't have an account?
bdegraf
SOQL "like" query on picklists
I can't find a way to find accounts whose value from a picklist START WITH a particular string. That forces me to check for all the possible values that start with it. E.g. we have Merchant: Active, Merchant: Prospective, Merchant: Committed.
It also means the code won't be forward-compatible if we add another Merchant type.
Is there no way to query for all that start with "Merchant", or even INCLUDE "Merchant" would be better than hard-coding all possibilities.
It also means the code won't be forward-compatible if we add another Merchant type.
Is there no way to query for all that start with "Merchant", or even INCLUDE "Merchant" would be better than hard-coding all possibilities.
Not sure if it would apply in your scenario, but thought it was worth suggesting.
If I cant do category__c LIKE '%value%' Then what are my options for pulling data like this?
the category__c field is a picklist. my users can select 0-15 values for this field. but i need to be able to pull any record that could have value 'x' in category_c. whether category_c = 'x' or 'x;y;z' or 'a;b;c;x;y;x'
what are my options?
Have you begun to support LIKE operations on pickilsts - in some way yet?
You could use IN and NOT IN on picklists.