Looking to pull out HL7 Fields data to put into columns in a SQL table. How to handle the repeated fields & segments data to SQL.

Operations over the extracted data in SQL server can help for Analysis.

Appreciate your Help!!

Hi,

I have over 36 years of experience developing solutions with MUMPS and Cache. Additionally, I also develop in Python and HTML.

I have no experience in Vista or PSL, but I would be very happy to have the opportunity to learn it. I'm looking for a job opportunity.

Best,

Carlos

Hi developers!

I just want to share with you the knowledge aka experience which could save you a few hours someday.

If you are building REST API with IRIS which contains more than 1 level of "/", e.g. '/patients/all' don't forget to add parameter 'recurse=1' into your deployment script in %Installer, otherwise all the second and higher entries won't work. And all the entries of level=1 will work.

/patients

- will work, but

/patients/all

- won't.

Here is an example of CSPApplicatoin section which fix the issue and which you may want to use in your %Installer class:

    <CSPApplication Url="${CSPAPP}"
      Recurse="1"
      Directory="${CSPAPPDIR}"
      Grant="${RESOURCE},%SQL"
      AuthenticationMethods="96"
      />

Hi Developers,

Please welcome another "Coding Talk" video specially recorded for the second IRIS Programming Contest:

⏯ How to Build, Test and Publish ZPM Package with REST Application for InterSystems IRIS

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

Hi Community,

Watch this video to see how to connect to InterSystems Cloud Services from your Java application using the InterSystems JDBC driver:

⏯ Connecting to InterSystems Cloud Services with Java

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

Hey Developers,

Learn about the use and design of the InterSystems FHIR Transformation Service and the InterSystems FHIR Server, and what to expect next:

⏯ FHIR in the Cloud: Understanding New InterSystems FHIR Server

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

i noticed -by reading .INT files of one class- that some of embedded sql select statements code blocks translates into code that uses lock command.

even if i use %nolock in the select, still cursors and arrow referencing notations "->" have the same results.

Hi Community ,

I have installed InterSystems IRIS Community in my personal laptop to do some POCs.

Here are the defined namespaces available:
%SYS
HSCUSTOM
HSLIB
HSSYS
PPONUGOTINS
USER

How to create samples in it?

please advice me.

Thanks,

Prashanth

ZV = IRIS for UNIX (Red Hat Enterprise Linux for x86-64) 2021.1 (Build 215_0_21260U) Tue Nov 9 2021 19:32:21 EST

I have pdf documents stored in repo edge HS.IHE.XDSb.Repository.Documents. Is it possible that this can further compress this type of binary stream?

below is the code I can see but Is this applied on 2021.1?

In a tag-based CSP page, I can define (e.g.):

<script method="Foo" language="cache" runat="server">

The power of the presented tool becomes visible with a large JSON file.
The example I have prepared is composed of the daily results of AoC 2023.
Anonymization makes it usable for demo purposes.

There are many options to do a full security scan in your docker images, the most popular option is Anchore community edition.

Anchore will use the main public vulnerabilities databases available, including CVE.

To install Anchore is very ease (source: https://engine.anchore.io/docs/quickstart/), follow the steps:

Someone have experiences interconecting NonStop SQLMP with Iris ?

I need if possible some references or tips, actually connected with JDBC driver to interconnect and take many assorted problems, like :

Some queries, not to much, have null fetch, works fine but have no content to fetch, and i'm sure select sentence is not the problem.

I'm trying to tie IRIS (2019.1) into our Concord Fax cloud-based email-to-fax workflow. We have some sites that require a fax be sent to multiple locations based upon certain data (ie Radiology and Emergency departments). Unfortunately, CC-ing does not work with Concord Fax so I need a way to send the email, change the recipient, and then send it again if certain criteria are met. Is this possible? Do I need to duplicate and rename the method, calling the second one in the MessageMap?

Here's what my code currently looks like: