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

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

We have an operation that sends a Rest request to an external endpoint. The request includes the secret, which shows up in the Message Viewer. While access to the Production is restricted to only those who need it, we have been asked to remove it from the Message Traces. Is there a way to hide certain information on the Message Viewer ?

Thanks for reading

ISCAgent is automatically installed with Cache, runs as a service and can be configured tostart with the system. This is fine – but the complication comes when this is on VCS clusters withMirroring on. When installing a Single Instance of Cache in a Cluster, point number 2. Says “Createa link from /usr/local/etc/cachesys to the shared disk. This forces the Caché registry and allsupporting files to be stored on the shared disk resource you have configured as part of theservice group.”So on the second passive node – this statement makes ISCAgent startup with the system, nor manuallystarting it

Dear Community, 

Is there any way to search , select and abort a specific set of messages from a large queue in Healthshare business operation? 

Thank you for your help

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.

Hey Community,

Watch this video to learn how the InterSystems AppServices team migrated a data lake powering a suite of marketing reports off of Microsoft SQL Server to InterSystems IRIS, leading to such benefits as lower maintenance, better performance, and a better overall development fit:

⏯ Migrating Our Data Lake from MS SQL Server to InterSystems IRIS @ Global Summit 2023

Hello community, 

Just wanted to share..

While requested to access some service I was told to authenticate my request using OAuth 1.0 (revision A) with HMAC-SHA256 as a signing method. And knowing little to none about it. I started by testing it first in Postman, and all worked just fine. BUT with Object Script, well.. a big smile goes here! :) as I had some issues and no one to suggest..  
In the end the most helpful thing to do was to refer the docs here : https://oauth.net/core/1.0a/  while the signature method in it is for HMAC-SHA1 and RSA-SHA1 it is valid for HMAC-SHA256 as well.

Hi Developers!

Recently I was asked, “How can a beginner in InterSystems technologies learn from InterSystems Developers community content to improve his developer skills”?

This is a really good question. It has several answers so I decided to write the post with the hope it could be useful for developers.

So! How to learn Intersystems Data Platforms(IRIS, IRIS for Health) from InterSystems Developers community content if you are a beginner?

Hi Community!

It's that time of year again—the time of the Global Summit! All the Developer Ecosystem teams, in general, and the Developer Community team, in particular, are doing their best to bring even more new, interesting people into our midst! 

We had this beautiful booth ready on Sunday to welcome everyone when the Summit officially started:

I have an API that does not have all the data.  Like it is truncated. Magic number of characters seems to be 163,280

I do an <assign> 

context.RawBundle=##class(%DynamicObject).%FromJSON(context.FHIRResponse.Body)

The error does not happen when the response is < 163,280 chars.  And when < 163,280 chars, it is a complete FHIR Bundle.  Have anyone experienced this?  If so, what is the resolution?

I created a FHIR Client to execute a GET response from an external FHIR server. I set everything up according to this post: https://community.intersystems.com/post/create-fhir-rest-client#comment…

I was able to send a GET request and got a response of type HS.FHIRServer.Interop.Response.

But in the visual trace, I do not see the actual json response payload.  I opened the response object in terminal and saw it has a QuickStreamId, which I used with the HS.SDA3.QuickStream class to open the quickstream object. But how do I get the payload from this quickstream object? 

Hello,

I am interested about reading the source code of the primitives of the system.  For example, I want to see how WRITE is implemented.

Can you help me to get a reflexive interrogation of the system ?

Kind regards,

Alin C Soare.

I was trying to interact through IRIS terminal by giving user id and password from command-prompt, but iris terminal command is not recognizing. Please suggest how i can interact with iris terminal here. 

iris terminal <instance name> -U <user id> -P <password> not working

Please note i am new to IRIS. 

Hi Community!

We are excited to announce that all keynote conferences will be streamed live online! No matter where you are, you'll be able to follow every exhilarating moment in real-time.

Here are the links to watch the live broadcasts:

• Day 1: link to the first day
• Day 2: link to the second day
• Day 3: link to the third day

Can any one tell me the difference between %KillExtent and %DeleteExtent with example

Hi Community,

It's time for the new batch of #KeyQuestions from the previous month.

Here are the Key Questions of May chosen by InterSystems Experts within all Communities:

Hey Community,

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

For some time I have been planning to do some type of proof of concept with the Workflow functionality, which, like so many other functionalities present in IRIS, tends to go quite unnoticed by our clients (and for which I say mea culpa). That's why I decided a few days ago to develop an example of how to configure and exploit this functionality by connecting it with a user interface developed in Angular.

i want to update some values in tsysparameters table through powershell. how to write the script.

Hi Community,

Watch this video to learn how to use HL7® FHIR® Shorthand (a domain-specific, human-readable language for defining profiles, extensions, and other FHIR artifacts) to more efficiently create a FHIR Implementation Guide:

⏯ Using HL7 FHIR Shorthand

Finally and with a little delay, we conclude this series of articles about our Workflow Engine by showing an example of the connection that we could make from a mobile application.

Hi

I have a question about terminal, when I run a class from it that contains an error I get a report of error as I would expect, and then an apparently random three letter code is appended to the namespace name in the prompt, as shown below.

GMMHTIE>do ##class(temp.Nothing).What()
 
 w !, tParisAnswer
      ^
<UNDEFINED>zWhat+23^temp.Nothing.1 *tParisAnswer
GMMHTIE 2d1>

Then, when I try to enter a command I get an error

GMMHTIE 2d1>do ##class(temp.Nothing).What()
 
DO ##class(temp.Nothing).What()
^
<COMMAND>^temp.Nothing.1
GMMHTIE 2d1>

In a customer project I was asked how you can keep track of database changes: Who changed what at which date and time. Goal was to track insert, update and delete for both SQL and object access.

This is the table that I created to keep the Change Log:

Background

In InterSystems IRIS versions >=2021.2 we can use the accompanying irispython binary to directly write python code on top of our IRIS instances. This lets us use python packages, call methods, make SQL queries, and do nearly anything in Objectscript but pythonic.

For example, below I check if a namespace is present:

#!/usr/irissys/bin/irispython
import iris
# call arbitrary class methods
result = iris.cls('%SYS.Namespace').Exists('USER')
if result == 1:
    print(f"Namespace USER is present")

Hi Developers,

We'd like to highlight some key information about the Tech Exchange zone at Global Summit 2024. This year, you can see and add every demo, roundtable, or discussion to your schedule, ensuring you don't miss a thing!
Here's what to explore at Tech Exchange: 

• Request a 1-on-1 meeting with InterSystems product experts and developers
• Startup Showcase
• Partner Pavilion
• Developer Community booth
• Learning Services booth
• FHIR booth
• Supply Chain booth 
• UX booth
• Vector Search, GenAI discussion table. Available for spontaneous connections with others interested in this topic
• more than 40 tech demos!

Learning opportunities in Tech Exchange room: 

I receive a time stamp as  = 1988-08-18 00:00:00.000
I need this to be converted as - 1988-08-18T00:00:00+01:00

Hello Everyone,

The Certification Team of InterSystems Learning Services is developing an InterSystems ObjectScript Specialist certification exam, and we are reaching out to our community for feedback that will help us evaluate and establish the contents of this exam.  Please note that this is one of two exams being developed to replace our InterSystems IRIS Core Solutions Developer exam. You can find more details about our InterSystems IRIS Developer Professional exam here.

Hi ,

I receive xml as incoming request , I convert that into HL7 in my business process class as below

Set tSC = $CLASSMETHOD("myDTL","Transform", .pRequest,.dtlRes)

then , I am sending the dtlRes which is a HL7 message to a router "TEST_ROUTER" 

in the router , I am checking for HL7.{MSH:9.2} , where I am getting below error :

Terminating BP TEST_ROUTER # due to error: ERROR <Ens>ErrException: <PROPERTY DOES NOT EXIST>zevaluateRuleDefinition+15^TEST.SampleRule.1 *HL7,EnsLib.MsgRouter.RoutingEngine -- logged as '-' number - @' set tTempVars("test")=(pContext.HL7.GetValueAt("MSH:9.2"))'

Pandas is not just a popular software library. It is a cornerstone in the Python data analysis landscape. Renowned for its simplicity and power, it offers a variety of data structures and functions that are instrumental in transforming the complexity of data preparation and analysis into a more manageable form. It is particularly relevant in such specialized environments as ObjectScript for Key Performance Indicators (KPIs) and reporting, especially within the framework of the InterSystems IRIS platform, a leading data management and analysis solution. In the realm of data handling and

Note: this was originally posted on June 5, 2024 but presented as being posted on May 9, 2024 so this re-post fixes the date. 

Recent updates to the Intersystems Language Server introduce many significant enhancements aimed at improving developer experience and productivity. I'll talk about some of the key ones here, while the complete list, including numerous bug fixes, can be found in the Language Server's CHANGELOG.

Detailed descriptions for syntax errors