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?
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.