Problem Statement: We created a custom metadata which has a field called programs. Since we cannot create multi-select field with custom metadata we have created a string field and stored all values semi-colon separated like below
User would select programs in UI like Healthcare Coverage, Food Assistance Program and we need to only show questions related to the selected programs from the metadata we created
Includes and Excludes will only work with multi-select field and i looked at this solution from adrian SOQL: Bulk Fuzzy Searching and it doesnt help for my case as its doing a exact search. How should the SOQL be so that if user selects 'Food Assistance Program','Cash Assistance' it should go query the metadata record as shown in the screenshot.