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,

Is anyone using a 3rd party software for dictating notes, and has a way to integrate that with TrakCare?

We are exploring introducing an AI-scribe software for medical professionals note taking and wondering how to connect the two.

Thanks

I am exporting data from Cache using the SQL export wizard. This is on a docker image of Cache hosted on a Linux server.

I select my database, schema, and table, make sure that all columns are being exported, check other settings, and then finish the export.

All server settings look correct and permissions are rwe on the directory. I have tried various directories, including a system level directory. I tried creating the file before I do the export in case there was an issue with creating the files, and I also made sure the created files had rwe permisisons.

For example, you start debugging the AAA function, which calls the BBB function, then goes to the CCC^ABC function in a different routine and ends up while executing XXX^XYZ. No other routines or functions are visited in this example. What I would like is to get the record of AAA -> BBB -> CCC^ABC -> XXX^XYZ. No marking each function with recording code should be involved: too time consuming, too many functions in real code.

UPD: Iris has built in %SYS.Trace for this purpose but this class is apparently absent in Cache 2017. Did not find any substitutes yet.

Hi group,

I am trying to take the InterSystems HL7 Interface Specialist certificate test.

So is this an open book test? is there any Lab involved with vm? I did the search but I am not able to find such information.

I am trying to find out more information before I actually take the test.

Thank you

What is the recommended library for converting documents to pdf. Any suggestions welcome has anyone out there had a use case where they had to convert documents to pdf .What worked for them .I have asked WRC for the best practice and they have recommended that may be a sale engineer might have an answer to this .

I encountered an unexpected behavior while working with the $ZTIMEH and $ZTIME functions, specifically with times between 12:00 and 13:00. Here's what I observed:

W $ZTIMEH("08:50:38.975411826")
Output: 31838

W $ZTIME(31838,1)
Output: 08:50:38

This behavior is correct as $ZTIME returns the expected time of 08:50:38.

However, with the following example:

W $ZTIMEH("12:05:38.975411826")
Output: 338

W $ZTIME(338,1)
Output: 00:05:38

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:

Hi Community,

Watch this video to learn how to create new business services and business operations in an HL7 V2 production in InterSystems products:

⏯ Creating HL7 V2 Production Components

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

Hey Developers,

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

Hello Community,

I'm currently planning a system upgrade from Caché (2018.1.8.766) to InterSystems IRIS (2024.1). The environment consists of one database server and three application servers connected via ECP.

I need a DTL to handle this.

Any ideas appreciated.

For all Prosthetics orders:
when ORC-1(Order Control) is "NW" (New Order), need to update OBR-18(Placer Field 1) based on PV1-2 (Patient Class) value.
assumption is that the selection logic is that all prosthetics orders with OBR-18 field is always blank.
Description :
If PV1-2 is I, insert I in OBR-18
If PV1-2 is O, insert O in OBR-18
If PV1-2 is E, insert O in OBR-18
If PV1-2 is P, insert O in OBR-18
If PV1-2 is R, insert O in OBR-18
If PV1-2 is B, insert O in OBR-18

Hey Community!

The AI Programming Contest has begun, and we want to support you with an inspiring discussion on AI agents. Let’s explore the past, present, and future of AI agents together!