BookmarkSubscribeRSS Feed
Choose Language Hide Translation Bar
Highlighted
gshort

Community Member

Joined:

Jun 19, 2018

Database Query Builder + JSON

From what I've seen the Query Builder is not able to handle JSON. One it doesn't parse it, and two you cannot query the JSON because it hasn't been parsed.

 

So my question, is it possible to work with a column that has JSON in it just like it was structured data? Or can you only handle it by splitting up the JSON by building your own SQL statement?

 

For the environment it's JMP 13.2 and a PostgreSQL database.