I am using the "any" predicate to fetch documents which belong to a relationship. I have a custom type called "Category" and have documents which can belong to none or one category. I thought using "any" would allow me to return documents that are either not categorised or are categories.
Returns 0 documents.
Returns 1 document.
Is it a case that I'd need to query twice and merge the results?