InterSystems IRIS is a Complete Data Platform
InterSystems IRIS gives you everything you need to capture, share, understand, and act upon your organization’s most valuable asset – your data.
As a complete platform, InterSystems IRIS eliminates the need to integrate multiple development technologies. Applications require less code, fewer system resources, and less maintenance.
Hello guys,
I need to tranform columns into rows or rows into columns.
I'm using only SQL Cache.
The code:
SELECT
codRepresentante
,vendasAbril
,vendasAgosto
FROM
Ped.MetasRepresen
WHERE ano = 2024The columns:
.png)
Can you help me?
Thanks
Hi Everyone!
The Certification Team of InterSystems Learning Services is currently developing an InterSystems ObjectScript Specialist certification exam, and we are reaching out to our community for feedback that will help us evaluate and establish the contents of this exam.
Please note that this is one of two exams being developed to replace our InterSystems IRIS Core Solutions Developer exam. You can find more details about the other exam, InterSystems IRIS Developer Professional exam, here.
How do I provide my input? Complete our Job Task Analysis (JTA) survey!
Hi everyone! I am hiring an InterSystems IRIS Engineer If you or anyone you know has a qualifying skillset and is interested, please email me your resume and I will give you a call. Thanks! email: isabella.nolen@insightglobal.com You can also apply to my posting on LinkedIn: https://www.linkedin.
I'm working on some code that would benefit from being able to see whether or not a project file has been saved in Studio.
I can see when I make changes, that the project name has an asterisk added to it:.png)
In searching for it, however, I haven't been able to find any methods or calls to access the property/check that controls that asterisk.
My question is whether anyone out there knows if that is accessible and if so then how can it be accessed.
I'd like to add a check in my code that enforces that the project file must be saved prior to proceeding with the intended action.
It's been a while since I've posted about Embedded Git on the Developer Community, and I'd like to provide an update on the massive amount of work we've done this year and where we're going next.
If you're building solutions on IRIS and want to use Git, that's great! Just use VSCode with a local git repo and push your changes out to the server - it's that easy.
In the previous article. Practices of class members and their execution within embedded Python. We will now turn our attention to the process of switching namespaces, accessing global variables , traversing and routine executions within embedded Python.
Before proceeding to the other functions. let us briefly review the execute function within the iris package. This function is exceptionally beneficial for executing the arbitrary ObjectScript functions and class invocation.
I inherited some legacy MUMPS / ObjectScript code. A code review identified an exclusive NEW and that is not allowed per our coding standards.
The original code contains:
RUN(CALL,DRVNAME)
S $EC=""
S ^TMP($J,"RMPV","DRVNAME")=DRVNAME
N TMPFILE,OLDIO
S OLDIO=$IO
I $G(^TMP("RMPV","SILENT"),1) S IOP="NULL",%ZIS=0 D ^%ZIS I '$G(POP,1) U IO
D INIT^@DRVNAME
D ; scope variables
.N (DUZ,CALL) ; Protect %response
.S IOF="""""",IOM=80,U="^"
.
In your Interoperability Production you could always have a Business Operation that is an HTTP client, that uses OAuth 2.0 for authentication, but you had to customize the Operation for this authentication methodology. Since v2024.3, which was lately released, there is a new capability, providing new settings, to handle this more easily.
Hello everyone! This is my first post into the developer community and one that I hope is fairly simple to answer. In our environment we currently have 3 different Test environments for testing before migrating code to our Prod environment. Currently we are working on establishing a source control method using Git in house which has been a bit of a struggle. We have also had developers that had used different test and migration methods in the past which has caused some issues with keeping the different test environment in sync.
Hello,
Is there a single ObjectScript operator or method to concatenate two %DynamicArrays?
I'm looking for something that will do the following:
set arr1 = [ 1, 2, 3 ] set arr2 = [ 4, 5, 6 ] set arrcombined = arr1.%Concatenate(arr2)
or
set arrcombined arr1_arr2
With end result:
zw arrcombined arr1=[1,2,3,4,5,6] ; <DYNAMIC ARRAY>
I can iterate and %Pop over the 2nd array and %Push each popped entry to the 1st array, but I was looking for something more succinct.
Thanks in advance.
Everytime I try to send a POST FHIR bundle I'm getting the following response: 404 Not Found. I'm not really sure why, although it works fine with a GET!
This is an example:
.png)
Response:
.png)
It might be something related to request path but not really sure.
And this is the HTTP service I'm using
.png)
I tried this with Postman and it's working as expected
Am I missing something ?
The IKO documentation is robust. A single web page, that consists of about 50 actual pages of documentation. For beginners that can be a bit overwhelming. As the saying goes: how do you eat an elephant? One bite at a time. Let's start with the first bite: helm.
What is Helm?
Helm is to Kubernetes what the InterSystems Package Manager (IPM, formerly ObjectScript Package Manager - ZPM) is to IRIS.
It facilitates the installation of applications on the platform - in a fashion suitable for Kubernetes.
Hi Community,
I need to remove first tag from a XML file in service and send file to the process ,how do i remove line from the File and process it
Thanks,
Smythee
Hi,
I recently had a company-enforced OS upgrade, and ever since going from mac OS 14.x to 15.x, I am currently having issues with SSL in IRIS.
An ARM (M3 pro) machine running OS 15.2, with the latest Docker Desktop (at the time of writing, 4.37.0). The Docker container runs IRIS for UNIX (Ubuntu Server LTS for x86-64 Containers) 2022.1.2 (Build 574_0_22161U). This container has not changed.
When attempting to run some local API tests of our software, I am hosting a Wiremock (https://github.com/wiremock/wiremock) server locally on the mac, in order to mock HTTP requests/responses.
Hey Community,
Enjoy the new video on InterSystems Developers YouTube:
Hi! I've extended my demo repository, andreas5588/demo-dbs-iris, to make it easy to test the FOREIGN SERVER and FOREIGN TABLE features in IRIS.
To achieve this, I created a namespace called FEDERATION. The idea is as follows:
The Script: demo-dbs-iris/src/sql/02_create_foreign_server.sql.png)
IRIS does not support executing SQL statements that combine tables from different namespaces.
how i can connect to cache database from visual studio 2017-2022?
TQ
As part of a migration project from a bunch of java classes to IRIS, we need to maintain a few jar files due to some external dependencies.
The problem I am seeing is that I cannot pass a byte array ( byte[] ) from ObjectScript to the Java Class. I have tried a number of different ways
I have reproduced in a java class and Objectscript class:
Java Class:
package wrc;
public class TestJava {
public static void testByteArr(byte[] keyBytes) {
System.out.println("keyBytes getClass() = " + keyBytes.getClass() );
System.out.println("keyBytes toString() = " + keyBytes.InterSystems has corrected a defect that causes invalid database and journal records to be introduced when using a specific $LIST syntax. The likelihood of encountering this defect is very low but the operational impacts can be significant.
Products Affected
Hello Community !
We are delighted to invite all our customers, partners and community members to participate in the InterSystems Benelux & France Summit 2025! The registration for the Summit 2025 is already open.
This event promises to be an interactive experience highlighting inspiring case studies, technological innovations and roadmaps for the coming year in the fields of healthcare and data platforms. Hands-on demonstrations will also allow you to explore the latest developments in a tangible way.
➡️ InterSystems Benelux & France Summit
🗓 Dates : February11 - 12, 2025
📍 Place : Hilton Rotterdam | Weena 10 | 3012 CM Rotterdam | Netherlands
I'm currenlty searching the developers coummnity , but thought I asked this question while I search. How can I use the task schedulrer to purge backups? Do i have to create my own class? Examples on doing this?
Hello,
In short, I am trying to get the Content-Length of my response,
We have a CSP application, when we get a new request we begin to process it, throughout the app we WRITE to the response in different places,
now when the response is about to be sent back to the client - we would like to know its Content-Length (in the RESPONSE HEADERS).
So it comes down to two questions:
1. How can we access the Content-Length of our response?
2. In case we CAN'T - Where in the broker.cls/page/base classes can I observe the moment we actually write the response itself and attach its headers?
Thank you!
I'm sure I've seen this issue reported before, but a search hasn't turned it up.
This appears to happen randomly, but once it starts it doesn't seem to stop ... at least for a while. I attempt to compile a class and compilation fails but produces no error explaining why. Here's an example:
.png)
The last two compilation errors repeat indefinitely (or at least until I've found and fixed the issue), but I can open the class in Studio, compile, and get the error information in the output panel every time. The compilation qualifiers are the same in both.
Hy Friends,
I have a little problem, I need to diplay the data based on input status (first time and after)
this is the data:
.png)
and this what I need to display
.png)
the notes become new because it is the first time that the data has been inputed, and it will become old if we have the data before (2nd data, 3rd data the notes will become old).
I've try to use SubQuery (with LAG Script also) but it doesn't works, because it will give a notes Old even it's a New Data
Does anyone could help me ?
Thank You
Best Regards,
Steven Henry
I downloaded IAM-3.4.2.0-5604.tar.gz from the Online Distribution site this morning, it the implementation to install it on our Development environment to see if it is a viable solution. Following the instructions, I have ran into an issue trying to make sure I am entering the information into the prompts correctly.
I have IRIS HealthShare Health Connect 2024.1 running locally using a Local Web Server, so when prompted I have entered the IP Address and port 443 is that correct?
:>iam-setup.sh
Welcome to the InterSystems IRIS and InterSystems API Manager (IAM) setup script.
Hello
I am trying to work with UDP Connection/Adapter and I get this error.
Here is the method
Parameter ADAPTER = "EnsLib.UDP.OutboundAdapter";
Property Adapter As EnsLib.UDP.OutboundAdapter;
Method SendData(pInput As Ens.Request, Output pOutput As Ens.Response) As %Status
{
Try {
Set status=$$$OK
Set pOutput=##class(Ens.Response).%New()
Set stream = ##class(%Stream.GlobalCharacter).%New()
Do stream.
If you're running IRIS in a mirrored configuration for HA in GCP, the question of providing a Mirror VIP (Virtual IP) becomes relevant. Virtual IP offers a way for downstream systems to interact with IRIS using one IP address. Even when a failover happens, downstream systems can reconnect to the same IP address and continue working.
The main issue, when deploying to GCP, is that an IRIS VIP has a requirement of IRIS being essentially a network admin, per the docs.
To get HA, IRIS mirror members must be deployed to different availability zones in one subnet (which is possible in GCP as subnets always span the entire region). One of the solutions might be load balancers, but they, of course, cost extra, and you need to administrate them.
In this article, I would like to provide a way to configure a Mirror VIP without using Load Balancers suggested in most other GCP reference architectures.
References:
ObjectScript always follows strict left-to-right execution of arithmetic operators.
The && operator evaluates the left operand and returns a value of FALSE (0) if it evaluates to a value of zero.
I tried executing the SQL JSON_TABLE query with large JSON string(more than 200000 characters) and I got the below error. I'm curious about this under the hood workflow and how does it reach reaches MAXSTRING.
Thanks!
