Question Scott Roth · Nov 20 Iterate through current Row of EnsLib.SQL.Snapshot I am using a JDBC connection to MS SQL server to execute a stored procedure to select data and bring it into InterSystems as a EnsLib.SQL.Snapshot. I loop through the EnsLib.SQL.Snapshot using a while loop, but I also want to iterate through the Columns within that Row to do logic. Is there a way to iterate through the Columns of the current Row of the EnsLib.SQL.Snapshot so I can apply logic/rules for further processing? Thanks Scott #JDBC #SQL #HealthShare #InterSystems IRIS for Health #InterSystems IRIS 0 4 0 34
Question Scott Roth · Nov 20 Documentation Issues Who do we report Documentation issues to? Since moving to the new format, when searching for things within the documentation I get a blank screen with no results. When I type in my search criteria, I can see it trying to find results but does not return results. This does not seem like it is limited to a certain Web Browser, as I have seen this happen in Chrome and Edge Thanks Scott #Documentation 0 20 0 121
Question Scott Roth · Nov 6 Histogram data being pushed to github There are a select few in the group that have been using Github as a Local Client push to a Repository setup in GitHub. Questions were brought up today about the security, and possible issues when it comes to data being pushed in this method. Looking over code we have noticed that there is Histogram data within some of the class files that could be considered a security issue. Does anyone else have concerns with the Histogram data being within the class files pushed up to github? #Change Management #Git #GitHub #VSCode #HealthShare #InterSystems IRIS for Health #Health Connect #InterSystems IRIS 0 1 0 40
Question Scott Roth · Oct 28 Business Process - Export Code with different versions Our TEST environment and PROD environment are on two different versions of HealthShare Health Connect. #Business Process (BPL) #ObjectScript #HealthShare #InterSystems IRIS for Health #Health Connect #InterSystems IRIS 0 4 0 77
Question Scott Roth · Oct 2 BP/External SQL Calls are creating IRIS.WorkQueue but is not purging the global I have been trying to track down an issue we are seeing in our TEST environment with Memory usage. We have Several BP's for years now that take a HL7 message, parse it apart, and make calls to a Custom EnsLib.SQL.OutboundAdapter to have it execute Insert/Select/Update/Delete stored procedures against a MS SQL Database via JDBC connection. We are using Microsoft's JDBC 12.2 driver to do this. What we are seeing is that IRIS.WorkQueue globals are being defined for these calls but then the IRIS.WorkQueue is not being cleaned up and taking up large amounts of Memory. #Business Operation #Business Process (BPL) #Globals #HL7 #JDBC #SQL #HealthShare #InterSystems IRIS for Health #Health Connect #InterSystems IRIS 0 5 0 52
Question Scott Roth · Sep 25 LDAP Authentication Question I am trying to track down a problem we saw this morning with our TEST environment. We had a momentary issue where InterSystems HealthShare Health Connect could not connect correctly to LDAP. When we tried to login and could not connect to LDAP, the system would Delete our users. the Test LDAP function would return a "Can't contact LDAP server". I went through the Certificates, made sure they had the correct permissions and were not expired. #LDAP #System Administration #HealthShare #InterSystems IRIS for Health #Health Connect #InterSystems IRIS 0 2 0 87
Question Scott Roth · Sep 18 FHIR to SDA Example I am still trying to understand and come up with a use case to use FHIR as an enhancement to our existing HL7 messages. Does anyone have an example of taking a FHIR response and transforming it into a SDA? How does the workflow go? Does it go through 1 BP? Thanks Scott #Business Process (BPL) #FHIR #HL7 #HealthShare #InterSystems IRIS for Health #Health Connect 2 2 0 87
Question Scott Roth · Sep 2 Allocation of Disk Space - Splitting of IRIS.dat into 2 different files Currently we are exploring how we can allocate additional disk space to our current environment as we have seen a significant increase in growth of our Database files. Currently we have 3 namespaces, all with 1 IRIS.dat each that contains both the Global and Routines. Since we have started down the route of everything within a single IRIS.dat file for each namespace, is it logical as we see growth to be able to split the current IRIS.dat for each namespace into a separate IRIS.dat for global and a IRIS.dat with for routines for each namespace in a Mirror environment? #Databases #Namespace #System Administration #HealthShare #InterSystems IRIS for Health #Health Connect #InterSystems IRIS 1 4 0 127
Question Scott Roth · Aug 27 FHIR Response to Data Message Class Question/Issue I am trying to create a HS.FHIR.DTL.vR4.Model.Resource.Encounter message based on a conversion of HS.FHIRServer.Interop.Response QuickStream to a JSON %Dynamic Object. When I try to send the HS.FHIR.DTL.vR4.Model.Resource.Encounter onto the Router #DTL #FHIR #HL7 #JSON #ObjectScript #HealthShare #InterSystems IRIS for Health #Health Connect 0 4 0 79
Question Scott Roth · Aug 23 Returning a Response from a Business Process that is not the same Message Type Request I thought I knew how to return a Response from a Business Process back to the Source Config Name, but I guess not. I am working on a Proof of Concept, that the Request Message Class would determine a "Route" within a Business Process to make a FHIR call (search, read) to our External FHIR repository, and return back the HS.FHIR.DTL.vR4.Model.Resource.xxxxxxx as a Response to the Source Config Name. #DTL #FHIR #InterSystems IRIS for Health 0 0 0 62
Question Scott Roth · Aug 23 Linked Stored Procedure Question Instead of building a BP to execute stored procedures just to insert the data, I figured I would give Linked Stored Procedures a try since all I need to do is insert the data. I have proved in our MS SQL Development environment that it is possible, so I through I could just repoint the Linked Stored Procedure #Management Portal #SQL #VSCode #HealthShare #InterSystems IRIS for Health #Health Connect #InterSystems IRIS 0 2 0 66
Question Scott Roth · Aug 9 Get Record Map as a String within a DTL to build FHIR query string I was looking for an easier way to build the FHIR Query String, given the Record Map request that is passed into the DTL. I built this Function, but when I run a message through it, my Query String that is passed back into the DTL is a Reference Pointer and not the String I am looking for. #DTL #FHIR #ObjectScript #HealthShare #InterSystems IRIS for Health #Health Connect #InterSystems IRIS 0 3 1 91
Question Scott Roth · Aug 1 FHIR infostructure for those connecting to External FHIR Repository As I begin our adventure into using an External FHIR Repository, I wanted to see what opinions people have about a design Idea I was working on. I want to create a way that my Team has the ability to send a Message Type, and the system knows from that Message Type which FHIR queries to execute and return the Response back to the user, sort of like a FHIR Query Hub. Does this sound reasonable? #Business Operation #Business Process (BPL) #FHIR #ObjectScript #InterSystems IRIS for Health #Health Connect 0 0 0 47
Question Scott Roth · Jul 30 Extracting Resource from FHIR Bundle Does anyone have an example of extracting the Resource from a FHIR Bundle? #FHIR #JSON #HealthShare #InterSystems IRIS for Health #Health Connect 0 1 0 72
Question Scott Roth · Jul 15 Setting EnsLib.SQL.Snapshot = "" vs EnsLib.SQL.Snapshot.Clean() In tracking down some of our Orphaned message issues, I was wondering if setting our EnsLib.SQL.Snapshot variable equal to "" was the same as calling the .Clean() method on EnsLib.SQL.Snapshot? Are they the same? should I be possibly using ##class(EnsLib.SQL.Snapshot).%Delete() instead? #ObjectScript #SQL #HealthShare #InterSystems IRIS for Health #Health Connect 0 1 0 78
Question Scott Roth · Jul 11 ACK showing up as Orphaned Message Could someone explain how and why a HL7 ACK be showing up as a Orphaned message when I run the following SQL... #HL7 #SQL #System Administration #HealthShare #InterSystems IRIS for Health #Health Connect 0 1 0 88
Question Scott Roth · Jul 9 %DynamicObject (JSON) Response into Class Structure Using the FHIR DEMO, I have pieced together how to make a FHIR Request using OAuth against an External FHIR Repository. When I execute the Patient search (HS.FHIRServer.Interop.Request), I get a HS.FHIRServer.Interop.Response that has a Quick Stream ID, which I then use to convert the Quick Stream to a JSON Dynamic Object. if I do a trace on the Raw JSON Object, I am able to pull out single elements, however I want to pull the raw JSON into a defined Class Structure. #DTL #FHIR #HL7 #JSON #ObjectScript #HealthShare #InterSystems IRIS for Health #Health Connect #InterSystems IRIS 0 2 0 127
Question Scott Roth · Jul 5 OnInit() Question - Ens.BusinessOperation (HTTP.OutboundAdapter) I have a question about using OnInit() within a Ens.BusinessOperation. When you include OnInit(), does OnInit() only execute when you start a Business Operation? Or does it execute OnInit () every time you send a REST request to the operation. I am trying to pinpoint when the best time is to execute the POST command to get the Token I am needing to get a Bearer Token from a REST POST call and return the Authorization key prior to making the rest of the REST calls to pull down data. #Authentication #Business Operation #Key Question #REST API #Health Connect #HealthShare #InterSystems IRIS #InterSystems IRIS for Health 0 13 0 172
Question Scott Roth · Jul 1 Best Practice Question - Connecting to REST API's outside of the network Up until recently, I have been toying around with REST/FHIR capabilities but only internally. Now I have a request to make REST API calls outside of our Network. I am using an RSA 4096 key, because Microsoft Active Directory Services which generates the signed certificate could not handle the Elliptical Key (ECC) when I put the request in. #API #FHIR #Interoperability #REST API #Security #SSL #HealthShare #InterSystems IRIS for Health #Health Connect 0 0 0 114
Question Scott Roth · Jun 28 Upgrading from 2022.1.4 to 2024.1 HealthShare Health Connect Behavior Has anyone noticed weird behavior when upgrading to HealthShare Health Connect 2024.1? Wednesday I upgraded our TEST environment from IRIS for UNIX (Red Hat Enterprise Linux 8 for x86-64) 2022.1.4 (Build 812_0_22913U) [HealthConnect:3.5.0-1.m1] [HealthConnect:3.5.0-1.m1] to IRIS for UNIX (Red Hat Enterprise Linux 8 for x86-64) 2024.1 (Build 267_2U) [HealthConnect:3.5.0-1.m1]. Some of our Business Processes have been throwing... #Business Service #ObjectScript #System Administration #HealthShare #InterSystems IRIS for Health 1 2 0 137