Window functions in InterSystems IRIS let you perform powerful analytics — like running totals, rankings, and moving averages — directly in SQL.
They operate over a "window" of rows related to the current row, without collapsing results like GROUP BY.
This means you can write cleaner, faster, and more maintainable queries — no loops, no joins, no temp tables.
In this article let's understand the mechanics of window functions by addressing some common data analisys tasks.
Is there a way to import /export Web Applications? I can see that those web application that I created are also showing in Studio under CSP Files folder and I tried right clicking on some on the folders that seems to be representing my web application then export but didn't work.
I would like to install the IRIS Community edition on Oracle Linux 9.0 for x86–64 but it is not proposed on the Community loading page. the only Linux versions proposed are Red Hat 8, Red Hat 9, SUSE 14, Ubuntu 20.04, Ubuntu 22.04.
First of all thanks for your time, thoughts, teaching and help:
We wonder how could we get the metrics from http://[Ip]:[Port]/api/monitor/metrics and use them in Kibana to chart statistics.
We would like to ask you how do you use the api monitor metrics, and as a second question, how would you suggest to utilize them in a third party software as Kibana to chart them.
Watch this video to learn how to use the GitUI plugin in the HealthShare Health Connect Cloud user interface to make changes to your interfaces in the Management Portal and commit them directly to your source control workflow.
https://www.youtube.com/embed/A-jqnyKtCAM [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]
Interested in predictive modeling? This exercise shows how IntegratedML® works, and you can get practice creating a model with sample patient data. Try it out and share what you think!
https://www.youtube.com/embed/Q7_j_PHM6Ho [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]
https://www.youtube.com/embed/IdYEOQW6E0U [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]
CCR Beta Users will now be directed to the Angular Transition CCR page for markENVComplete and passPeerReview transitions. Other CCR transitions will go into beta soon.
Please raise any issues or feedback here or in your regular support channels.
I'm experimenting with FHIR bulk data load using NDJSONs, so far the import is running smoothly, but when I'm trying to perform a request of kind /Patient or /Procedure I'm getting back the following error:
https://www.youtube.com/embed/pxHrYN7_iKk [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]
in addition to HL7 V2 interfaces mediated via TCP/IP, we have been implementing more and more HS.FHIRServer.Interop.Service based services that are addressed via port 57772. We would like to secure access to the Management Portal now and have come up with a procedure that I would like to discuss.
I'm trying exported a project from version '2012.5' to '2018.1.4' but is returning ERROR #7602. Please, could you help me. How can I do it? Below is steps that I did:
We're super excited to share with you a special session from Global Summit 2023! And it is so special to us because it is about us and with us! Please welcome:
https://www.youtube.com/embed/JXexiNeRLFw [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]
https://www.youtube.com/embed/A477wcJL2LA [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]