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 (JDB

Is there a way or can it be done to use conditional logic in sql like so    
Query Q1(formal as %String) As %SQLQuery [ Final ]
{
    
    SELECT pati

Hi,I know of the existance of (ELEMENTS) to create an index from a list, but I actually would like to index the content of an element of a list. Is it possible? My scenario:Class:Property Test As

I'm connecting to a remote device using TCP. It has a binary protocol.
set host = ""
set port = ""
set io = $io
set device = "|TCP|7000"

set timeout = 2
open device:(host:port:"M")
use device

Hi Community!When you run  IRIS container out-of-the-box and connect to it via terminal e.g. with:
docker-compose exec iris bash

You see something like:

root@7b19f545187b:/opt/app# irisses

I have one abstract class and several subclasses. All share one data/id global.How can I get concrete class name from id (without opening the object)?What I have so far:
write $p($lg(^DATAGLOBAL(<

what class or API I shall be using to execute a piece of sql to another server from one server? From within cache itself not java or python or any other languages. Anything like $System.SQL.%Conn

Here is an ObjectScript snippet which lets to create database, namespace and a web application for InterSystems IRIS:
```

set currentNS = $namespace



zn "%SYS"



write "Create DB ...",!

se

I have a need to dynamically create a web application definition in a namespace using ObjectScript.  I am having trouble finding a cache class or routine that let's me do this. Thanks

I am trying to get the time difference between two time stamps one is recorded earlier to the one happening current but the problem is sql expect string while I have the other stored in a variable and