Hi,
I need some help with extracting data from json.

I have the following jsonb field

modules
{
   "accounts":     {"status": true},
   "admin":        {"status": true},
   "calendar":     {"status": false},
   "chat":         {"status": true},
   "contacts":     {"status": true},
   "dashboard":    {"status": false},
   "help":         {"status": true}
}

How can I convert that into one row each based on status; for example if I
only want to have the active modules.

Only true

module    | status
----------+-------
accounts  | true
admin     | true
contacts  | true
help      | true

Thanks for any advise

Reply via email to