Published on InterSystems Developer Community (https://community.intersystems.com)

Home > How to return JSON Array in SQL request for a List Property?

Question
Evgeny Shvarov · Feb 13, 2019

How to return JSON Array in SQL request for a List Property?

Hi Community!

Suppose I have a property in a ObjectScript class:

Property values As list Of %String

What an SQL query can help to return the values of the property as JSON array via SQL access (JDBC)?

#JSON #SQL #Caché #InterSystems IRIS

Source URL:https://community.intersystems.com/post/how-return-json-array-sql-request-list-property