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

Is there a way to capture the SQL command that was sent to Cache ? I need to know how to do this. Any help would be appreciated. It is from an external application using JDBC or OBDC. Thanks

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?

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.1SP2 and includes:

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:

⏯ Using Artificial Intelligence / Machine Learning for Pain Assessment in a Clinical Environment @ Global Summit 2023

https://www.youtube.com/embed/-XNQUj7Sx_s
[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]

I'm working with isc.rest and am going through the tutorial right now. My project directory exists on my IRIS server. When I try to create a module.xml file in the root package, I get a #16006 error. I see that there is a "generate" command for zpm that should create a module.xml for me on my local filesystem. How can I create this module.xml in the same folder that holds my code living on the IRIS server?

Hey InterSystems-Community,

is it possible to get these Property Descriptions via SQL Query for example in the Management Portal?

Best regards,

Florian

I have an HL7 message that contains NTE segment with line break inside.

when I try to transform it (with DTL) it stops reading the message after the line break inside the NTE because it treat that as "End of Message".

Is there a way to solve this in the DTL or I need to run a pre process on the HL7 message that identify the line break inside the NTE segments and replace it with an escape char?

Context

The Web Server Gateway Interface (WSGI) is a simple calling convention for web servers to forward requests to web applications or frameworks written in the Python programming language. WSGI is a Python standard described in detail in PEP 3333.

🤔 Ok, great definition and what the point with iris ?

hi guys!

while WorkMgr.Queue reports a error, there are many locks, how to deal it?

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".

Are we allowed to delete _SYSTEM user of an Intersystems IRIS, If so,how can we do that?

Hi Community!

Need an introduction to Generative AI? Learning Services is excited to announce the first video in a new series about GenAI basics:

🧐 What Is Generative AI?

https://www.youtube.com/embed/zMfiV0RhrCA?utm_source=youtube&utm_medium=social&utm_campaign=zMfiV0RhrCA
[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]

Visual Studio Code releases new updates every month with new features and bug fixes, and the June 2024 release is now available.

Version 1.91 includes: