search

piccolo-orm / piccolo_admin

A powerful web admin for your database.
https://piccolo-orm.com/ecosystem/
MIT License
299 stars 35 forks source link

JSON filtering #355

Open dantownsend opened 7 months ago

dantownsend commented 7 months ago

It would be pretty cool to be able to filter the JSON.

The challenge with JSON is it could be infinitely nested.

{
    "facilities": {
        "room_1": {
            "microphone": true
        }
    }
}

So If you wanted to filter this the UI would have to let you specify that facilities -> room_1 -> microphone == true.

The query that gets submitted to Piccolo API would have to be some kind of JSON payload like:

{
    "path": ["facilities", "room_1", "microphone"],
    "value": true
}

This is what the UI could potentially look like:

piccolo_admin_json_filtering