jakob / jakob/Postico

Can't filter (contains, does not contain) for JSON columns

Open
#429 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
485
Forks
8
PR merge metrics
No merged PRs in 30d

Description

Can't search for values in a JSON column based on key/value pairs.
I attempted to search based on the string representation (e.g. "supplier_id":"") but that doesn't work.

Contributor guide

No contributing guide indexed for this repository

Research direction

The issue names no files, tests, or entry points. Start by reproducing the JSON-column filtering case described, then locate the filtering and query-building code. Done means contains and does-not-contain filters can search JSON columns by key/value pairs.

Written by the indexing model from the issue text.

Assessment

Tech stack
python
Domain
database
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
42/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.