During runtime I build an object which is essentially a wrapper over in-memory table:

I want to use this object as a part of INSERT or UPDATE queries, based on a value of some column (the main use case one of the columns is an ID value)

What's the best way to expose the object to SQL?

Hi everyone,

The project IRIS History Monitor received an update, using ZPM and the built-in REST API /api/monitor/metrics.

Hello,

We would need to convert a message from the following class:

Class Mensajes.Request.Laboratorio.HL7Request Extends Ens.Request [ ClassType = persistent, ProcedureBlock ]
{ Parameter RESPONSECLASSNAME = "Mensajes.Response.Laboratorio.ACKResponse";

Property mensaje As %XML.GlobalCharacterStream(CONTENT = "MIXED");

Property idPeticion As %String(MAXLEN = "");

Property ExpedienteUsuario As %String(MAXLEN = "");

Property MessageId As %String(MAXLEN = ""); Property ContentType As %String(MAXLEN = "");

to a Request message which is composed by hl7 segments:

Class Mensajes.Request.Laboratorio.

Share massive amounts of healthcare data faster, easier, and in any standard format. See how in the Interoperability for Health video, just released from Online Learning!

Hi Community!

 It's time for New Badges on InterSystems Global Masters Advocacy Hub! 

Please welcome:

✔ InterSystems IRIS Reporter Badge
✔ InterSystems IRIS Blogger Badge
✔ InterSystems IRIS Influencer Badge
✔ InterSystems IRIS Opinion Maker Badge

How can GM Advocates get these badges? See the details below.

I am developing a BPL with a delay process. 

The problem I have is when a message is delayed I cannot see a job id so whilst a job is in halt status I cannot see how i can then cancel the message? It obviously doesn't show up in queues as it isn't active either. 

Am i missing something?

Hi Community,

We just updated the "EVENTS" section on the Developer Community website! 

What's new? Now it includes an event calendar for InterSystems Developers.

Hi Developers!

As you know in the second contest we introduced technology bonuses. Learn more.

You can see what app got what bonuses in the Technology Bonuses menu:

And here I want to share with you which apps got the bonus. Here we go!

Hey Developers,

We're pleased to invite you to the "Best practices of in-platform AI/ML" webinar by InterSystems on April 28th at 11:00 EST/17:00 CET.

Hi,

I want to know if there is a way to manually change Primary to secondary  and vice versa?

I need this becasue we backup the two VMs (primary and secondary) and my idea is to make a script to when the primary VM is going to backup with Veeam change to "backup" on the mirror.

Thanks!!!

After the database is restored, the WIJ file may be incompatible, so I deleted the WIJ file, and it needs to be set manually at startup

message in cconsole.

MX: Mumps & eXcel Joining - But Why?

At medium and small manufacturing enterprises, there are many technological and financial problems for the solution of which Microsoft Office is traditionally used, more precisely its more engineering part: Excel.

This is not only a tribute to tradition, excel is truly an unsurpassed tool for economic analysis and technological calculations. The number of users is in the millions. And these are only legal installations. In addition, there are analogues in the form of Free Office, Open Office and other.

Hi , I started a purge job, but now I am totally running out of space. Is there any way to stop or kill the purge job?

Would appreicate some guidance on this

I've been reading the documentation guide for 2018.1 over frozen query plans several times in the last days (link) and there is an answer I can't seem to find directly.

I've noticed Caché has bindings for several languages. Would there be a reason to, or are there any plans to include bindings for the Rust language? I haven't been able to find any information on the topic.

Hi Community,

We're pleased to invite you to join the upcoming InterSystems IRIS 2020.1 Tech Talk: API-First Development on May 5 at 10:00 AM EDT!

In this week's InterSystems IRIS 2020.1 Tech Talk, we'll discuss API-first development and how InterSystems is embracing this industry trend with our API Manager, and specifically with our FHIR offerings. First, we'll talk about InterSystems API Manager. This tool controls your web-based API traffic in a single location. You can throttle throughput, configure payload sizes and whitelist/blacklist IPs, among many other features.

FHIR stands for Fast Healthcare Interoperability Resources. Release 4 brings this HL7 standard to maturity, and the FHIR R4 support in InterSystems IRIS for HealthTM is big. You'll learn how to work with FHIR data in InterSystems IRIS, and see our developer portal in action, where you can access FHIR resources using the OpenAPI specification.

If you define a Persistent Class / Table the class compiler generates for you an appropriate Storage definition.
A different option is to define a SQL mapping for an already existing Global storage.  This has been excellently
explained already in a different series of articles.   The Art of Mapping Globals to Classes 1 of 3

Everyone

There is a setQueryTimeout method in the% Net.Remote.Java.JDBCGateway class of IRIS, how to use Ensemble2016 to achieve this function?

i've noticed a strange bug in the 'problem highlighting' of VSCODE and i wasn't sure if this is a problem with the internal library definitions of iris, or with the plug-in itself.

The first line is the correct macro call, but the second one is the one throwing the error. (preprocess vs prepOrocess)

How is this syntax checker's list of strings compiled?

Hi Team,

I am creating an API POST method to which the Web Requests will come. I want to identify that from which device (Mobile, Tablet, Laptop, Ipad etc) the request came. 

Let me know if you need more details from me regarding the question.

I want to check the SDA to see if a patient had two diagnosis on the same day using a Detail Filter in Push. What is the best way to approach this?

Hi Developers!

Want to participate again in the competition of creating open-source solutions using InterSystems IRIS Data Platform? 

Then we're pleased to announce the second InterSystems IRIS Online Programming Contest!

And the topic for this contest is InterSystems IRIS with REST API.

The contest will again last three weeks: April 13-May 3, 2020. 

Also, please join the InterSystems Contests Discord Channel to chat about contest and technology.

Hi all.

A long time ago I enabled Activity Monitoring to be able to save myself headaches in the future when looking at the performance of various message routes through our productions.  It's served it's purpose of answering questions on how many messages we process a week etc but I had not had the chance to really dig down into the stats for specific message types or destinations to pin point issues.

That time has come, as I have an outbound that periodically queues up without much rhyme or reason.

The typical WHERE condition in SQL relates mostly to some content of the rows you work on.
So it needs to be calculated and checked for each row you access.
Differently (and that's why I named it STATIC) is a WHERE condition that is independent of the rows you access.

Hi There,

I have Microsoft Visual Studio Community 2019 installed and tried to setup the entity framework as per Using Entity Framework with InterSystems IRIS Data Platform (https://learning.intersystems.com/course/view.php?id=1046)  tutorial but I can't see the ISC data source in MS Visual Studio's Data source section. Does this mean that MS VS Community 2019 is not supported with the Entity Frmawork?

Hassan

We are using Ensemble 2018.1.3.

I am trying to import the org.apache.poi jar file (I have same problem with 3.8, 4.0.1, and 4.1.2).

Whenever I try to import the org.apache.poi.hssf.usermodel.HSSFWorkbook class using the Java Gateway Wizard, I get an XML error such as the following: 

ERROR #6301: SAX XML Parser Error: Line: 215 Offset: 20 invalid character 0x5 while processing /hs-connect/sys/mgr/Temp/mMQ5qDvObKsxaw.xml at line 215 offset 201

In doing some digging, it looks like the problem is in the org.apache.poi.POIDocument.

I enjoy the challenge of being in a contest. Currently I participate in InterSystems IRIS with REST API Programming Contest. My idea for this contest was to create an app to help me keep track of tasks for my Status Reports. I started with the template provided by Evgeny Shvarov. I created a persistent class for Tasks and a REST Dispatch class. I defined my URL map and I even figured out how to test my REST app using Postman. I felt proud of myself for a little while.

Hi Community!

The new video from Global Summit 2019 is already on InterSystems Developers YouTube:

⏯ System Alerting and Monitoring Made Easy

Get the latest from Learning Services!

• Navigation pages in InterSystems documentation
• New podcast episodes: InterSystems Certification and InterSystems Reports
• New online learning: Connecting Devices video, HL7 Business Services and Business Operations course, Use FHIR APIs to View Resources exercise
• Upcoming webinars

Read more and subscribe to get Learning Services news once a month in your inbox! 

When I describe InterSystems IRIS to more technically-minded people, I always start with how it is a multimodel DBMS at its core.

In my opinion that is its main advantage (on the DBMS side). And the data is stored only once. You just choose the access API you want to use.

• You want some sort of summary for your data? Use SQL!
• Do you want to work extensively with one record? Use objects!
• Want to access or set one value and you know the key? Use globals!