Is it possible to nest ANDs and ORs in where filters?
I would like to fetch documents where wordCount is between 20 and 500 and myId is in a given list, e.g. 1, 2, 3. In SQL I would use the following WHERE clause: WHERE wordCount >= 20 AND wordCount <= 500 AND myId IN (1, 2, 3)
At this point I have the following where filter, but I can’t figure out how to add the myId filter.
I personally like to test individual filters to make sure they work and then combine them. Let me know how you go with this page - we recently added it so we’d love to hear what you think!
Perfect thank you for your help. That page was very helpful. I think we need to find a good way to link to it from GraphQL - Conditional filters | Weaviate - vector database so it is easier to discover it. Otherwise I really like that new page, it is short and to the point and builds well on top of the other Conditional Filters page.