I have dynamic sql select query ,

Set resultset = ##class(%ResultSet).%New()

set sql = "SELECT COUNT(*) FROM "_tableName_" WHERE "_fieldName_">='"_fromDate_"' AND "_fieldName_"<='"_currentDate_"'"

SET SC = resultset.Prepare(sql)

SET SC = resultset.Execute(sql)

How can I print/view the count ?

Is there a way to use a property of the type %Persistent class in a %ZEN.Component.page class?
Example:

Hello,

I tried to define Pool Size in System Default Settings, but it is not being used. I see I am not the first to try this without success:

Define PoolSize as system default value | InterSystems Developer Community

Any suggestions?

Hey Community,

Enjoy the new video on InterSystems Developers YouTube:

⏯ Quick wins with InterSystems IRIS Vector DB

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

Join our next in-person Developer Meetup in Cambridge to explore the latest trends, tools, and features for innovating on health data.

This event will bring you into the conversation on GenAI and the evolution of AI Agents.

Hi!

I have installed IRIS 2024.1 in RHEL 9.5, using the following

Hi!

I have question about MDX functionality in context of IRIS Analytics.

Are you a developer, data engineer, integration engineer, or data scientist who works hands-on with InterSystems products?

We are conducting 30-45 minute interviews to understand your experience — how you started with InterSystems products, where you find helpful code samples, and how we can improve our products to better support your journey.

✅ If you’re interested, fill out a quick survey to share your contact info and experience.

If you're selected, we will schedule a session at your convenience between April 2 and May 8 for an interview based on the information you provide.

🎁 As a thank-you, interview participants will receive 10,000 Global Masters points!

Your feedback will directly help us improve your experience using InterSystems products and services.

Kindly note that the spots are limited.

Role: Principal Architect and Integration Engineer

Employment Type: Full Time

Note: Expertise in Rhapsody/Intersystems is Mandatory.

Main Responsibilities

Hi Guys,

I'm looking to create a service to download files from S3, so I used the EnsLib.AmazonS3.BusinessService with settings as below to download files that starts with SMfile_48 but I'm not getting any files, am I missing something?

Thanks

Hi All,

After doing IRIS/Ensemble etc for 20 years I've come across a company who have very odd view, especially about DTL's and routers.

They have convinced themselves to use COS for transforms (including HL7) and for routers (and one of their 3rd party providers agree!)

Their reasons are; efficiency, compatibility, flexibility, power and re-usability.

Of course these reasons are wrong!

Hi,

is there a way to starting & stopping Java Server programmatically ?

Thanks

Introduction

This is a quickstart guide to IRIS for Linux systems administrators who need to be able to support the IRIS DB as well as other normal infrastructure tasks.

IRIS is a DB system from Intersystems. An IRIS DB can hold code (in the form of a Class) or data (in the form of Globals). IRIS DB are Linux files called IRIS.DAT.

Once upon a time in Ensemble Management Portal the pool size of each component (Business Host) within the production was displayed in the Production Configuration page.

This information was very useful, especially when a production have tens or hundreds of components.