Or can I change namespaces within one connection object?

#InterSystems Demo Games entry

⏯️ Eliminating Waste in Healthcare Supply Chains

Between recalled supplies, expired inventory, and rogue spending, an estimated $25 billion per year goes to waste in healthcare supply chains. We know how critical supply chain is in healthcare, so we know this is a problem worth solving! What could a proposed solution look like? Watch and find out!

Presenters:
🗣 @Georgia Gans, Sales Engineer, InterSystems
🗣 @Annie Tong, Sales Engineer, InterSystems
🗣 @Boris Mamkin, Senior Sales Engineer, InterSystems

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

February 19, 2025 – Alert: SQL Queries Returning Wrong Results

InterSystems has corrected two issues that can cause a small number of SQL queries to return incorrect results. In addition, InterSystems has corrected an inconsistency in date/time datatype handling that may lead to different, unexpected – yet correct – results for existing applications that rely on the earlier, inconsistent behavior.

DP-436825: SQL Queries with Lateral Join May Return Wrong Results

Hey everyone.

As I have been working with IRIS (nee Caché) for some time now, I decided to take a look at how I manage things like functions and scripts that may not belong to a single namespace or environment, but should still have a home.

I need to see the full SMTP trace when a %Net.SMTP attempts to send an email to troubleshoot an issue. As far as I know, the only way to get that is to uncomment line 192 in the %Net.SMTP class.

 //:#define SMTPTRACE

I've done this in the past by giving myself the %DB_IRISSYS role, so I tried that. That database is also not mounted as read-only.

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.

Hi,

I will try to explain my problem. I have a Main ZenPage on one server that has 2 buttons: each button will launch a different ZenPage on a separate server in an iFrame. All 3 servers have the same user.

Currently, the user logs in to the Main ZenPage, but when they click either button to launch the other ZenPage on the separate server they get the login screen again to login to that server.

Is there anyway I can pass the credentials from the Main ZenPage to the child ZenPages, so that the user doesn't have to login again? Thanks.

For one of the reports I need to produce through Logi, I need to create a parameter/filter and pre-populate it with items from a query. Has anyone done that before? And if so how did you do it?

Thanks,

Kris

Good morning,

first of all thank you for taking the time to read and answer this question.

Recently, since we have upgraded to HealtShare 2020, we experienced the fact that when opening in the Studio the Process (.bpl) and Transformation (.dtl) classes, it asks us to log in, i.e. username and password, almost every time we open a new Process or Transformation.

However, in previous versions, I think we had HealthShare 2016 or 2017 or 2018, and in it, you could log in from the Studio in Processes and Transformations, logging in 1 time only.

Hey Community,

Here is a digest of the Developer Community videos on InterSystems Developers YouTube Channel in October 2021:

Hey Developers,

Here is a digest of the Developer Community videos on InterSystems Developers YouTube Channel in March 2021:

Using SQL Gateway with Python, Vector Search, and Interoperability in InterSystems Iris

Part 3 – REST and Interoperability

Now that we have finished the configuration of the SQL Gateway and we have been able to access the data from the external database via python, and we have set up our vectorized base, we can perform some queries. For this in this part of the article we will use an application developed with CSP, HTML and Javascript that will access an integration in Iris, which then performs the search for data similarity, sends it to LLM and finally returns the generated SQL. The CSP page calls an API in Iris that receives the data to be used in the query, calling the integration. For more information about REST in the Iris see the documentation available at https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls...

Hi Community,

Are you looking for resources to help your team onboard? Use these guides to get started!

Hello.

I have a business process with an "ASTM" class :

Inside this process i have a business rule. Inside this rule i want to get a specific field inside the message :

So i will use the same logic for HL7 messages. Here is the "path" to the segment and the field :