Payload Filtering

Agent wants products that are in_stock AND (red OR blue) AND NOT discontinued, and writes filter={must:[in_stock], should:[red, blue], must_not:[discontinued]}.

must = AND (all conditions required), must_not = NOT (none may match), should = OR (at least one). Note should alone behaves as OR; to require 'in_stock AND (red OR blue)' nest the should inside a must clause so the OR group is itself required. Verify nesting produces the intended boolean tree.

Agent filters where category is one of ['books','music','games'] and writes match:{any:['books','music','games']} on the category key.

Use match:{value:x} for a single value and match:{any:[...]} for set membership (OR over values on one key). There is also match:{except:[...]} for exclusion. Pick the right match variant rather than building three separate should clauses for one key.

Agent finds points whose tags array has at least 3 entries using values_count:{gte:3} on the tags key.

Use values_count with gt/gte/lt/lte to filter by the number of values in an array payload field. This counts elements, not their content. Combine with match conditions if both cardinality and membership matter.