Json OrWhere with other Filters ?
Suggestions on how to perform a subquery with a json field for multiple responses? I'm currently running into something like this:
Company table - json field with attributes for type of activities a business is interested in.
I want to be able to select something - like say a region where a company is as a filter (which works) but then say interested in team building, or direct sales, or whatever . . . but I want the businesses that have team building and I want the ones that have said direct sales. My filter should be an orwhere but it's against the json field.
Company table - json field with attributes for type of activities a business is interested in.
I want to be able to select something - like say a region where a company is as a filter (which works) but then say interested in team building, or direct sales, or whatever . . . but I want the businesses that have team building and I want the ones that have said direct sales. My filter should be an orwhere but it's against the json field.
