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

Referencing this post:https://community.intersystems.com/post/producing-json-sqlI'm not sure how to actually interact with the result set I get from doing something like this.  I want to return s

I am still new to cache objectscript and am trying to figure out how I would go about removing the escape characters from my JSON below. When I call the $toJSON method it's adding the "\" charact

I've tried this:        s status=msg.AttachFile("F:\MyDir","myFirstFile.pdf",1,.count)        s status=msg.AttachFile("

I wish to retrieve all the setting values for a given production. I have found   Set tSC=##class(Ens.Director).GetProductionSettings("EXC.EXC",.tSettings)    WHERE EXC.EXC is

I want to have a generic PercentOfAll measure that can be used for any dimension of the cube. This PercentOfAll should act like Count, but instead of showing the number of rows in a cell, it will show

Hi all,I have a class that I want to serialize to JSon. So I'm using the object %ZEN.Auxiliary.jsonProvider)
set myClass = ##class(myapp.myclass).%New()

set myClass.property1 ="value 1"

set myC