All time
InterSystems Developer Community is a community of 23,271 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,

Learn about iris-lockeddown, a version of the InterSystems IRIS data platform container designed to work with the most stringent container security policies:

⏯ Using Containers in Highly Secure Environments with IRIS Lockdown

https://www.youtube.com/embed/01aK7BxarSE
[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 0
0 313

Hello,

I am trying to work out if there are any methods available to be able import a result set returned by SQL query into a persistent class.

I have to connect to some legacy SQL databases through SQL Gateway and run some queries. I need to inster the rows returned into a class to then be able to do a %JSONExport to produce a JSON object. I know I can iterate through the resultset and insert one row at a time into the class but was wondering if there is any other/direct way of importing the resultset rows into a class.

Regards,

Utsavi

0 1
0 312

Hi Developers,

It's time to announce the Winners for March 2021! Please welcome our awesome Global Masters Heroes!

The storm of applause goes to these developers and their great contribution to DC in March 2021:

🥇 @Robert Cemper, ex Senior Sales Engineer from InterSystems, Austria

🥈@Dmitriy Maslennikov, Co-founder, CTO and Developer Advocate, CaretDev Corp, Russia

🥉@Henrique Dias, System Management Specialist / Database Administrator, Sao Paulo Federal Court, Brazil

Learn more about the competition and our awesome winners below.

4 4
0 233

Hi Community,

Enjoy watching the new session recording from the InterSystems AI+ML Summit 2021:

⏯ AI+ML Summit Convergent Analytics – Healthcare Stream

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

Someone may have asked this before but is there a way to return the TRACE statements that we have placed in the Data transformation within the DTL Editor Testing Tool (EnsPortal.Dialog.TestTransform.cls)? Is this something we can get in an Enhancement request in for?

It would save sometime in troubleshooting where an error might be in the DTL.

Just wondering...

Thanks

Scott

0 1
0 312
Question
· Feb 20, 2020
Sql request

Hi All,

I need to build a search using a lot of filters, what's the best way to implement my sql requests.

1 sql request per property, or only one "big" sql request ?

what's the disadvantage of using lot of indexes ? Thank you

KR,

Amine

0 5
0 308

We have created a custom SDA container to store a certain kind of new, customized patient data.

We are observing a behavior in the correspoding analytics table for this custom SDA class where rows are added for a patient for which the MPI is null and the patient record does not exist.

0 2
0 311

I've setup ODBC connection so I can access Cache data within SQL Server.

I want to be able to write SQL queries for internal monitoring purposes, similar to what's possible with SQL Server. Specifically I want to be able to check mirroring status (i.e. check which is the current primary mirror member), check the status of any Ensemble productions (started/stopped), check the status of business hosts etc. I want to do all of this from SQL Server to go with our other system monitoring solutions.

0 1
0 312

Hi Developers,

Watch the latest video on InterSystems Developers YouTube:

⏯ Organizing HL7 FHIR Resources

https://www.youtube.com/embed/sql8Pgozsmk
[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 312
Article
· Apr 8, 2024 1m read
using Procedure Parameters with ODBC/JDBC

Hi,

I was struggling with a procedure that was meant to receive a string and use it as a filter, I've found that since I want the procedure to do some data transformation and return a dataset, I needed to use objectScript language.

I've created the procedure using the SQL GUI in the portal, and everything works fine when calling the procedure from the SQL GUI but not through a JDBC connection here is the call "call spPatientOS('2024-04-07T12:35:32Z')"

3 2
0 272

Hey Developers,

This August, you've posted 90 new questions on the Developer Community:

Questions

4 2
0 272
Article
· Jul 6, 2023 1m read
How to overload methods in ObjectScript

InterSystems FAQ rubric

The InterSystems ObjectScript language does not allow you to define methods of the same name with different arguments. It is generally classified as a programming language called a dynamic language.

In ObjectScript, you can freely control which arguments are used when executing a method, so unlike languages ​​such as Java, which are not dynamic programming languages, there is no need to strictly distinguish methods by the number of arguments at the compilation stage.

5 0
1 312

Hi,

I trying to find out the procedure to kill off a currently printing Cache job.

The user wants to cancel the job as they put the wrong start date. The start date was set to be generated from the default date of 1 Jan 1900.

As the start date was such a long time ago, the report generation would take a long time.

I think the printing uses this "production" on the print server:

Report.Print.Service.CachePrintService

0 2
0 310

Have just deployed IRIS in Azure and when accessing the filesystem through SSH I just can't see the ISC folder through the WSL ubuntu user, what am I missing here?

As I want to create new folders and use the same in test productions.
the needed directories are created in /home/azureuser but the same is not visible in IRIS file system

0 4
0 308

Hello everybody,

In the documentation I read the following:

Alerts are messages generated by production components. InterSystems IRIS automatically writes the alerts to a log file and sends then to the production component named Ens.Alert. If your production does not have a component named Ens.Alert, then InterSystems IRIS writes alerts to the log file but does not send them to any component. The component named Ens.Alert can be of any class. The most frequently used classes for Ens.Alert are:

0 3
1 309

Hey Community,

In this webinar, we’ll discuss how you can now easily integrate Apache Kafka within InterSystems IRIS data platform, including via interoperability productions and programmatically via API calls, as both a producer as well as a consumer of Apache Kafka messages:

⏯ InterSystems IRIS Tech Talk: Kafka

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

2 0
0 312

I am a newbie who is trying to learn how to set up a basic connection to Iris using a node js application. I am astounded at the lack of documentation there is on how to do this and even more concerning there are a few errors within the documentation. For example I am on the Native API application within the below link.

https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls...

0 5
0 307

Hi,

I wonder if anyone could help me.

I'm used to writing Microsoft SQL database queries, but at the moment I am also trying to write reports on an IRIS database (used to be cache) in Microsoft BIDS.

My chief headache is parameters. They don't behave the "normal way" in BIDS, in that you can't rename them. Therefore, referencing them in the main code is a nightmare for me.

Say my report has two parameters. If i want to refer to both in a dataset, I have to list them in the order they are in the report and both by using a question mark, ie:

0 4
0 308

Hi Community,

See how the new embedded Python feature enables you to write user-defined SQL functions and stored procedures in Python:

⏯ Embedding Python in SQL: Write Your Stored Procedures in Python

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

4 0
0 312
Question
· Dec 11, 2018
Websockets issue

Hello,

I'm trying to use Websockets and understand how it works. To do so, I tried to follow the sample in here :

https://github.com/intersystems-ru/WebSocketsSample

I opened studio, connected to my server into the USER namespace and use the Tools -> Import Local in order to add the 3 files (app.js.xml, index.html.xml and WebSockets.Main.cls )

I compile without error and use the View -> Web Page and it doesn't work as expected

0 2
0 310