Loading pattern preview
BlocksTools & Utilities
Jev Table Query
Jev Table Query
Filter or sort a closed table with one Jev question per row. A column name never leaves the app.
Loading pattern preview
Problems solved
Technical challenges this implementation handles out of the box.
- Filter a closed table with one boolean per row
- Sort rows by a score for an axis the columns do not have
- Sort a named column in application code
Use cases
Products and workflows this pattern is designed to support.
- Natural-language filters over a known table
- Ordering rows by a phrase that is not a column
- Teaching when a column sort should skip the model
Setup
Requirements, wiring steps, and what this pattern adds to your project.
Getting started
Pick how you want to pull this pattern in. Then wire env vars and routes the same way.
- 1
Download → Next.js app
Use Download → Next.js app in the preview toolbar. You get a zip scaffold (Pro downloads rewrite preview `/view/.../api/*` paths to `/api/*` automatically).
- 2
Extract the zip and install dependencies
Unzip the archive, then run `pnpm install` (or npm / yarn) in the project folder.
- 3
Fill .env.local
The download includes .env.local placeholders when needed. Add real values for: AI_GATEWAY_API_KEY.
- 4
Customize the agent and tool files
Adapt prompts, tools, and stop conditions in the generated project for your product.
- 5
Run the app and open the pattern route
Run `pnpm dev`, open the setup/checklist page if present, then navigate to the generated pattern route and verify responses.
Environment variables
AI_GATEWAY_API_KEYGet key
Capabilities
AI SDK APIs
experimental_evaluateProviders
Jev
External services
gatewayvercel-ai-gatewayUpstash
Files added
13 filesapp/page.tsxapp/layout.tsxapp/api/query/route.tscomponents/table-query-demo.tsxcomponents/query-table.tsxcomponents/typesafe-ai.tsxhooks/use-table-query.tslib/table.tslib/query-questions.tslib/query-policy.tslib/rate-limit.tslib/request-utils.tsREADME.md
Dependencies
8 totalnpm packages
6UpstashAISDKlucide-reactmotionNext.jsReact
Registry components
buttontable
Critical files
lib/query-policy.tsPure policy: decideFilter keeps a row only when P(fit) >= 0.70. decideRank orders by score descending, keeps table order on ties, and sinks a missing score. resolveColumnSort handles a bare column alias in the app. Do not call Jev from unit tests. Use Experimental_EvaluationMockModelV4.
lib/query-questions.tsbuildFilterQuestions writes one boolean per row. buildRankQuestions writes one four-level score per row. MATCH_FLOOR is 0.70 and stays in application code.
lib/table.tsClosed invoice table. Jev may only answer these row ids. Do not let the model invent rows or columns.
query/route.tsRate-limited experimental_evaluate call through AI Gateway model typesafe-ai/jev with zeroDataRetention. Rejects a column-alias sort. The rows are not in the request. Returns decideFilter or decideRank, never edited cells.
Requirements
- Complexity
- Beginner
- Setup time
- ~5 minutes
- Node
- 24+
- Memory
- 256MB
Upstash Redis for deployed demo rate limiting
