Needing to know how to define a property that can either be sent in my response as 

"members": null,

or 

"members": [
                {
                    "dob": "1905-05-01",
                    "firstName": "BOB",
                    "middleName": "T",
                    "nameSuffix": "",
                    "genderCode": "M",
                    "lastName": "COLLINS",
                    "memberId": "123421741",
                    "relationship": "Subscriber"
                }
            ],

I'm looking for a SQL function equivalent for SQL server STRING_SPLIT.   I have records like this:

join_to_tx_history (key), ss_note_multi_dict_1_value (varchar)

and I like the field ss_note_multi_dict_1_value split to rows for each comma delimited value.  So I can get this:

We're working hard to bring you the learning content you need -- help us by taking this 2-min survey to tell us what you're looking for!

Hello Community,

We want to send ALL updates from our Cache server to a remote SQL Server instance that will be used as a reporting data warehouse.

Has anyone done this already and if so what is the best way to go about setting this up?

Thanks

Regards

Mike 

Hi! I have a promblem with ##class(%File).Exists -method and scandinavian characters.

Ensemble: Cache for UNIX (Red Hat Enterprise Linux for x86-64) 2018.1.2 (Build 309_5U)

I have a business service (EnsLib.EDI.XML.Service.FileService (charset=binary)) which reads XML-files from the server and transmits those to the business process. BP request class is EnsLib.EDI.XML.Document. In BP I have code block 

Can we use BI.OCR as a plugin for some application platform such as JAVA and .Net

objects in javascript :

var oM = new Object;

var mMode=["down","up","click"] ;
var key,val ;
    for (key in mMode)
    {

       val = mMode[key] ;
        oM[val]={} ;
        oM[val].id   ="" ;
        oM[val].type ="" ;

       ...

 }

so I can access the .type directly as :

oM.down.type

or:

oM["down"].type

what is the syntax in CACHE or IRIS, to achieve such approach via class/key/property...?

acctually: class/object/key/property anlaogue to ^GLOBAL(key,"property")=val

Hi  Developers,

A new video is already on InterSystems Developers YouTube:

⏯ Getting Started with HL7 Routing Rules