search criteria issue

jrMugz

Greetings,

We have criteria we offer a user to search by based on Metadata fields. The Metadata fields values can differ. For example, a field called "Business Unit" can have over 50 values to choose from. The user can select multiple business units for the Search Query. So a Search Criteria string can look like this:

Keywords = “Some Keyword” AND Business Unit = “Food and Beverage” OR Business Unit = “Products”

The problem is that once you use the OR join you break the criteria into two sections with the first being:

Keywords = “Some Keyword” and Business Unit = “Food and Beverage”

And the second being:
Business Unit = “Products”

Is there a way to group the one metadata field values, so it would act like

Keywords = “Some Keyword” AND (Business Unit = “Food and Beverage” OR Business Unit = “Products”)?


Also creating a separate group of criteria for each choice is not an option because there are 4 other metadata fields with choices that the user can select multiple values for. So a Criteria String can look like this:

Keywords = “Some Keyword” AND Business Unit = “Food and Beverage” OR Business Unit = “Products” AND uploader = “John Doe” or uploader = “Jane Doe” AND asset type = “Image” OR asset type = “Video”

Please let me know if there is a way to work around this. Thanks!

Jim

Rick Poulin

Keywords = “Some Keyword” AND (Business Unit = “Food and Beverage” OR Business Unit = “Products”)

Just to clarify, have you actually tried that syntax? It's been a while since I've built something with the MB API, but it seems to me like that would be the right way to do it. Parens are a pretty standard thing in boolean queries, and that's how LSCS does it.