Our World Statistics Day conversations have been a great reminder of how much statistics can inform our lives. Do you have an example of how statistics has made a difference in your life? Share your story with the Community!
Choose Language Hide Translation Bar
Highlighted
gshort
Level I

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.

1 REPLY 1
Highlighted
DanielM
Level II

Re: Database Query Builder + JSON

Any update to this?  Maybe with JMP 14?

Article Labels

    There are no labels assigned to this post.