You need to sign in to do that
Don't have an account?
Stefaan Somers 12
search on multipicklist
Hi,
I have a visualforce page where you can type in a search term.
In Apex code I want to search for this term in my Salesforce-records on all fields, so also in a multipick-list field.
For example, I have a multi-picklist field with the following values :
- Value Test
- Value Other
- Valuet Test2
So when I search on 'Test' I should retrieve the records that have the first or the third value.
How can this be obtained in SOQL or SOSL, making use of a bind expression
I have a visualforce page where you can type in a search term.
In Apex code I want to search for this term in my Salesforce-records on all fields, so also in a multipick-list field.
For example, I have a multi-picklist field with the following values :
- Value Test
- Value Other
- Valuet Test2
So when I search on 'Test' I should retrieve the records that have the first or the third value.
How can this be obtained in SOQL or SOSL, making use of a bind expression
As mentioned in the below article you could use the query that indicates either one is present:
>> https://help.salesforce.com/articleView?id=000334304&type=1&mode=1
Select id, name from Account where MSP1__c includes('AAA', 'BBB','CCC')
You could use the above query to work on multi select picklist.
I hope this helps and in case if this comes handy can you please choose this as best answer so that it can be useful for others in the future.
Regards,
Anutej
>> https://salesforce.stackexchange.com/questions/180835/query-based-on-multi-select-picklist
>> https://developer.salesforce.com/forums/?id=906F0000000BY0HIAW
As mentioned in the documentation (https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_select_comparisonoperators.htm?search_text=like)like operator can only be used with string fields, you can raise a new idea or upvote to an existing one in case if you think this feature could be useful for others as well.
I know this syntax, but I get the search-term as a variable in the apex-method. So I need to use this term then as a parameter in the SOQL query through a bind variable. I can already get a list of picklistvalues which contains this term, but I cannot use a List<String> as bind parameter in the SOQL query