I have a single pick list and multi select pick list. Now, in order to query multi select pick list, you use include (:var) syntax. My situation is quite opposite - I wish to query single pick list with values from multi select pick list.
Is it possible? I suspect I need to breakdown the multi select into multiple variables and then do a dynamic SOQL query, but I though I will ask you guys first. If so, how do I break down the multi select pick list?
Or perhaps it is possible to use LIKE syntax, which doesn't make much sense.
Thanks.