CouchDB query table

Operator Type Operator Argument Purpose
(In)equality $lt Any JSON The field is less than the argument
$lte Any JSON The field is less than or equal to the argument
$eq Any JSON The field is equal to the argument
$ne Any JSON The field is not equal to the argument
$gte Any JSON The field is greater than or equal to the argument
$gt Any JSON The field is greater than the to the argument
Object $exists Boolean Check whether the field exists or not, regardless of its value
$type String Check the document field’s type. Valid values are “null”, “boolean”, “number”, “string”, “array”, and “object”
Array $in Array of JSON values The document field must exist in the list provided
$nin Array of JSON values The document field not must exist in the list provided
$size Integer Special condition to match the length of an array field in a document. Non-array fields cannot match this condition
Miscellaneous $mod [Divisor, Remainder] Divisor and Remainder are both positive or negative integers. Non-integer values result in a 404. Matches documents where field % Divisor == Remainder is true, and only when the document field is an integer
$regex String A regular expression pattern to match against the document field. Only matches when the field is a string value and matches the supplied regular expression. The matching algorithms are based on the Perl Compatible Regular Expression (PCRE) library. For more information about what is implemented, see the see the Erlang Regular Expression