All time
InterSystems Developer Community is a community of 25,772 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 230

Hey Developers,

Thank you so much for staying with InterSystems Developer Community for yet another year!

Day in and day out our team is trying to make it better and more useful for each and every one of our 12K+ members!

We'd like to know how useful the Developer Community is for you at this point. Please take a few moments to let us know what you think and what could be improved:

👉🏼 InterSystems Developer Community Annual Survey 2022 👈🏼

Note: The survey will take less than 5 minutes to complete.

4 1
1 211
Question
· Aug 16, 2022
Can run application in IE

Hi Guys,

My application is running in Chrome but not in IE and I'm guessing it's a security issue, where when I open IE it tells me that ESC in on, but checking the configue in Server Manager tells otherwise?

Thanks

0 1
0 230
Announcement
· Jun 27, 2022
UK & Ireland Summit 2022

Couldn't see this on the community, not sure why...

UK & Ireland Summit 2022
Leading Through Innovation

18-19 October 2022 – The VOX, NEC, Birmingham

Join us for a true community event, once again bringing together InterSystems customers and partners – to learn, inspire, and share innovation challenges with each other. To register, please complete the form below.

2 0
0 231
Question
· Jul 31, 2021
Ensemble learning query

Hi All,

I am new beginner to cache/mumps language. I want to learn Ensemble code but I do not have any application access to Ensemble code.

Is there documentation apart from Intersystems Ensemble documentation that can help me to learn Ensemble. Any notes or documents will be very handful

Please assist!! Thanks in advance.

0 2
0 229

Hi all,

I added an additional shard node to an existing shard by accident.

After the add, it can not be removed and query from the master shard now fails. I did not find any data from shard master in the shard node.

How to recover it and remove the shard node from the shard master?

Thanks.

0 2
0 229
Announcement
· Aug 26, 2019
Learning News: August 2019

Now available from InterSystems Learning Services: the August 2019 newsletter!

See what's going on with Learning Services at the Global Summit, including:

  • Achieve certification in one or more subjects

  • Dive into InterSystems IRIS™ on your own machine

  • Attend a Personal Training session to get your questions answers

  • Optimize your training plan for yourself or members of your team

  • Get steep discounts on classroom courses

0 0
0 231

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 231

For 15 over years I have been playing with ways to speed up the way I use InterSystems systems and technology via AutoHotkey scripting. As a power keyboard user (I avoid my mouse when possible) I found it very helpful to set up hotkeys to get to my most frequently accessed systems and research utilities as quickly as possible. While I have used this approach for many years, this is the first time that I am introducing my approach and a customer-facing hotkey script to the D.C. and OEx...

7 1
1 210
Question
· Mar 4, 2025
Message Count

Looking for a SQL query or any other method to find the Unique/distinct message counts for all productions or at least per production namespace within a given time frame. For e.g TimeCreated = January 2025 (Whole month)

I have used the following, but its not restricting the numbers based on the TimeCreated filter. Every time a new message is processed by system, its added to the total. I am running the query in today's date

Select Sum(MsgCount)

From

(Select DISTINCT TargetConfigName, count(DISTINCT SessionID) as MsgCount

FROM ENS.MessageHeader

1 12
0 218

The InterSystems platforms have always offered dynamic documentation of the packages and classes in a namespace, a feature known informally as Documatic. But what if you need to publish this class reference information on a website without requiring the site to be connected to an IRIS server containing the actual classes?

4 1
2 210

I added a Response Message Class to a call in the Business Process Designer.

When i click on Response Actions or on Response Builder i get a message

"You must specify a response message class in order to add or edit response actions."

no matter which response message i choose i always get the above warning.

how do i fix this?

Thanks

0 4
0 226
Question
· Apr 12, 2024
HowTo VSCode O

Hello all !!! I have a question: i heard it is possible to write Object Script code for Intersystems in VSCode. How it is possible to connect the InterSystems terminal to VSCode terminal ? I heard there should be a special docker. Currently i am trying to run a simple code which will communicate with the user through the terminal but it throws an error. thank you in advance for the answer !

0 3
0 227

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 230
Question
· Aug 25, 2022
SAM - Adding node_exporter

Note sure if anyone would know this.... But I presented my team with a Proof of Concept of running SAM to monitor our IRIS Development and Test Clusters. In talking with them we would like additional OS metrics that aren't provided by what is built into SAM. Looking at more OS detail I found node_exporter from Promethus. I added node_exporter to our server that we want to monitor, but then tried to config isc_prometheus.yml to use node_exporter. That did not go well and when I restarted SAM, it would not download the built in metrics to SAM.

0 3
0 227
Question
· Jun 1, 2022
Production Service connections

Hi Guys,

I have a service that picks up jobs and process them, is there a way that I can cap the number of attempts to pickup a certain job eg. 10 times if no response then just discard ?

Thanks

0 1
0 229