Hi everyone,

This is the first time I'm dealing with a request of modifying a variable value in a UDF OnSQLTrigger on InterSystems TrakCare.

I can't find any documentation to address this issue, but basically, my goal is to modify the value of one of the fields in a table when it is first inserted.

This is basically what the code should do, namely, to change the content of the %d variable at a specific key.

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

Hi Community!

We’re excited to announce the launch of a new, hands-on training program:

🧑‍💻 Developing FHIR Applications Using Python 🧑‍💻

This cohort-based course takes developers from FHIR fundamentals to advanced, real-world healthcare interoperability solutions, with deeper, more practical coverage than typical industry offerings and a strong focus on production-ready skills using InterSystems technology.

2 1
1 24

Hi Community,

Here we have requirement to process messages min 10 sec delay. Current time it is taking my businessProcess is less than 1 sec.

To implement this requirement , I need to sleep 10 sec in business process custom code.

Could somebody help me to implement delay in BusinessProcess.

Thanks,

Prashanth

4 9
0 1K

Hello everyone,

The Certification Team of InterSystems Learning Services is excited to announce the release of our new InterSystems EHR Reports Specialist exam. It is now available for purchase and scheduling in InterSystems exam catalog. This exam tests candidates’ ability to use Logi Report Designer along with TrakCare/Intellicare to design, author, and support InterSystems Reports. For a list of topics covered by the exam, please refer to the exam page. Candidates who successfully pass the exam will receive a digital certification badge that can be shared on social media accounts like LinkedIn. If you are new to InterSystems Certification, please review our program pages that include information on taking exams, exam policies, FAQ and more.

2 0
0 13

Hey everyone,

I'm just seeking some guidance and confirmation on what I'm doing for my production health monitoring.

We utilize Grafana to have reporting/monitoring dashboards and I have made a REST API to query the health of our productions. I believe I have everything figured out except for one thing that I'm uncertain about and that is the Production Item Color indicators:

0 3
0 33

Hi, Community!

Building integrations with InterSystems products? Find out about the latest UX enhancements available in version 2025.3!

Building Integrations: A New User Experience Version 2025.3

https://www.youtube.com/embed/oDFS0k38_ik?utm_source=youtube&utm_medium=social&utm_campaign=oDFS0k38_ik
[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 14

Why do these clauses affect SQL performance?

select ID from some_table where row_status in ('I','U') order by ID limit 5 - makes the query infinite
select top 10 ID from some_table where row_status in ('I','U') order by ID - the same
select ID from some_table where row_status in ('I','U') order by ID - is fast

Actually there are no rows in the table having row_status 'I' or 'U'.

I asked Gemini and it recommended me rewrite the query as

0 14
0 125

Hi Community,

We're pleased to invite you to the upcoming webinar in Hebrew:

👉 Debugging InterSystems IRIS & Health Connect: From VS Code Breakpoints to Interoperability Traces 👈

📅 Date & time: Feb 18th, 3:00 PM IDT

4 0
0 17

Hello, I am trying to get some fields from HL7 message and create a file using BPL. The values I need are in a repeating segment (AIG). Even in the repeating segment, I just want the iteration that has a certain field (AIG:3 populated). With the help of documentation and community posts, I was able to create the BPL to loop through all of AIG and create the file. But when I try to narrow the results even further (AIG:3 present), the process gets stuck. I am not sure I am missing anything or have anything incorrectly set up. Also, since the process gets stuck, it doesn't even seem to h

0 2
0 41
Hello and welcome to the InterSystems Ideas Portal Annual Recap 2025.
General Stats:
✓ 182 new ideas in 2025
✓ 44 new implementations in 2025
✓ 174 new comments in 2025
✓ 725 new votes in 2025
✓ 232 new users in 2025
✓ 713 ideas all time
✓ 132 implemented ideas all time
✓ 991 comments all time
✓ 3,426 votes all time
✓ 1,207 users all time

3 1
1 24

Hey Community!

We're happy to share a new video from our InterSystems Developers YouTube:

⏯ Develop the Next Generation of Health IT with InterSystems@ Ready 2025

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

0 0
0 16

IRIS can use a KMS (Key Managment Service) as of release 2023.3. Intersystems documentation is a good resource on KMS implementation but does not go into details of the KMS set up on the system, nor provide an easily followable example of how one might set this up for basic testing.

The purpose of this article is to supplement the docs with a brief explanation of KMS, an example of its use in IRIS, and notes for setup of a testing system on AWS EC2 RedHat Linux system using the AWS KMS. It is assumed in this document that the reader/implementor already has access/knowledge to set up an AWS EC2 Linux system running IRIS (2023.3 or later), and that they have proper authority to access the AWS KMS and AWS IAM (for creating roles and polices), or that they will be able to get this access either on their own or via their organizations Security contact in charge of their AWS access.

6 2
1 367