We have a requirement where in certain data from IRIS in almost real time has to join with SQL tables and we are trying to avoid linked servers.

Is there a way to achieve this without having to go through ODBC?

I have a table that is already created and contains data. I need to create a unique constraint that is a combination of two fields. Is there a way to do this in a SQL statement? Also, I would lke to know how to add it in the table class.

Hi All! For those of you who are users of our cloud services, you may have been introduced to Health Connect Cloud. One topic within that cloud service that can be a little tricky is understanding how GitLab and the source control workflow fit seamlessly into your integration workflow in Health Connect Cloud. I recently presented a lightboard video explaining how this works, including the slightly different workflows for building interfaces via code versus building via the Management Portal UI. If you use Health Connect Cloud, let me know if this is helpful or if you have questions!

https://www.youtube.com/embed/IN83cGGx-N8?si=WAyFtWFpZxzwnofA
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

This project is implemented as a tool for viewing temperature data taken from a temperature sensor installed in Rasperry PI and located in a remote place where there is Internet, for example, in dacha.

Our gj :: codeSpex extension for VS Code, which is part of the DX Jetpack, allows documentation to be displayed inline while you are coding classes. In some cases the documentation is extensive, and the lack of scrolling support in the VS Code comment element we are using was degrading the DX.

Hi

I use VB.net and add reference VISM.OCX in my project to fetch my data in global ^ztonMS it had 4000 record

code is

AxVisM1.MServer = "CN_IPTCP:" & TCLServer & ":" & Authen
AxVisM1.NameSpace = TCLNamespace

AxVisM1.P0 = ""
AxVisM1.P1 = ""
AxVisM1.P2 = ""

AxVisM1.P3 = ""

AxVisM1.P4 = ""

'AxVisM1.Execute("d RefRange^NHSNAV2")

I've define an upstream object in the IAM 0.34-1 and in it 3 targets. I now want to remove 1 of those targets.

I can not find the way to do that.

Hi all — we're excited to release the first three episodes of the all-new Data Points podcast! The video below contains a short highlight from each episode, but head over to https://datapoints.intersystems.com to check out all three and subscribe on your favorite podcast app! In the coming days, we will share individual posts for each episode, to allow for further discussion. Feel free to let us know your thoughts, comments, questions, and suggestions for future topics!

https://www.youtube.com/embed/OBsonGRZuZ8
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

Security is fundamental to enterprise application development. InterSystems IRIS provides a comprehensive security framework that protects data, controls access, and ensures compliance. This guide introduces essential security features for developers new to IRIS, covering authentication, authorization, encryption, and practical implementation strategies.

I'm trying to make a connection to an external database using %SQLGatewayConnection, but the connection always fails. DSN properly configured. I try to make the same connection through isql in bash, and the connection is successful.

This same connection fails in Caché.

☤ Care 🩺 Compass 🧭 - Proof-of-Concept - Demo Games Contest Entry

Introducing Care Compass: AI-Powered Case Prioritization for Human Services

In today’s healthcare and social services landscape, caseworkers face overwhelming challenges. High caseloads, fragmented systems, and disconnected data often lead to missed opportunities to intervene early and effectively. This results in worker burnout and preventable emergency room visits, which are both costly and avoidable.

Care Compass was created to change that.

I just realized I never finished this serie of articles!

In today's article, we'll take a look at the production process that extracts the ICD-10 diagnoses most similar to our text, so we can select the most appropriate option from our frontend.

Looking for diagnostic similarities:

From the screen that shows the diagnostic requests received in HL7 in our application, we can search for the ICD-10 diagnoses closest to the text entered by the professional.

Hi everyone,

I'm looking for a tool that can be used as a base to create an interface that allows a non-technical user to easily forward messages.

The idea is that the user can find an already sent HL7 message and forward it by modifying specific fields of the message without needing any technical knowledge.

An example would be something similar to the Ensemble search engine, but with a less technical and much more intuitive approach and that only allows changing 1 or 2 fields.