Hi Community,

Enjoy the new video on InterSystems Developers YouTube:

⏯ InterSystems Package Manager @ Global Summit 2024

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

Hello Community,

The Certification Team of InterSystems Learning Services is excited to announce the release of our new InterSystems IRIS SQL Specialist exam. It is now available for purchase and scheduling in InterSystems exam catalog. Potential candidates can review the exam topics and the practice questions to help orient them to exam question approaches and content. Candidates who successfully pass the exam will receive a digital certification badge that can be shared on social media accounts like LinkedIn.

Hi Team,

This is very urgent can you please guide me to convert the date string to ISO format.

set date = "20240501144800-0500"

set result = $SYSTEM.SQL.Functions.TOTIMESTAMP(date, "YYYYMMDDHHMISS")

write result -> 2024-05-01T16:49:00:00+00:00

so here timezone is dropped off but i need that.

expected result -> 2024-05-01T16:49:00-05:00

Please help me here how i can convert in this format.

Hi All,

I am working on SQL based KPI in IRIS BI. I want to remove below highlighted search text box in "auto" filter type.

We cannot use other type like only dropdown etc. Is there a way we can do this ?

One way I can see is writing own control instead of using default control but I am not aware how to do this. I didn't find any sample code for this.

Is there any sample code available for writing custom control which I can refer.

Please assist

Hey Community,

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

I have Audit consolidator deployed in AWS where I scheduled Audit Export task to run daily.

Xml files are stored in mgr directory because the task runs in %SYS namespace.

Episode 20 of Data Points features a conversation with Bob Kuszewski about the Kubernetes and the InterSystems Kubernetes Operator (IKO). Take a listen to hear about some of the use cases and features of IKO, plus how it compares to InterSystems Cloud Manager (ICM) within the cloud space.

https://5e18edf067eb59-03854285.castos.com/player/579162
[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]

Hi Developers!

This is the digest of new solutions and applications submitted to InterSystems OpenExchange in April 2020!

19 New applications in April 2020

FHIR Server and API Manager for MIT COVID-19 Challenge by Steven LeBlanc

This demo shows how InterSystems API Manager (IAM) can be used to view and test FHIR resources with InterSystems IRIS for Health. It comes pre-configured with a FHIR server, pre-populated with synthetic patient data. The new InterSystems API Manager (IAM) includes OpenAPI Swagger specs to quickly generate REST client code to work with many common FHIR resources.

Production Manager by Nikolay Soloviev

REST API to manage IRIS Interoperability Productions.

rest-api-contest-template by Evgeny Shvarov

Template repository for InterSystems IIRS REST API Programming Contest

JSON-Filter by Lorenzo Scalese

ObjectScript server-side JSON filter.

objectscript-openapi-definition by Guillaume Rongier

The objectif of this library is to generate the ObjectScript Class from an OpenApi definition.

FHIR-HL7v2-SQL-Demo by Guillaume Rongier

Ready to use a demo of an FHIR Server and HL7v2 transformation to the FHIR Server on IRIS For Health Intersystems The FHIR repo can be a query in SQL.

CloudWatch-IRIS by Anton Umnikov

Configuring AWS CloudWatch with InterSystems IRIS

InterSystems is pleased to announce the General Availability (GA) of the 2025.2 release of InterSystems IRIS® data platform. This is a Continuous Delivery (CD) release. Please note that the GA versions of InterSystems IRIS for Health™ and HealthShare® Health Connect™ 2025.2 are currently withheld due to mirroring limitations introduced by security updates (details below).

Hey Community,

We're pleased to invite all the developers to the upcoming kick-off webinar for the InterSystems AI Programming Contest!

Discover the exciting challenges and opportunities that await Vector Search, GenAI and AI Agents enthusiasts in this contest. We'll discuss the topics we expect from participants and show you how to develop, build, and deploy applications using the InterSystems IRIS data platform.

Date & Time: Monday, March 17 – 11 am EST | 5 pm CET

https://www.youtube.com/embed/MHUt_QxSQTg?si=M9US_RLlXdXcdU--
[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]

I am attempting to create a Foreign Server/Table so I can pull some information in from MS SQL server via JDBC connection, but as soon as I create the Server/Table and logout the Foreign Server disappears.

CREATE FOREIGN SERVER Epic.Clarity 
   FOREIGN DATA WRAPPER JDBC CONNECTION 'MS-EpicClarity'

logout, then run

The SYS.Mirror CatchupDB() method requires a System File Number/Inode value as a parameter. I have not yet found a suitable internal method to get this value. Is anyone aware of a utility method that would do this? I do know I can get this value with a small amount of Python or by calling out to the OS. However I wanted to stick with pure Objectscript in this project if possible.

Failing in this I will use embedded python to run the line or two of Python needed to get this value.

Thank you for any hints

Hi developers,

We're hosting a User Group session for our Deltanji source control and Serenji debugger users on Wednesday, November 3rd at 11-12pm EDT / 3-4pm GMT.

We'll be showcasing some advanced features of Deltanji and Serenji in VS Code with time for a discussion - so feel free to bring along any problems you need help solving or share your feedback on our tools. We'd love to hear your thoughts.

You can find out more on Eventbrite.

Everyone is welcome. If you're interested in our tools this is a great chance to hear what others have to say, as well as asking your own questions.

We hope to see you on November 3rd!