What operators are supported in Bknd query filtering?

Bknd supports a wide range of operators including equality ($eq, $ne), comparison ($gt, $lt, $gte, $lte), range ($between), pattern matching ($like, $ilike), array membership ($in, $nin), and null checks ($isnull).

Does this skill provide React integration examples?

Yes, the skill includes a complete React component example demonstrating how to use the Bknd SDK with hooks and debounced search inputs.

How do I combine multiple conditions with OR logic?

You can use the $or operator which accepts an array of condition objects. If any condition in the array is met, the record will be included in the results.

Can I filter results based on related data?

Yes, by using the 'join' property, you can filter results based on fields in related entities using dot notation, such as filtering posts by their author's role.

How do I perform a case-insensitive search?

Use the $ilike operator for case-insensitive pattern matching, which is the preferred method for implementing user-facing search fields.

Bknd Advanced Query Filtering

Name: Bknd Advanced Query Filtering
Author: cameronapak

bycameronapak

•

データベース管理

Enables advanced data retrieval in Bknd.io projects using complex filter conditions and logical operators.

概要

The bknd-query-filter skill empowers developers to build sophisticated data queries within the Bknd.io ecosystem. It provides comprehensive guidance on utilizing various filter operators such as equality, range, and pattern matching, alongside logical AND/OR nesting and relational joins. This skill is essential for developers moving beyond basic CRUD operations to create dynamic search interfaces, faceted navigation, and complex business logic filters in both frontend and backend environments.

主な機能

Advanced pattern matching using case-sensitive $like and case-insensitive $ilike
Cross-entity filtering using relational joins for deep data queries
Complex logical nesting with $or and implicit $and conditions
Dynamic query building patterns for programmatic filter generation
Comprehensive operator support including $eq, $ne, $between, and $isnull
1 GitHub stars

ユースケース

Creating complex data dashboards that require filtering by date ranges and status flags
Building an e-commerce faceted search with price ranges and category filters
Implementing a multi-field user search system with case-insensitive matching

概要

主な機能

Advanced pattern matching using case-sensitive $like and case-insensitive $ilike
Cross-entity filtering using relational joins for deep data queries
Complex logical nesting with $or and implicit $and conditions
Dynamic query building patterns for programmatic filter generation
Comprehensive operator support including $eq, $ne, $between, and $isnull
1 GitHub stars

ユースケース

Creating complex data dashboards that require filtering by date ranges and status flags
Building an e-commerce faceted search with price ranges and category filters
Implementing a multi-field user search system with case-insensitive matching