All time
Question
· Apr 29, 2024
IRIS Dashboard/Deepsee Queries

Hi Everyone,

We are using SQL based KPI's to display reports in IRIS dashboards. We have applied the filter functionality in these SQL based KPI reports.

I need your help for below scenario.

Below is my full report. Filter is applied on Name and Subject Name in this report.

Now I have used filter on Name and selected values 'Virat' and 'Big Show'

0 1
0 166
InterSystems Developer Community is a community of 24,930 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 everyone.

I have a function that may end up being called from a number of transformations at the same time, and within the function there's some Embedded SQL to first check if a local table has an entry, and then adds the entry if it doesn't exist.

To prevent a race condition where the function is called by two transformations and they both end up attempting to insert the same value, I'm looking to use the table hint "WITH TABLOCK" on the insert, but this seems to be failing the syntax checks within vscode.

Are table hints supported with embedded sql?

0 4
0 163

Hi Guys,

I've upgraded from Ensemble 2014 to 2018 and copied all classes across, ran Upgrade & CompileAll and looks fine, but when trying to search on dataCombo I get the below error

here is the definition of the Combo

0 3
0 164
Question
· Mar 25, 2024
Separate data from classes

I am exploring a way to make IRIS an immutable system where the production/operation IRIS is never changed. Changes are only made in Development, and then the "version" is copied to production/operation and stated.

For this to work, I will need data (objects) on a file share and the IRIS system on different systems. When the "new" version spins up, it will use the latest data.

I do not know if I can or how to separate "object data" from classes and code.

1 1
0 166

Hi Developers,

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ Transforming HL7 V2 Messages in Health Connect

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

Hey Community,

Watch this video to learn about the latest developments in client connectivity across Java, .NET, JavaScript, and Python:

⏯ Language Connectivity: New & Next @ Global Summit 2023

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

Hi Community, you asked and here they are - badges for translations on Global Masters!

Badge's Name

Rules

DC Translator

Given for 1 translation

2nd Advocate level

Counted translations from English to all other language versions of Developer Community.

  • Positive rating (votes up) or zero votes
  • Posts from the Developer Community Feedback group are not counted.
  • Please note, there are 3-days delay between published translation and awarded badge.

Advanced Translator

Given for 5 translations

3rd Specialist level

Bronze Translator

Given for 15 translations

4th Expert level

Silver Translator

Given for 25 translations

5th Ambassador level

Gold Translator

Given for 50 translations

6th VIP level

2 0
0 167
Announcement
· Apr 20, 2021
gj :: connect

gj :: connect is a demonstration extension that shows how to extend the Intersystems Server Manager to perform custom actions.

It makes use of the context menu contribution points to add both in-line and right click menu options.

It also demonstrates how to create a new top level folder in your workspace corresponding to the server and namespace selected in Server Manager.

Open Exchange app
2 0
1 167

Hey Developers,

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

New Videos
№ Video Views Watch Time (hours)
1 WebSocket Client JS with IRIS Native API as Docker Micro Server 512 5,1
2 IRIS Python Suite: Installing Running and Using 105 3,8
3 Online Meetup with the Winners of the InterSystems IRIS Native API Programming Contest 95 5,0
4 In-Place InterSystems IRIS Conversions 85 16,0
5 PythonGateway-Template Demo 74 3,3
6 OData Server for InterSystems IRIS 68 2,0
7 IntegratedML-Template Demo 65 1,8
8 InterSystems Health Connect: New and Next 64 6,8
9 ZPM – Package Manager for InterSystems IRIS [Webinar] 54 5,5
10 InterSystems Israel Online Meetup: Introduction to Using Containers 54 2,0
11 IntegratedML: Predicting Readmissions 49 1,8
12 How to Generate Modules for InterSystems Package Manager (ZPM) 36 1,9
13 Reintroducing the Operational Data Store 31 3,7
14 InterSystems IRIS AI Programming Contest Kick-Off Webinar 27 2,3

2 0
0 167

Hey Developers,

Here is a digest of the InterSystems Data Points Podcasts in June 2020:

New Podcasts in June
Episode Podcast Name Guest(-s) Listens Count
#11

User Experience at InterSystems

 @Ksenia Samokhvalova 1 759
All Podcasts
Episode Podcast Name Guest(-s) Total Listens
#11 User Experience at InterSystems @Ksenia Samokhvalova 1 759
#10 All About SAM: System Alerting & Monitoring @Luca Ravazzolo 2 299
#9 Healthcare Interoperability: Part 2 @Russ Leftwich
@Jenny Ames		 2 244
#8 Healthcare Interoperability: Part 1 @Russ Leftwich 2 655
#7 Introducing InterSystems Reports @Carmen Logue 2 166
#6 InterSystems Certification @James Kantor 1 823
#5 Mirroring Databases for High Availability @Bob Binstock 2 361
#4 Optimizing Your SQL Performance @Benjamin De Boe 2 644
#3 IntegratedML in InterSystems IRIS @Thomas Dyar 3 733
#2 What is Kubernetes? @Luca Ravazzolo 3 628
#1 What is InterSystems IRIS? @Jenny Ames 3 461

1 0
0 167

🚨 Update, January 21, 2025 – Maintenance Completed 🚨

The planned maintenance on the Developer Community has been successfully completed! While the site is up and running, we are still performing additional testing, so occasional issues may occur.

We apologize for any inconvenience and greatly appreciate your patience. If you notice anything unusual, please don’t hesitate to let us know.

Thank you for your understanding and support!

9 Under Maintenance Page Tips | Messages for a Down Website

5 2
0 126

It's not supported at the moment but is it possible to implement the Sonatype Nexus (or JFrog Artifactory) support based on the current (or upcoming) IPM version?

In repo command help I see there is a support for filesystem repositories (which I have not yet tried) and my current (hopefully not far-fetched) interpretation is the IPM is designed to be able to support different repositories:

0 5
0 161
Question
· Sep 21, 2024
fileName in an FTP out

Hi All ,

I would like to add session ID to the fileName in an FTP out pass thru business operation.
How can I do that ?

<Setting Target="Host" Name="Filename">SessionID_%f_%Q.txt</Setting>

0 2
0 164
Question
· Aug 8, 2024
Restart Service

Hello! I was wondering if there was a way to have a Service in HealthConnect restart if there have not seen any messages in a certain amount of time? I have a connection problem that requires me to restart services often and I was hoping to create a task that would automatically restart the services. Thank you!

0 1
0 165

We have a custom business service that is triggered by a scheduled task. The service queries a table, iterates over the result set and sends a message on to a business process for each result. Happy path functionality is all fine.

However, when there is an error detected in the business service code, neither throwing an exception nor returning an error %Status behaves as we'd expect.

0 1
0 165

Hey Developers,

Do check out our list of most popular videos of the year 2023 from our InterSystems Developers YouTube Channel:

Top 10 videos by views
№ Video Views
1 Multi Model Capabilities of InterSystems IRIS 57924
2 Integration Features of InterSystems IRIS 50628
3 Connecting to InterSystems Cloud Services with Python 40346
4 What Is InterSystems Supply Chain Orchestrator? 35154
5 The Future of Care Begins with InterSystems and FHIR 32532
6 Welcome to the InterSystems Ideas! 29114
7 Using the Business Process Designer in InterSystems IRIS 28092
8 Message Flow in an Integration Solution 25364
9 InterSystems Java Contest 24468
10 What is InterSystems TrakCare 24465

5 1
0 146
Question
· Aug 25, 2022
Ensemble Local Installation

Hi Team,

I am new to InterSystems. I am trying to setup DHTML editor with ActiveX control for Trakcare 2021.7 version. I am receiving Ensemble locally not installed error. Could you please guide me for using Ensemble in local windows machine

0 1
0 165