All time
InterSystems Developer Community is a community of 25,710 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!

Hello community, I need to solve a complex but trivial issue.

Given:

Two tables "Comment" and "Post". Each one contains an "Author" field, which is essentially a user ID. In these tables, each user ID represents an author. The goal is to count all participants together and then group them by month, language, and other metrics.

The question is how to do this within the IRIS ecosystem. Is it even possible to take two tables, get distinct data from them and then combine into one cube?

0 1
0 227

In our latest episode of Data Points, I had a conversation with George James, CEO of George James Software, about the importance of source control and developer tools, George James Software's own solutions, and their partnership with InterSystems. Take a listen, and visit https://georgejames.com to learn more about George James Software!

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

5 0
1 228

Hi Developers,

Enjoy watching the new video on InterSystems Developers YouTube:

Using Variables in InterSystems ObjectScript

https://www.youtube.com/embed/AA1QA9roDCw
[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 228
Announcement
· Oct 6, 2022
Beta Testers Needed!

Register today to beta test a new learning program!


Sign up to beta test a program, a new type of long-term learning resource geared towards specific roles: solution consultants, coders, and integrators! Programs give you everything you need to get started in a new role, or to upskill and take your career to the next level.

0 0
0 228

Hey Developers,

Join us to review the latest additions to Health Insight and future product plans for analytics in HealthShare:

Health Insight New and Next @ Global Summit 2022

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

Hi Community!

Thank you for being with InterSystems Developer Community yet another year! We appreciate it very much!

We want to know how helpful DC for you today and how could we make it better.

Could you please go through this short 5 min survey which will let us know what do you think about DC and what could be improved.

We wish you a Merry Christmas and a Happy New Year!

Sincerely,

Your InterSystems Developer Community Team

1 0
0 228

img

This will be an introduction to Python programming in the context of IRIS.

Before anything I will cover an important topic: How python works, this will help you understand some issues and limitations you may encounter when working with Python in IRIS.

All the articles and examples can be found in this git repository: iris-python-article

9 0
3 227
Article
· Apr 1, 2025 1m read
IRIS-Intelligent Butler

# IRIS-Intelligent Butler
IRIS Intelligent Butler is an AI intelligent butler system built on the InterSystems IRIS data platform, aimed at providing users with comprehensive intelligent life and work assistance through data intelligence, automated decision-making, and natural interaction.
## Application scenarios
adding services, initializing configurations, etc. are currently being enriched
## Intelligent Butler

4 1
1 207

Question for folks who have connected to an External FHIR repository outside of IRIS. Within the HS.FHIRServer.Interop.HTTPOperation there is not an option to include TLS or an OAuth authentication when connecting to an external Repository. So then how is that piece done if you need to Authenticate against an OAuth Server before you are able to access the data or call the Web Services/REST calls?

0 1
0 226
Question
· May 2, 2024
help with HL7 Transformation

Hi,

I'm new to IS and the HL7 transformations using the DTL. I need some clarification on the foreach action.

I want to iterate over IN1 segments, and output only segments that contain certain allergy types in IN1-2 with foreach. Inside the foreach block, I check for allergy type "FA" in IN1-2 and, if found, send the segment with only the required fields (fields #1, #2, #3, and #5 to be exact). Please see the foreach block below:

0 3
0 224
Question
· Feb 21, 2023
User access

Hi Guys,

How to create a user that can have access to only one specific Zen page of an application?

Thanks

0 3
0 224
Announcement
· Oct 19, 2022
CCR View Page Beta Release

Starting today, we have release the new CCR view page to beta users!

As the view page contains a lot of functionality, we are giving users the ability to toggle their session between the new UI and the classic UI view pages. Your sessions will default to the classic UI for now, but beta users will see a "View in New UI" button in the nav bar for Tier 0 and 1 CCRs:

Similarly, the new UI page will have a "View in Classic UI" button at the top:

3 1
0 207

Hi everyone,

Learn how to build FHIR applications in the cloud using S3, Azure AD, and a FHIR service:

Build FHIR Provider & Patient-Facing Applications in the Cloud

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

InterSystems has corrected a defect that may cause Windows Telnet processes that are secured using SSL/TLS to hang indefinitely; this may then cause an instance to become unresponsive. This defect is present only on Windows platforms.

This defect affects:

0 0
0 227

Hi Community!

Please welcome the new video on InterSystems Developers YouTube:

Get InterSystems IRIS from the Docker Store

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

Hi Developers!

Enjoy watching the new video on InterSystems Developers YouTube and explore the basics of InterSystems Open Exchange Marketplace:

How to Publish an Application on InterSystems Open Exchange

https://www.youtube.com/embed/DBh79bCayh4
[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 1
0 207

Some languages ​​have the concept of a garbage collector for automatic memory management. I'd like to know if something like this exists in InterSystems Caché in the context of routines, %CSP.REST, or %CSP.Page.

The question arises from the %Close() method of the %RegisteredObject class. This indicates that I need to manually clear the object from memory if it's no longer in use, or in the web context, if the request has completed. Is this correct? Or am I completely wrong?

Thank you!

2 8
0 218