bknd-query-filter
Use when building advanced queries with complex filtering conditions in Bknd. Covers all filter operators ($eq, $ne, $gt, $lt, $like, $ilike, $in, $nin, $isnull, $between), logical operators ($or, $and), nested conditions, combining filters, and dynamic query building.
npx skills add majiayu000/claude-skill-registry --skill bknd-query-filter --agent claude-code
Same command for any agent — swap --agent for codex, cursor, copilot.
Weekly change comes from our own snapshots, not the repository page — it measures attention, not adoption.
# Advanced Query Filtering Build complex queries with multiple conditions, logical operators, and dynamic filters in Bknd. ## Prerequisites - Bknd project running (local or deployed) - Entity exists with data - SDK configured or API endpoint known - Basic understanding of `readMany` (see `bknd-crud-read`) ## When to Use UI Mode - Testing filter combinations before coding - Exploring data patterns - Quick ad-hoc queries **UI steps:** Admin Panel > Data > Select Entity > Use filter controls ## When to Use Code Mode - Complex multi-condition queries - Dynamic user-driven filters (search, facets) - Reusable query builders - API integrations ## Code Approach ### Step 1: Understand Operator Categories Bknd supports these filter operators: | Category | Operators | |----------|-----------| | Equality | `$eq`, `$ne` | | Comparison | `$gt`, `$gte`, `$lt`, `$lte` | | Range | `$between` | | Pattern | `$like`, `$ilike` | | Array | `$in`, `$nin` (alias: `$notin`) | | Null | `$isnull` | | Logical | `$or`, `$and` (implicit) | ### Step 2: Use Comparison Operators ```typescript import { Api } from "bknd"; const api = new Api({ host: "http://localhost:7654" }); // Equality (implicit $eq) const { data
- Prerequisites
- When to Use UI Mode
- When to Use Code Mode
- Code Approach
- Step 1: Understand Operator Categories
- Step 2: Use Comparison Operators
- Step 3: Use Range Operator ($between)
- Step 4: Use Pattern Matching
- Step 5: Use Array Operators
- Step 6: Use Null Checks
- Step 7: Combine with AND (Implicit)
- Step 8: Use OR Conditions
- Step 9: Combine AND + OR
- Step 10: Filter by Related Fields (Join)
Simple filter curl "http://localhost:7654/api/data/posts?where=%7B%22status%22%3A%22published%22%7D" curl -X POST http://localhost:7654/api/data/posts/query \
What does the bknd-query-filter skill do?
Use when building advanced queries with complex filtering conditions in Bknd. Covers all filter operators ($eq, $ne, $gt, $lt, $like, $ilike, $in, $nin, $isnull, $between), logical operators ($or, $and), nested conditions, combining filters, and dynamic query building.
How do I install it?
Run `npx skills add majiayu000/claude-skill-registry --skill bknd-query-filter --agent claude-code` — it drops the skill into your project so the agent can pick it up. Swap the --agent value for codex, cursor or copilot if you use one of those.
Where does this skill come from?
From majiayu000/claude-skill-registry, a repository with 534 stars. We read it straight from the repository tree rather than a submitted listing, so what you see here is what is actually published.
Is a popular skill a good skill?
Not necessarily. Stars measure attention, not adoption — a repository can trend for a week and be abandoned. That is why we show the weekly change from our own snapshots next to the total, instead of a single flattering number.
