Hello Community,
I'm unable see the FHIR SQL builder /csp/fhirsql and /csp/fhirsql/api/ui endpoints in web application to access the FHIR SQL builder. I'm using community edition 2024.1 and it contains the "FHIR SQL Builder".
InterSystems IRIS for Health™ is the world’s first and only data platform engineered specifically for the rapid development of healthcare applications to manage the world’s most critical data. It includes powerful out-of-the-box features: transaction processing and analytics, an extensible healthcare data model, FHIR-based solution development, support for healthcare interoperability standards, and more. All enabling developers to realize value and build breakthrough applications, fast. Learn more.
Hello Community,
I'm unable see the FHIR SQL builder /csp/fhirsql and /csp/fhirsql/api/ui endpoints in web application to access the FHIR SQL builder. I'm using community edition 2024.1 and it contains the "FHIR SQL Builder".
How to see the code of the routine objects in the database. While importing the routine in the xml format the object code is in Database64 format but not able to see the actual code. How to decompile or how to see the code of the routines.
I want to generater a license for my code,but i don`t how to get CpuID and diskid in iris,someone know?
I'm running into an intermittent issue with some of our Custom Operations/Processes as a result of some large FHIR R4 Binaries. Essentially we get a response from an AthenaHealth FHIR endpoint that appears to be too large to be processed using the IRIS Built In Functions for FHIR:
I've replicated it on the command line here using a file (binary.json) that has the response from the FHIR Endpoint. Not sharing full contents due to PHI concerns.
HSCUSTOM>S file=##class(%Stream.FileCharacter).%New()
HSCUSTOM>Do file.LinkToFile("/data/binary.json")
HSCUSTOM>w file.
Hi Team,
This is very urgent can you please guide me to convert the date string to ISO format.
set date = "20240501144800-0500"
set result = $SYSTEM.SQL.Functions.TOTIMESTAMP(date, "YYYYMMDDHHMISS")
write result -> 2024-05-01T16:49:00:00+00:00
so here timezone is dropped off but i need that.
expected result -> 2024-05-01T16:49:00-05:00
Please help me here how i can convert in this format.
Hello Community,
I've seen two cached queries are generated while executing a query. So, Why the additional query is generated and what is the use of it.
.png)
📜 Santa Tecla, verse 8: "Hover your mouse over the screen, and the sea of data will open a path before you!!"
Hello community, first of all, apologies if anyone was offended by the blasphemy 😔
Have you ever thought it would be interesting to have the source code separated from the database data? Perhaps you'd like to be able to back up your code without copying gigabytes of client data.
Below, I'll explain the steps to separate your sea formed by the source code and data into two different databases within a
We have a stand-alone web platform (readysetrecover.com) that helps people prepare for surgery focusing on the non-clinical – holistic and logistic aspects (stress reduction via meditation, sleep etc. as well as things like setting up the house, coordinating help from others etc).
We had a meeting with a hospital, and they liked our solution but said their goal is ‘to provide patient education and communication on a single platform'. They currently use Epic and MyChart.
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
Will SQL Engine directly hit the "005" record using ^EMPLOYEEI global, if so how it is happening,
Hello Community
I'm unable to view the HL7 message field in the Business rules of the latest version of IRIS while tying HL7. syntax
ex: HL7.{PID:PatientName().givenname}
Latest Rule editor
.png)
Old Rule editor
.png)
Has anyone had experience migrating source control projects from Subversion to Github, particularly when transitioning from InterSystems Studio to VSCode?
InterSystems Reports version 24.1 is now available from the InterSystems Software Distribution site in the Components section. The software is labeled InterSystems Reports Designer and InterSystems Reports Server and is available for Mac OSX, Windows and Linux operating systems.
This new release brings along some great enhancements from our partner, insightsoftware. InterSystems Reports 24.1 is powered by Logi Report Version 24.
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.
I tried using fromDao(dao As %DynamicAbstractObject) As <HS.FHIRModel.
Hi Community,
Watch this video to learn about the PainChek artificial intelligence technology, which assesses patient pain at the hospital bedside, leverages InterSystems IRIS interoperability to connect to third-party electronic medical record systems:
We recently moved from using the Private Web Server, to using an Apache/Web Gateway setup and moved towards using the built in LDAP functionality within IRIS. Since then, we have 1 user that uses VSCode (/api/atelier) heavily that continues to have issues signing into IRIS through VS Code and the /api/atelier extension.
I am trying to troubleshoot two issues..
Has anyone had experience using Azure EventHub with IRIS?
Hi,
I'm very new to InterSystems Health Connect so may be doing something silly...
I'm trying to link to an Oracle DB view using the Link Table Wizard in the Management Portal. The wizard finds the view, but when I select it and click the 'next' button I get an error on the 'Select Columns' screen: 'ERROR #5534: Columns error' (and no columns show in the wizard). I've tried on several views and tables in the same DB but keep hitting the same error.
I have previously successfully mapped a view and table from the same DB and am not sure what I am doing differently. Any suggestions appreciated!
Bonjour,
Depuis ce matin j'arrive pas à compiler ou lancer mes programmes qui tourne en local sur docker avec l'image : intersystemsdc/irishealth-community:2024.1-zpm
J'ai toujours cette erreur sur le terminal ou le portal de management : request to http://localhost:52773/api/atelier/ failed, reason: socket hang up
Dans mes logs docker aussi j'ai des erreurs en conitnu , voici un extrait ...
Dans le fichier message.log j'ai aussi des erreurs et voici un extrait
L'erreur semble indiguer une licence et un nombre de core limite ....
Avec l'ajout de ceci dans mon
I am trying to extract GMHeap, Locksiz values form Config.config using python (imported irisnative for Python) but the below python progam is not returning any value. Please suggest if i am doing any mistake -
Also, plese suggest how i can set values for GMHeap and Locksiz to a different value through Python.
import irisnative
hostname = "127.0.0.1"
port = 1972
namespace = "%SYS" #change the namespace based on situation
username = "_SYSTEM"
password = "xxxxxxxx"
connection = irisnative.createConnection(hostname, port, namespace, username, password)
dbnative = irisnative.
Hello,
I don't know why I can't get into management portal. I saw something related to permission issue of group allowed to start and stop and have already changed to root and Admin but still doesn't work.
Installation info:
I started "httpd server" and "IRIS".
Management Portal doesn't show on browser. Error Shows:
But I could get into "User" namespace from the terminal.
In VS code, I downloaded three extensions. Then
In settings.json,
We have a business process that seems have extra jobs hanging around. This is what we see in the Jobs tab:
.png)
Only the bottom one is actually associated with a process. So what are those other ones? There are no queues and I have no way of finding out why they're there.
Thanks.
Hello,
First of all thanks for your time reading this question, and thank you for your help.
🎯 We would need to create an Ensemble HealthShare Operation to read files from a FTP / SFTP server.
We have coded:
Class Operaciones.FTP.ConsultaPDFv01r001 Extends Ens.BusinessOperation [ ProcedureBlock ]
{
Parameter ADAPTER = "EnsLib.FTP.InboundAdapter";
Method ConsultarDocumentoPDF(pRequest As Mensajes.Request.ConsultaPDFRequestv01r00, Output pResponse As Mensajes.Response.RecuperarDocumentoPDFv01r00) As %Library.Status
{
set ftp = ##class(%Net.FtpSession).%New()
set isConnected = ftp.Hello Community,
I've configured a FHIR Server in FHIR Configuration "/csp/healthshare/learn1/fhir/r4 " and I enabled a JWT Authentication for this web application. I've invoked this url http://localhost:52773/csp/healthshare/learn1/fhir/r4/login with basic auth get the JWT token. Now I use the access token as a "Bearer" for GET the patient resource. But I got 401Unauthorized error. Anyway I can get the patient resource with basic auth. I tired assign with %ALL role for testing as well. Did I miss any additional configuration in "FHIR Server Configuration"
.png)
$ZTIMESTAMP returns the date and time in UTC format, so to change it to the local time zone, use the following system method:
$SYSTEM.Util.UTCtoLocalWithZTIMEZONE($ZTIMESTAMP)The above output will be in the format ddddd,sssss.fff.
ddddd: Same format as $HOROLOG dates
sssss: An integer indicating the number of seconds elapsed since midnight on the current date
fff: Variable number of digits indicating the fractional part of a second
* Similar to $HOROLOG, except that $HOROLOG does not include fractional seconds.
SAMPLES>write $SYSTEMUtil.Have you ever imported an XML schema from an XSD file? You might want to look at the original file again sometime later, but forgot where you put it.
Do not worry, that information is being kept as part of the import process.
The whole imported XSD schema is being kept in the ^EnsEDI.XML.Schema global. That global holds all the imported XSDs in your namespace. The first subscript is the name of the schema that you see in the portal.

To look for the source XSD file location, simply look at the following place:
^EnsEDI.XML.Schema(<schema name>,"src",1)
For example:
ZW ^EnsEDIXML.Trying to test a router that takes an XML input and performs a transform on it.
First attempt I tried to test the transform using the XML Document Viewer via the Ensemble -> Interoperate -> XML Document Viewer menu. The transform itself is working however I can not get the output to save to a file. I've made sure permissions are set correctly on the file. It simply doesn't output anything and I'm at a loss as to why.
As another method I also tried testing via Ensemble -> Test -> Business Hosts. Putting the file path/name as the source does not send any data.
Difference between %ResultSet.SQL and %SQL.Statement
Hi dear Sir,
I see the DTL chain defined in IRIS, which is applicable if regarding transformation from one protocol to another, and fields/segments mapping:
Hello Community,
I'm a beginner and currently working on a project to convert CCDA files to FHIR using InterSystems IRIS. I have developed a web form to upload CCDA files, and I'm attempting to convert the uploaded CCDA files to FHIR. However, I am encountering an issue where the conversion process results in an empty entry.
Here's the Output it displays on HTML page:
Size of CCDA Stream: 74152
vR4
{"resourceType":"Bundle","type":"transaction","entry":[]}Here is my code: CCDtoFHIR.csp
<!