Filters

In this guide, we'll explain how to use the $eq, $ilike, $in, and $not filters in queries to enhance your data retrieval capabilities.

Fields

Filter	Description	Example URL Parameter
$eq	Matches documents where the value of a field equals the specified value.	filter.name=$eq:John retrieves documents where the name field is exactly "John".
$ilike	Performs case-insensitive pattern matching.	filter.name=$ilike:john retrieves documents where the name field contains "john" (case-insensitive).
$in	Matches documents where the value of a field is within a specified array of values.	filter.status=$in:active,pending retrieves documents where the status field is either "active" or "pending".
$not	Matches documents where the value of a field does not equal the specified value.	filter.status=$not:inactive retrieves documents where the status field is not "inactive".

Example Request

GET /crops?filter.name=$eq:C