Hello,

I have installed the latest version of IRIS (without a web server) to replace my community version with a embeded web server.
I tried to connect Visual Studio Code to my namespace, but I am unable to do so. I keep receiving the message "Not found."
Here is my configuration:

"pc-david": {
"webServer": {
"scheme": "http",
"host": "localhost",
"port": 80
},
"description": "pc-david",
"username": "_SYSTEM"
}

Hi Guy,

I'm currently using a classmethod to load my page's display content in a form of html want look good, I'm wondering if I can add a Zen component in my classmethod eg. <dataCombo> or Label...etc?

I've tried the bit of code (circled in red) but didn't work

Thanks

How to increase the performance of the production when getting multiple messages from various Healthcare organizations

Hello Community,

I have encountered the following SQL problem trying to create a table from a SELECT statement.

I narrowed the problem down to the following example:

1. The SELECT statement alone works as expected.

SELECT m.Name, h.Status 
FROM EnsLib_HL7.Message m, Ens.MessageHeader h 
WHERE h.MessageBodyClassName='EnsLib.HL7.Message' AND h.MessageBodyID = m.ID

2. But if "CREATE TABLE ... AS" is added it fails

Hi All! Thought I would share our most recent podcast episode, which featured a conversation I had with Heather Capel and Chi Nguyen-Rettig of LEAD North. They talked about their journey from the beginning with InterSystems products, some of the challenges and opportunities building a team for healthcare integrations, and more.

https://5e18edf067eb59-03854285.castos.com/player/1548103
[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]

Hi fellows,

How can I query all Patient SDA from a Regestry and export to file? Exist some table when I can query all Patient?

To export, I found the class HS.SDA3.QuickXML and method ToQuickXMLStream, but I can't find a table where query all Patient, by update date for example.

Thanks in advanced!

Given a properly formatted ISO 8601 date time of 2024-06-23T06:03:00Z using SQL DatePart results in an error:

[SQLCODE: <-400>:<Fatal error occurred>]

[%msg: <Invalid input to DATEPART() function: datepart='ss', datetime value='2024-06-23T06:03:00Z')>]

If I remove the trailing Z (for Zulu / UTC time) and leave the T, DatePart works fine.

Hi,

I have created view from External table joins internal persistent table. Create VIEW worked but Select * from Viewxxx throwing error.

"References to an SQL connection must constitute a whole subquery"

https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY...(SELECT%20*%20FROM%20Mylink.

Ok, I am attempting to clarify the required use of the RESIZE command, when you have a UNIVERSE or a UNIDATA DB attached to Cache. Traditional UNIVERSE / UNIDATA databases 'require' that hashed files be re-sized according to historic use, to prevent file overflow (aka. performance issues). It is not clear if that requirement is fully eliminated by attaching one of these databases to Cache. It is clear that, if you do not allocate 'enough' space on Cache for the database 'as a whole', that is a problem.

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

InterSystems FAQ rubric

This can be done with TRY-CATCH:

In this paragraph of the article, here is an example of different records to explain how to fill in DirName、Globals and RestAll, but i don't know what is DUA1:[TEST3] ? This doesn't look much like dirname, like this /cachesys/mgr/test/. Can someone explain it? I would greatly appreciate it !

Hi Community:

Just want to let you know that Gartner Peer Insights is offering US$25 gift cards for completed product reviews. Here is the link: https://gtnr.it/3ulVX4K