Don't miss out Virtual Happy Hour this Friday (April 26).

Try our conversational search powered by Generative AI!

ImageVault - Using 'OR' in 'where' query

Vote:
 

Hello,

We would like to check if a media item is present in a list of categories.
So it should be available in category 'A' OR category 'B' OR category 'C'.
We've tried several constructs using a Linq query but the Linq implementation seems limited. It doesn't seem to support OR operations.
The only thing that seems to work is m => m.Categories.Contains(id) or ContainsAll() which seems to construct an AND operation.
We could merge the result of several queries but then we would lose paging.

What would be the best way to approach this?

Regards,

Robert.

#139533
Oct 06, 2015 8:46
Vote:
 

Hi,

The query language does not support OR clauses in the category filter. To achieve the desired result, you need to create multiple queries and join them on the client.

Advanced queries are something that will be introduced in ImageVault during the next year.

/Dan

#140267
Edited, Oct 14, 2015 14:45
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.