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
