bknd-query-filter

Dynamic query filters in BKND are built using operators like $eq, $ne, $gt, $lt, $like, $ilike, $in, $nin, $isnull, and $between to construct precise comparison conditions for data operations. Logical groupings with $and and $or allow composing complex WHERE clauses.

Yes, combining AND and OR conditions for joined entities is supported in BKND. You can group criteria using $and and $or operators to create complex decision trees, enabling cross-entity joins to filter records by related fields across multiple connected collections.

The $like and $ilike operators in BKND queries enable pattern matching for string values, with $ilike providing case-insensitive matching. These operators are applied within filter objects to retrieve records where specific fields match desired textual patterns.

BKND supports filtering by value lists using the $in and $nin operators, and checks for null fields using the $isnull operator. This allows queries to include or exclude records matching any value within a specified array or identify missing data.

To filter records within a specific range in BKND, use the $between operator. This operator allows queries to match values that fall inside a defined minimum and maximum boundary, useful for numerical or date-based data retrieval.

Complex dynamic readMany queries may fail if filter operators are incorrectly nested or if logical groupings like $and and $or are improperly structured. Ensure all operator conditions and joined entity filters are correctly composed within the WHERE clause.