How to change the Address in InterSystems Trakcare for Objectscript

Question

Question

steven Henry · Jul 10

#Dashboards #Databases #ObjectScript #SQL #Global Masters #InterSystems IRIS #InterSystems IRIS for Health #TrakCare

Hello my friends,

I have a problem with Objectscript, why the value of address become like this ?

everything works fine except the Address,

this is my code, do I need something to make this into real address ? should I put something in my code ?

set paper=obj.PAADMPAPMIDR.PAPMIPAPERDR

if '$isobject(paper) continue

set Address=paper.PAPERStName

thank you for your help

Best Regards,

Steven Henry

Product version: HealthShare 2025.1

$ZV: IRIS for UNIX (Red Hat Enterprise Linux 8 for x86-64) 2023.1.1 (Build 380_0_23762U) Fri Oct 18 2024 17:32:14 EDT [Health:5.1.0-1.m1]

Discussion (3)2

Log in or sign up to continue

Chris Stewart · Jul 10

Hi Steven

This property is showing as a Collection property, so it needs to be unpacked to be read as text.

The documentation on processing List properties is available at: https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls...

1 0

steven Henry · Jul 10

I just put GetAt(1) and it works

this is the correction that I've been made :

set Address=paper.PAPERStName.GetAt(1)

0 0

score 0 · Answer 1 · 2025-07-11T02:06:54-04:00

From a performance aspect i would not use objects to retrieve the data, but use SQL.

SQL will take care of the conversion for you.

e.g.

select PAADM_PAPMI_DR->PAPMI_PAPER_DR->PAPER_StName
from SQLUSer.PA_Adm
where
PAADM_Hospital_DR = 2
and
PAADM_AdmDate>='19/03/2025'
and
PAADM_AdmDate<='19/03/2025'