Ensemble | InterSystems Developer Community

Question

How to convert date in "YYYY-MM-DDTHH:MM:SSZ" format to "yyyymmddhhmmss" format?

I'm trying to convert date - 2023-09-28T20:35:41Z to BST/GMT format. I tried with $ZDT($ZDTH("2023-09-28T20:35:41Z",-2),8,1) but it's giving the output as '19700101 01:33:43' and looks link the date format in $ZDTH specified is wrong. Any inputs or solution would be appreciated.

#Caché #Ensemble #Global Masters #Health Connect #HealthShare #InterSystems IRIS

0 4

0 126

Question

Krishnaveni Kapu · Sep 3

$ZDATETIME($h,3,1,3)

Hi,

I am using this "$ZDATETIME($h,3,1,3)" and getting response as 2024-09-03 12:07:45.000
But I need proper values at the end instead of zeros (000)

Something like below -
2024-09-03 12:07:45.658

#Ensemble

1 6

0 122

Question

Colin Brough · Aug 30

Changing a Setting value on a schedule?

I can START and STOP a business process via its Schedule setting.

Is it possible to change the value of another Setting in an analogous way?

I can imagine a SettingSchedule that could look like

action:YYYY-MM-DDThh:mm:ss[,action:YYYY-MM-DDThh:mm:ss]

But rather than just START or STOP, action could be "SET Setting = value", overriding whatever the normal value is.

Is there an existing way of achieving this kind of functionality?

#Tips & Tricks #Ensemble

0 4

0 95

Question

water huang · Sep 1

how to kill %SYSTEM.WorkMgr process

i use %SYSTEM.WorkMgr to handle data by multicompile=1,but i find that,after WaitForComplete,the processes created by %SYSTEM.WorkMgr are still stand by,

#Caché #Ensemble

0 4

0 93

Question

Krishnaveni Kapu · Sep 16

padding zeros to the desired length

I receive a number as input

length = ln = 7

if input = 25
I need to add zeros to make make it as - 0000025 (a total length of ln)

if input = 9
I need to add zeros to make make it as - 0000009 (a total length ofln)

#Ensemble

1 6

0 87

Question

Maxime LACH · Sep 19

Latency with VS Code 1.93 for "Import and Compile"

Hello,

Since version 1.93 of VS Code, the “import and compile” process has been very slow (more than an hour).
Have you encountered this issue and do you know how to resolve it?

Thank you,

Maxime

#Compiler #VSCode #Ensemble

1 6

0 71

Question

Krishnaveni Kapu · Aug 23

String to HL7 format

I have a requirement where in I had to read a HL7 message string ( which is a String )
from a SQL TBL to my Business Service.
and I need to convert that string to EnsLib.HL7.Message format and traverse through the PID segment.

I need some inputs please.

#Business Service #HL7 #HealthShare #InterSystems IRIS for Health #Ensemble #Health Connect

0 1

1 74

Question

john smith · Sep 15

Method doesn't Exist in Ensemble 2018

Hi guys,

we converted from Ensemble 2014 to 2018 and now getting the attached error which looks like Manage Method don't exist anymore, has it been replaced by a new one?

Thanks

#Ensemble

0 2

0 69

Question

Patty Aguirre-Romero · Sep 11

Change Date Format from YYYYMMDDHHMMSS to YYYYMMDD in a DTL

Greetings,

Is it possible to change the date format from YYYYMMDDHHMMSS to YYYYMMDD in a DTL? How?

I tried ConvertDateTime() without success.

I'm using Iris for Health

Thank you!

#InterSystems IRIS for Health #Ensemble

0 3

0 63

Question

Krishnaveni Kapu · Sep 11

SQL query to get multiple records

I have an SQL table as below (columns - ID and Value)

I will get an ID number (first column) as an input from FTP inbound , and after that I have to query table taking ID as an input to get all the values for the ID

as -

if ID = 11 ; QRY output = aaa,bbb

if ID = 22 ; QRY output = xxx,yyy,zzz

can someone help me with query

ID Value
----------
11 aaa
22 xxx
22 yyy
11 bbb
22 zzz
-----------

#Ensemble

0 2

0 64

Question

Nirali Dayam · Sep 9

Record Map to Transform an HL7 message to | separated string / stream

Is it possible to transform selected fields from HL7 message to | separated string or stream that can be inserted to a DB using Record Map?

#InterSystems IRIS for Health #Ensemble

0 2

0 51

Question

Troy Marshall · Sep 2

Write files to different subdirectories from a single EnsLib.File.OutboundAdapter

I have some Services using EnsLib.File.InboundAdapter to go directly to respective operations using EnsLib.File.OutboundAdapter which has a 'File Path' specified.

Using this File Path as a root directory, I'd like to instead pass this through a Router where I could somehow inject a subdirectory to place the file into on the outbound side based off the source service it is coming from. There will likely be several inbound services writing to each outbound operation and I'd like to be able to sort the output into subfolders.

#Ensemble #InterSystems IRIS for Health

1 1

0 48

Question

john smith · Sep 18

Changing JSON component

Hi Guys,

I'm using the following to display JSON content in an areatextbox, but I would like to change a value in my JSON before displaying it in my areabox?

#Ensemble

0 3

0 42

Question

Warren Oyco · Sep 19

Schedule Setting on Business File Service

Hi,

Is there a way to set the SettingSchedule on a EnsLib.File.PassthroughService at 9:00 am to 9:30 am but only end of the month?

#Beginner #Business Service #Frontend #Tips & Tricks #Ensemble #Health Connect

0 4

1 32

Question

Krishnaveni Kapu · Sep 13

..AppendTimestamp in FTP

what are the different values that can be passed to ..AppendTimestamp in FTP ?
Can we pass dynamic values to it ? if so how can we do that ?

#Ensemble

0 1

0 32

Question

Maxime LACH · Sep 19

EOF forced to LF in VS Code since version 2.12.6 of "Intersystems ObjectScript" extension

Hello,

Since version 2.12.6 of "Intersystems ObjectScript" extension in VS Code, the compile process force the EOF automatically to LF.
Have you encountered this issue and do you know how to resolve it?

Thank you,

Maxime

#VSCode #Ensemble

1 0

0 26

Question

Krishnaveni Kapu · Sep 20

xml attribute in double quotes

I am converting a HL7 msg to xml and one of the field is as below -

DTL = <assign value='"Message"' property='target.{req.ID.scope}' action='set' />

DTL response = <ID scope='Message'>3</ID>

my xsd has -
<xsd:element name="ID">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="SimpleContent" minOccurs="0"/>
</xsd:sequence>
<xsd:attribute name="scope"/>
</xsd:complexType>
</xsd:element>

#Ensemble

0 4

0 19

Question

Steve Pisani · Sep 16

Extending IRIS Health Monitor with custom health monitor sensors

IRIS Health Monitor is part of System Monitor (see here).

#Monitoring #Caché #Ensemble #InterSystems IRIS #InterSystems IRIS for Health

0 0

0 23

Question

Krishnaveni Kapu · 45 min ago