I have 6 multi picklists.
I pushed all the selected values into Set
Assuming I selected all the values - Set will be :
Cherry;Apple, Apricots;Avocado, Banana;Blackberries;Blackcurrant
Which mean the Set is separated via ';' between the values in the same picklist, but between picklists it will be separated with ','
When I try now to use IN: in query, It kind of ruins me the query.
Any Idea how to replace everything to ';' or to ',' but not both?