Can this be used with InterSystems Cache?

Great work Chip, Robert

One question, are you using InterSystems IRIS or Cache?

I am using Cache and am not able to use the %VID, is there any alternative to the %VID value, as I need the row number (the %ID field is not a normal incremental ID).

SOLVED:

I just realised that I will need to use:
SELECT 
%VID FROM ( SELECT ID FROM TableName )

Thanks,

Rico.

Thank you so much Brendan,

I was able to use your example to understand and come up with a solution for my use case. I agree though with an ugly list of lists, it's not very easy to see the data in SQL, so am actually wondering if you can point me to bit and pieces how we can implement this in terms of child parent relationship?

Hi Brendan,

Is it possible to map a certain global node that might be a list i.e.

^Person(1)="Rico|2~Avenue Road~Woodville^4~Glacier Street~Victoria^1221~Vetta Road~Paramatta"

For example there, in the second node this is a list of addresses that the person used to lived in, where:

2=Street Number

Avenue Road=Road Name

Woodville=Suburban Name

So what I want is kind of map this to something like:

Class Person {

Property Name As %String; // map to ^Person(1) node 1, separator "|"

Property Addresses As List of Address;  // map to ^Person(1) node 2, separator "|", but then i want to split this into another list 

}

// this should map to the second global node separated by each "^"

Class Address {

Property StreetNumber As %String;

Property RoadName As %String;

Property SuburbanName As %String;

}

Please let me know if this is possible or if there is any alternative to do this, thank you.

Hi, is this supported for InterSystems Cache??

according to documentation, I believe that it should be by default producing the case that you want i.e. the full object https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls... , unless you specify the JSONREFERENCE Key to ID.

You can post your code so we can have a look together.