You’re viewing Paradaux’s public workspaceSign in to vote Get taskl.ie for your team

PAR-211

Loading issues

PAR-211 · Search v2: comparator operators (date/number) + AND/OR… · Paradaux · taskl.ie

PAR-211· sub-issue of PAR-191

Search v2: comparator operators (date/number) + AND/OR combinator + shareable saved views

Remaining scope of the PAR-191 search epic after the v1 filter builder + per-user saved views shipped. These are cohesive feature work, not quick wins.

1. Comparator operators. tesks-ui/lib/filters.ts only models FilterOp = 'is' | 'isNot' and lib/sql/issues.ts conditionSql emits equality/negation only. To make due date and votes filterable (currently absent from FILTER_FIELDS) we need range/comparison ops: date before/after/on, numeric >/</>=/<=. Add the ops to the model, the SQL mapping, and the value editors (date picker / number input).

2. AND/OR combinator. Today conditions are implicitly AND-ed (lib/sql/issues.ts: loop of .where(...)). Add an explicit AND/OR grouping in the model + UI + SQL so e.g. "Priority is Urgent OR Assignee is me" is expressible.

3. Shareable / workspace-level saved views. Saved views currently persist only per-user in user_pref.prefs.savedViews[] (lib/sql/settings.ts, lib/actions/views.ts) — not shareable. Add workspace-level/shared views: a saved_view table (tenant-scoped, optional shared flag, owner), backend CRUD gated appropriately, and UI to publish/consume shared views.

Sibling: PAR-201 (JQL-style text query language over the same predicate model) — the power-user layer; do after the predicate model is richer (1+2).

Activity

tesks created the issue Jun 17
tesksJun 17
Progress shipped & browser-verified (tesks-ui b31e311): comparator operators + the due-date and votes facets.
- Model: FilterOp adds before/after/gt/lt; opsForField/fieldKind helpers; parseConditions accepts the wider set.
- SQL (conditionSql): due (due_date </>/= ::date, plus is-none) and votes (correlated sum over issue_vote, >/</=).
- UI: per-field operator options + a date/number value control; date/number fields always available (no option list).
Verified against a seeded DB through Playwright (the tesks-ui visual harness): due before/after/none and votes >/< return the correct result counts; the builder shows a date input + before/after for Due date and a number input + >/< for Votes; a UI-applied "Votes > 2" filtered to the expected 3 issues with the chip rendered.

Still remaining on this issue: AND/OR combinator (today conditions are implicitly AND-ed) and shareable / workspace-level saved views (today per-user in user_pref). JQL is the separate PAR-201.
ParadauxIO linked a commit: Commit b4d41bc — Shared workspace saved views: table + endpoints (PAR-211) Jun 17
tesks set status to Done Jun 17
tesksJun 17
Complete — all three pieces shipped & verified:
- Comparator operators + due-date/votes facets (tesks-ui b31e311) — browser-verified counts.
- AND/OR combinator (6d0781a) — Match all/any toggle; AND=1 / OR=5 verified.
- Shareable workspace-level saved views — backend saved_view table + settings.manage-gated endpoints (tesks b4d41bc, with tests) and UI (tesks-ui e5f274d): ★-chips read from the mirror, "Save shared" for managers; render/apply browser-verified, writes covered by backend tests.
JQL remains the separate PAR-201 (Backlog). Closing PAR-211.
ParadauxIO linked a commit: Commit b3d2863 — Search: comparator operators + due-date & votes filter facets (PAR-211) Oct 13
ParadauxIO linked a commit: Commit 431eb8f — Search: AND/OR combinator for filter conditions (PAR-211) Oct 13

Workspace permission required to comment

Comments and reactions require workspace permission. Ask a workspace owner or admin for access. You can sign in to vote.