Content Type
Video
Duration
5m
Level
Introductory
Learn how to use serial objects in InterSystems IRIS® data platform to model reusable, structured data that is embedded directly within persistent classes. See how serial objects are defined, accessed in InterSystems ObjectScript, and stored on disk as nested data, and how that embedded structure is exposed as flattened columns in SQL.
| Reference | Timestamp | Code |
|---|---|---|
Define a serial Address class with generated storage mapping |
1:25 |
Begin code:
Class Hospital.Address Extends %SerialObject
{
Property Street As %String(MAXLEN = 100);
Property City As %String(POPSPEC = "City()");
Property State As %String(POPSPEC = "USState()");
Property Zip As %String(MAXLEN = 10);
Storage Default
{
<Property name="Street"/>
<Property name="City"/>
<Property name="State"/>
<Property name="Zip"/>
}
}
End code
|
Embed serial Address properties in a persistent Patient class |
1:45 |
Begin code:
Class Hospital.Patient Extends %Persistent
{
Property Name As %String;
Property HomeAddress As Hospital.Address;
Property WorkAddress As Hospital.Address;
Storage Default
{
<DataLocation>^Hospital.PatientD</DataLocation>
<Property name="Name"/>
<Property name="HomeAddress"/>
<Property name="WorkAddress"/>
}
}
End code
|
| Access a nested serial property using dot notation | 2:04 | Begin code:
Write patient.HomeAddress.City |
View embedded serial data stored in the Patient data global |
2:17 | zw ^Hospital.PatientD(1)
^Hospital.PatientD(1)=$1b
"John Smith",
$lb ("10 Main St", "Boston", "MA"
, "02110"),
11 11
) End code |
Query flattened serial object fields from the Patient table |
3:21 |
Begin code:
SELECT ID, Name,
HomeAddress_Street,
HomeAddress_City,
HomeAddress_State,
HomeAddress_Zip,
WorkAddress_Street,
WorkAddress_City
FROM Hospital.Patient;
End code
|
Having an issue with the learning site? Want to provide feedback on a course? Contact us by emailing online.training@intersystems.com.
Please include all relevant information, including the page or course you are having trouble with, and any necessary screenshots.