Wildcard search multi select fields

Question

Is is possible to use wildcards in where statements on multi-select fields

I tried a simple

Select Id, Name from Positions_c where Industry_c includes(:selectedIndustry)

this works

but if i want to pass a wildcard in with :selectedIndustry it breaks?

Answer 1

You have to combine the use of LIKE and % in collections.

You have to populate the sets with % first and then use LIKE to query.

    setAccNames.add('%'+'ABC'+'%');
    setAccNames.add('%'+'XYZ'+'%');
    setAccNames.add('%'+'RST'+'%');

    List<Account> accList = [SELECT Id FROM Account WHERE Name LIKE :setAccNames];

Here's more on this:

https://sfdcfanboy.wordpress.com/2016/03/01/use-like-and-in-in-a-single-soql-query/

Answer 2

I don,t think that you can use wild card with the include tag in SOQL but you can use the query in two ways :

1. Industry_c Like :'%'+selectedIndustry+'%'

2.Set<String> industryValues = new Set<String>{'%selectedIndustry'};

 Select Id, Name from Positions_c where Industry_c includes(:industryValues)