CouchDB Queries

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