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

0 2
0 166
InterSystems Developer Community is a community of 26,053 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!
Learn more

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

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

1 0
0 138
Question
· Aug 2, 2024
Search in all namespaces

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

1 7
0 453

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

3 6
2 254

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

3 0
2 332

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.

1 3
0 190

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.

0 2
0 195

Hi Community,

Play the new video on InterSystems Developers YouTube:

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

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

1 0
1 132

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

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

​​​​​​
2 0
0 111

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.

0 2
0 107
Article
· Sep 9, 2024 14m read
eBPF: Tracing Kernel Events for IRIS Workloads

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

6 0
3 369

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.

0 3
0 267

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?

0 4
0 175

Hey Community,

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

New Videos
№ Video Views
1 What is RAG? (Retrieval Augmented Generation)Amazing LLM System for Enhanced UX #ai #chatgpt #shorts 14755
2 InterSystems IRIS: What's New & Next 109
3 Leveraging Developer Ecosystem Tools for Success 62
4 SQLzilla – Unleash the Power of Your Data 57
5 How Netsmart Moved to InterSystems IRIS in the Cloud 56
6 HealthShare Deployment Automation at Warp Speed 55
7 Updating Legacy UIs for Modern Browsers - Lessons Learned & Steps Forward 53
8 Introducing Managed Solution for Asset Management 38
9 CommonWell Connection 29
10 Winners of the InterSystems Python Programming Contest 2024 28
11 SQLZilla in action #shorts 26
12 Online Meetup with the Winners of the Python Contest 25

0 0
0 84
Question
· Sep 4, 2024
image is not downloading

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.

0 2
0 457

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.

11 2
1 531