BookmarkSubscribeRSS Feed
Choose Language Hide Translation Bar
Highlighted
gshort
Community Member

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.

0 Kudos
1 REPLY 1
DanielM
Community Member

Re: Database Query Builder + JSON

Any update to this?  Maybe with JMP 14?

0 Kudos