I have an SQL table as below (columns - ID and Value)

I will get an ID number (first column) as an input from FTP inbound , and after that I have to query table taking ID as an input to get all the values for the ID 

as -

if ID = 11 ; QRY output = aaa,bbb

if ID = 22 ; QRY output =  xxx,yyy,zzz

can someone help me with query 

ID    Value
----------
11    aaa
22    xxx
22    yyy
11    bbb
22    zzz
-----------
 

Hi, Are there some REST API to get the open exchange apps list and app details?

Does IRIS have system like Oracle GoldenGate, which can generate Change Data Capture as a stream?

Hey Community,

We're excited to introduce a new series of videos dedicated to Gen AI on our InterSystems Developers YouTube:

⏯ 3 GenAI Model Training Opportunities

Our customer wants mirroring even on same network and it just increases the cost for us without helping much.
Are there better solution to avoid fake impression of HA?

Hi Team, 

Is there a way to search for a string or use of a function in all namespaces in one go.

Studio option "Search in files"/Ctrl+shift+F search all files in the current namespace. We have 13 namespaces and wanted to know if there is an easy way to search in all namespaces in one go. 

Thank you for your help 

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

Version 1.93 includes: 

Hello and welcome to the Developer Ecosystem Summer News!

This summer was full of exciting activities in the InterSystems Developer Ecosystem. In case you missed something, we've prepared for you a selection of the hottest news and topics to catch up on!

Hello every one, here in our company we are trying to develop a tool to help us in our "Code Review" that today is completely done for another developer.So I need to develope a tool that reads a class/routine (Already done) and identify if in the current line there is some abbreviated command, that is against our policy of codification, for example:s variable = "test"d ..SomeMethod()So in this cases I want to warn the original developer that the code has parts that need to change the "s" to "Set" and de "d" to "Do".I tried to found some library in the documentation but with no success, if

So if you are following from the previous post or dropping in now, let's segway to the world of eBPF applications and take a look at Parca, which builds on our brief investigation of performance bottlenecks using eBPF, but puts a killer app on top of your cluster to monitor all your iris workloads, continually, cluster wide!  

Continous Profiling with Parca, IRIS Workloads Cluster Wide

Hi there, I'm wondering if anyone has run into an issue with <FILEFULL> when building an image from the ISC image? Specifically what's happening in our build is we are pre-loading our codebase into the image to make deployments faster and setting up source control, etc. When loading our libraries however we get hit with a <FILEFULL>. The resource limits on docker are pretty beefy and when observing resources on both the machine and container level we don't hit any issues. Oddly, this only happens when using the ARM64 version. When using the AMD64 version of 2024.1 it builds fine but I need

I am trying to login to InterSystems image repository but it is not recognizing following credentials from ubuntu.

docker login  https://containers.intersystems.com -u <username> -p <password>
WARNING! Using --password via the CLI is insecure. Use --password-stdin.
Error response from daemon: Get "https://containers.intersystems.com/v2/": unknown: Bad credentials

The same credentials works via website.

Is it possible to transform selected fields from HL7 message to | separated string or stream that can be inserted to a DB using Record Map? 

Hi Community,

Play the new video on InterSystems Developers YouTube:

⏯ InterSystems IRIS Vector Search and the Python Ecosystem @ Global Summit 2024

Hi Community!

We are pleased to invite you to a new webinar in Spanish: ‘Facial recognition applied to application login using JavaScript+IRIS’, on Thursday 26th September, at 4:00 PM (CEST).

​​​​​​

during an upgrade, a customer wants to load custom schemas in a particular order.
For this, they renamed a file EPIC_MDM.HL7 to 1EPIC_MDM.HL7
Upon importing this file into their server using VSCode, the custom schema was renamed to 1EPIC_MDM.HL7 inside the <Category>
This is impacting the upgrade and they are looking for a way to import a custom schema without renaming the schema itself.

HI, in The Netherlands I get lots of questions on the ability of InterSystems to handle openEHR data. Before I start a local initiative I'm interested in other work done with openEHR. Anybody?

Regards, Joost

Hello,

I just installed the IRIS 2024 version 2 and it doesn't have Cache Studio.  Doesn't anyone know how to add Cache Studio in the IRIS 2024 version 2 or did I install the wrong one?  Thank you for your help in advance.

Alan

Hello to you!

Is it possible to write to Windows Eventlog with Object Script?

Tried a bit but having trouble getting it to work. If possible, I would be grateful for a piece of sample code

Regards Michael

I attended Cloud Native Security Con in Seattle with full intention of crushing OTEL day, then perusing the subject of security applied to Cloud Native workloads the following days leading up to CTF as a professional excercise. This was happily upended by a new understanding of eBPF, which got my screens, career, workloads, and atitude a much needed upgrade with new approaches to solving workload problems. 

So I made it to the eBPF party and have been attending clinic after clinic on the subject ever since, here I would like to "unbox" eBPF as a technical solution, mapped directly to what we do in practice (even if its a bit off), and step through eBPF through my experimentation on supporting InterSystems IRIS Workloads, particularly on Kubernetes, but not necessarily void on standalone workloads.

eBee Steps with eBPF and InterSystems IRIS Workloads

An IRIS.DAT file was removed, as it was not needed anymore. But the database was mirrored, so it still shows up in the mirror monitor and database list. How can this be fixed? There is no backup of the .DAT file so it cannot be restored.

w##class(SYS.Mirror).RemoveMirroredDatabase("/mydir/")

throws a protect error.

(everything else works fine and this is not a production system, it only is annoying in the mirror monitor and database list)

I can START and STOP a business process via its Schedule setting.

Is it possible to change the value of another Setting in an analogous way?

I can imagine a SettingSchedule that could look like 

action:YYYY-MM-DDThh:mm:ss[,action:YYYY-MM-DDThh:mm:ss]

But rather than just START or STOP, action could be "SET Setting = value", overriding whatever the normal value is.

Is there an existing way of achieving this kind of functionality?

Hello community,

How to install the iris  package installer for Python (pip) in python and import iris package in python source code. 

import iris
class Solution():
    iris.connection()

thanks!

Hey Community,

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

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

You might know that you can search posts in DC by Tags
starting in left upper  corner   and  

that's fine to start. But - based on some local feedback - some improvements
might make is more useful. actual the SELECT works .. IF TAGS CONTAIN %tag 
This spams you with a lot of results but often much more than useful
so the suggestions for extensions:

Hey Community,

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

I am excited to share that the Learning Services team has recently added new content to our InterSystems Reports Learning Path. These latest videos, created by our partner, insightsoftware, provide instruction for developing reports with InterSystems Report Designer.

In these three short videos, you’ll learn how to:

docker login -u=<username> -p=<password> containers.intersystems.com
WARNING! Using --password via the CLI is insecure. Use --password-stdin.
Login Succeeded

$ docker pull containers.intersystems.com/intersystems/irishealth:2024.1
Error response from daemon: unauthorized: The client does not have permission for manifest: Download request for repo:path 'docker-customer-remote-cache:intersystems/irishealth/2024.1/list.manifest.json' is forbidden for user: 'anonymous'.

why the download is not working.

In today's data landscape, businesses encounter a number of different challenges. One of them is to do analytics on top of unified and harmonized data layer available to all the consumers. A layer that can deliver the same answers to the same questions irrelative to the dialect or tool being used. InterSystems IRIS Data Platform answers that with and add-on of Adaptive Analytics that can deliver this unified semantic layer. There are a lot of articles in DevCommunity about using it via BI tools. This article will cover the part of how to consume it with AI and also how to put some insights

InterSystems FAQ rubric

In SQL, NULL data and the empty string ('') are different data. The method for setting and checking each is as follows.

(1) NULL data

[SQL] 

insertintotest(a) values(NULL)
select * fromtestwhere a ISNULL

[InterSystems ObjectScript]

setx=##class(User.test).%New()
setx.a=""

(2) Empty string ('')

[SQL]

insertintotest(a) values('')
select * fromtestwhere a = ''

[InterSystems ObjectScript]

setx=##class(User.test).%New()
setx.a=$C(0)

For more information, please refer to the following documents:

NULL and empty strings [IRIS]
NULL and empty strings