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

Hence the question: is there a way to do that?

The goal is to get data (from half a thousand to 3-4 thousands lines) from DB, calculate standart deviation then use it as logical condition in analyzer.

For example IF std > custom_value = show_the_result ELSE null

There is a STDDEV(MDX) method used in Analyzer but it is a measure and it can not be used as logical condition (correct me if i am wrong)

0 2
0 156

I am experiencing an issue while executing a stored procedure in InterSystems Cache. Here’s the procedure I created

CREATE PROCEDURE Silk.sp_InsertRecord (
IN RecordDate TIMESTAMP,
IN UserName VARCHAR(50),
IN RecordType INT,
IN RecordID VARCHAR(50),
IN CategoryID INT,
IN ApprovalDate TIMESTAMP,
IN FileSize BIGINT,
IN WorkstationName VARCHAR(50)
)
BEGIN
INSERT INTO DummyRecords (
RecordKey,
FilePath,
RecordDate,
UserName,

0 0
0 158

Hey Developers,

Play the new video on InterSystems Developers YouTube:

⏯ Chatbots are all the RAGe: Generative AI with InterSystems IRIS @ Global Summit 2024

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

Hi Community,

Here is a brief walkthrough on the capabilities of IRIS AI Studio platform. It covers one complete flow from loading data into IRIS DB as vector embeddings and retrieving information through 4 different channels (search, chat, recommender and similarity). In the latest release, added docker support for local installation and live version to explore.

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

Open Exchange app
3 0
1 158
Article
· Feb 18, 2024 2m read
Reviews on Open Exchange - #39

If one of your packages on OEX receives a review you get notified by OEX only of YOUR own package.
The rating reflects the experience of the reviewer with the status found at the time of review.
It is kind of a snapshot and might have changed meanwhile.
Reviews by other members of the community are marked by * in the last column.

I also placed a bunch of Pull Requests on GitHub when I found a problem I could fix.
Some were accepted and merged, and some were just ignored.
So if you made a major change and expect a changed review just let me know.

1 0
0 158

Hey Community,

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

New Videos
№ Video Views
1 Winners of the InterSystems Developer Tools Contest 2023 2196
2 Let InterSystems IRIS Do the Work: Git Source Control & Linting ObjectScript Across Editors 172
3 Introduction to AutoML 77
4 Real-Life Experiences Migrating a Caché Application Portfolio to InterSystems IRIS 68
5 [Webinar] Demo of Deltanji: source control tailored for InterSystems IRIS 65
6 Understanding your InterSystems Login Account & Where to Use It 65
7 Real-World CI/CD: Keep Calm & Build On 59
8 Online Meetup with the winners of InterSystems Developer Tools Contest 51
9 InterSystems Startup Accelerator Pitching Sessions 45
10 iris log viewer 44
11 Plugin Interactive Maps and Visualize Geographic Data to your application 40
12 IRIS Table Audit Demo 27
13 [Webinar] Demo of Deltanji: source control tailored for InterSystems IRIS 26
14 cosUrlShortener Demo 24
15 Using the DX Jetpack for VS Code to explore InterSystems classes 21
16 InterSystems Security Development Lifecycle 15
17 log viewer 15
18 Conduct Class Impact of Change Analysis into InterSystems IRIS 12

0 0
0 158

Hi Community,

Let's meet at the online meetup with the winners of the InterSystems Developer Tools Contest! It's a great opportunity to chat with the InterSystems Experts team and our contestants.

Winners' demo included!

Date & Time: Friday, August 8, 11:30 am EDT | 5:30 pm CEST

https://www.youtube.com/embed/5_-6pHAXFJI?si=-vItyGfrjDHzdIMA
[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]

3 1
0 137

The "Ask Developer Community AI" tool is an excellent resource for studying for the certification. I asked it about each topic that will be covered in the test and the results are below.
Note: I classified each answer by the assertiveness that I consider as good, average and bad.

Note 2: The article has 4 parts, each one for an exam area.

3 0
0 157

Hey Community,

Watch the new video on InterSystems Developers YouTube:

⏯ Smart Data Fabric for Generative AI Readiness @ Global Summit 2024

https://www.youtube.com/embed/Z-x6Rk7Bi3I
[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 157

Hey Community,

Play the new video on InterSystems Developers YouTube:

⏯ Container Lifecycle - When is Your App Ready to Accept Work @ Global Summit 2023

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

It is probably somewhere in the doc. So hard to search. Hope InterSystems going to AI on their community/support data.

How to see a meaningful value in management portal - sql explorer. For instance
Class MySetting Extends %Persistent{
Property Name As %String;

Class MyObj Extends %Persistent{
Property Setting As MySetting;

0 1
0 156

Hi Community,

Watch this video to learn how to create new business services and business operations in an HL7 V2 production in InterSystems products:

⏯ Creating HL7 V2 Production Components

https://www.youtube.com/embed/OLxvEYedv5o
[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 157
Question
· Mar 28, 2025
%NOCHECK for Objects

When batch inserting data into a table via SQL, I can use the %NOCHECK keyword to avoid checking foreign key integrity. This would be appropriate for cases when the inserted data has been verified by some external process.

However, when inserting via objects, I don't see a way to get the same behavior. Are there any workarounds that use objects for this?

1 4
0 152

Using SQL Gateway with Python, Vector Search, and Interoperability in InterSystems Iris

Part 3 – REST and Interoperability

Now that we have finished the configuration of the SQL Gateway and we have been able to access the data from the external database via python, and we have set up our vectorized base, we can perform some queries. For this in this part of the article we will use an application developed with CSP, HTML and Javascript that will access an integration in Iris, which then performs the search for data similarity, sends it to LLM and finally returns the generated SQL. The CSP page calls an API in Iris that receives the data to be used in the query, calling the integration. For more information about REST in the Iris see the documentation available at https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls...

8 1
0 136
Question
· Jan 2, 2025
Nested queries

Hi Guys,

This Nested query is not working for some reason, but they work fine when executing separately ?

select id from FDRD_Com.List where vehicle in (select Car from FDRD_Com.Prod where ProductLineName='Toyota' and Car is not null)

Thanks

0 3
0 153

Hello,
Please, we would need your help 🙂:

In a development environment, we have added quite a few presentation contexts to the DICOM configurations (the associations). We would need to find a way to export them from this environment to make it easier for us to import them in PRO (and avoid doing it by hand one by one).

0 2
0 154

Hi Guys,

I'm calling the expandAll() method to expand the whole tree structure but for some reason its only expanding the root folders but not all elements under those folders ?

var tree = zenPage.getComponentById( "MyTree");
tree.expandAll(true);

Thanks

0 3
0 153