Log in to AnswerLog in to Follow
Mahesh Rebba
13Views
1Comments
Can we use openjson in SQL query builder in outsytems?
Question
Reactive
Traditional Web
Application Type
Traditional Web, Reactive

Hi, Can any once suggest, How can we use openjson in SQL query builder in outsystems?

I have the sample query given below :

SET @json='{"name":"John","surname":"Doe","age":25,"Mdules":["ABC","LMN","OIO"]}';

SELECT *
FROM OPENJSON(@json);

got the exception:


0
0
on 16th Feb
Kilian Hekhuis
mvp_badge
MVP

Hi Mahesh,

I found this article that states the database needs to have compatability level 130 or up for OPENJSON to work. As far as I can check, Personal Environments have compatability level 120, and so do not recognize OPENJSON.

1
0
on 16th Feb
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.