I have a quota called Service. I have a field called profile_category which can have multiple values like "Dining,Bar Service,Catering".
I have a quota called Category with profiles named with the possible profile_category values (Dining, Bar Service, etc.). On these profile index pages I want to list 5 Service profiles with a profile_category value which equals $profile_name. For instance, on the Dining profile index page I want to list 5 Service profiles that have chosen Dining as a profile_category.
I can use search2="profile_category = `$profile_name`" as long as profile_category has only one value, but if a Service profile choose more than one category (like Dining,Bar Service,Catering) that won't work.
What's the answer?
updated by @blindmime: 08/08/15 09:01:24AM