Can anyone help with the query
I have two tables DateVal where Date is stored and details where (…“overall_status” : “verified”) / rejected is present.
How shall I extract overall_status using JSON extract and visualize it ?
Hi @Bhaumik
Without knowing which database you are querying, then it’s hard to know, but I would recommend that you ask in a forum specific to your database or stackoverflow.com
If it helps, I’ve been using this to test my JSON queries (I’m using Talend to extract REST to Postgres):