1
 Follower
2
 Likes

Support for JSON data type column

Backend
On our radar

It would be really useful if we could have JSON type columns supported in the database

Created on 31 Mar 2017
Comments (4)
10 Apr 2017

Hi Hanno,

Can you elaborate on the use case? Please add as much detail as you can so that we can understand the underlying problem that would require this. Thanks!

14 Apr 2017

Hi André

We are referring to the SQL 2016 functionality, where one would be able to use for example the JSONVALUE() function of SQL to query a column storing JSON text.


19 Apr (5 days ago)

Hanno, how are you storing the JSON now? Are you just storing it in a 'text' type? 


Also, is there any library that can decompose a JSON string? 


Sorry for the 'noob' question, very new to Outsystems.

19 Apr (5 days ago)

Hi David

Yes, we are storing it straight up as text type.

You can use the JSONDeserialize component to convert JSON to any OutSystems object

views
94
Followers
1