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:
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.