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.

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 there, you should be able to install IRIS from the following link:
https://download.intersystems.com/download/login.csp
To get started with learning, this link would be very helpful:
https://learning.intersystems.com/totara/dashboard/index.php

If you create an account, you will be able to see a whole lot of dashboard to help you getting started.
https://learning.intersystems.com/totara/dashboard/index.php