Skip to content

Request for ability to filter json type columns #687

@mathiaswillburger

Description

@mathiaswillburger

Current behavior

It is not possible to filter table columns with JSON format in the same way as other column types. Attempts to apply filters behave differently or fail.

Feature request

It would be useful to support filtering on JSON content just like on text columns. This would allow searching inside JSON values directly from the UI, without having to write custom queries.

Example

Being able to search within a JSON column for a specific value (e.g. finding rows where a JSON field contains "email":"something@example.com").

Steps to reproduce

  1. Database table with one column type "json" defined (in this example "field_differences")
  2. Tested with PostgreSQL
  3. Follow these steps:

Image

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions