#InterSystems IRIS for Health

I need to create a JWT to connect to EPIC FHIRserver sandbox.

https://fhir.epic.com/Documentation?docId=oauth2&section=BackendOAuth2Guide

You will generate a one-time use JSON Web Token (JWT) to authenticate your app to the authorization server and obtain an access token that can be used to authenticate your app's web service calls. There are several libraries for creating JWTs. See jwt.io for some examples.

Hi All,

I am facing some issues. I am having a SQL query that is executed using %SQL.Statement ExecDirect() method. Now I want to convert it into Embedded SQL using &SQL().
But where clause is dynamic in my case and It may contain 3-4 clauses.

I have pandas installed inside my C:/InterSystems/IRISHealth/mgr/python

Just curious what the process is for debugging either a .py file that is uploaded to a specific namespace/location or a python classmethod defined in a .cls file.

My method can be run via the "Debug" breadcrumb but it doesnt hit breakpoints it just runs without a debugger. Also objectscript methods debug correctly

Given a properly formatted ISO 8601 date time of 2024-06-23T06:03:00Z using SQL DatePart results in an error:

[SQLCODE: <-400>:<Fatal error occurred>]

[%msg: <Invalid input to DATEPART() function: datepart='ss', datetime value='2024-06-23T06:03:00Z')>]

If I remove the trailing Z (for Zulu / UTC time) and leave the T, DatePart works fine.

After upgrading we had 2 major problems with the new version:

- Resending messages adds blank lines.
Because we have many HL7 processes, we regulary have to resend messages if there is an outage of a server we connect with.

Hi Community,

I am attempting to create a new table by executing a SELECT statement that involves joining multiple tables. However, I encountered an error during execution: '( expected, AS found^Combined AS.' I would also like to create a cube based on this SQL table. However, during the cube creation process, I am prompted to specify a source class, and I'm unsure which class to use as it requires an existing class. Could you please help me identify the issue with the table creation, and provide guidance on selecting the appropriate source class for the cube creation?"

ERROR &lt;Ens&gt;ErrGeneral: Production is not fully stopped, cannot delete it. How do I fix this.

Hi,

Can anyone please tell me how to append a string using a update query.

For eg : "Hello" is the string . I need to append the string world and it needs to be "Hello world".

Thanks

Jude

Hi Team,

I am trying to use the inbuilt class: EnsLib.HL7.Service.FileService to pass through an HL7 ADT message as a part of an HL7 to FHIR transformation. We have a client requirement, where we are receiving an NTE segment as a part of the ADT message. I am trying to map the NTE segment to an OBX Segment. I need to implement a counter for OBX segment whenever a NTE segment is found and map the NTE fields to the new OBX segment

How do I implement the counter for OBX?

Thanks

Santosh

Could any one tell me, how the index works in cache db, Consider for example, I have a table called "Employee" and the fields as "EMPID, EMPNAME, EMPAGE" and I am having index for EMPID as IDX_EMPID and trying to get the record using the following query as

SELECT * FROM EMPLOYEE WHERE EMPID="005"

and the table data be like

EMPID EMPNAME EMPAGE

001 ABC 20

002 AAA 21

003 ABB 23

004 BBB 20

005 BDF 24

006 EEE 22

Hello, I created HL7 router Extends Ens.Rule.Definition. When I click the dot to the left, it does not draw lines to targets. I tried to add ClassMethod OnGetConnections(), but it does not get executed.

If both fields are numeric and the result of subtraction of field1-field2 is positive, only then put the result is a data field.

I am doing this within an Iris DTL.

I don't find any functions like IsNumeric(). Once I get that, I can test if field1>0 and field2>0, do the subtraction, and test if diff>0.

I just need a function to determine if they are numeric, rather than some cumbersome way like a regex where the only characters are 0-9.

I see functions in documentation but don't see them used at tests, only in WRITE statements.

Thanks,

i am trying to embed a dynamic SQL into Objectscript code , but the %NEXT() will return 0 , however when i copy the same query and run it in the SQL bit it will give me the result i want
the code :