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 filters price between 10 and 50 with range:{gte:10, lte:50} on the price payload key.

Use range with gt/gte/lt/lte on a numerically-typed payload field that has a float/integer payload index. Confirm the field is stored as a number (not a string) so the range index applies; mixed types silently exclude points.