Hi Community,

In this article I compared the features of the main leaders in the ODBMS gartner quadrant - 2019. See the list sorted by number of existent features.

1. InterSystems IRIS 2020.3 - 59 features (https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls)
2. Oracle Database 21c - 54 features (https://docs.oracle.com/en/database/oracle/oracle-database/index.html)
3. Microsoft SQL Server - 45 features (https://docs.microsoft.com/en-us/sql/sql-server/?view=sql-server-ver15)
4. AWS Aurora - PostgreSQL - 34 features (https://docs.aws.amazon.

Hey Folks,

I am creating my first record map to import a .txt file and eventually create a message outbound. When I try to pull in the sample file I get:

ERROR #5005:

Any ideas as to why? I have the sample .txt file saved as shown in the available directory. From what I have seen the #5005 error means the file is not available?

Since I'm just starting to use this aspect of IRIS I can't tell if this is a bug or some kind of nuance.  If I run a single column query like this, I get results:

However if I try to retrieve using a DISTINCT or GROUP BY, I get no results:

And again except with a GROUP BY, with no results:

If I add in some other columns I still get no results HOWEVER, if I add in a date column, I now get results:

What am I missing here?  Is this by design and if so, what governs whether a return set is returned or not?  I did purge my query cache in case something was happening there but it did not fix this.

Tiny web application that allows you to anonymize CSV files. Based on InterSystems IRIS®

Version:store/intersystems/iris-community:2020.3.0.221.0

Application

Sample CSV where Date of Birth and Sex will remain untouched, while the rest should be anonymized.

The application recognizes the header columns and allows the user to chose which ones to ignore.

After processing.

Setup

Make sure you have Docker up and running before starting.

Option 1

Recommended in case you just want to get the application up and running.

Hey Developers,

You're very welcome to check the most-watched videos for 2020 on InterSystems Developers YouTube Channel:

Index to Articles

Hi All

It's been 6 weeks since my original article 
- - - - -but I have been busy on this project 

I have been looking at/thinking about a replacement for ZEN for around 12 months but only really started in depth 4 months ago.
Also been in IT for long enough that I can "get a feel" for a product/technology and make decisions accordingly without going into great detail. 
Any new technology has a learning curve and I don't want to waste time and effort on something that won't fly. 
And, as always, I am looking to minimise the learning curve as I want to concentrate on delivering business benefit. 

Hello,

First of all thanks for your help,

We would need to get the list of all names, ports and types from the services listed in a namespace

We have read the following documentation:

https://docs.intersystems.com/latest/csp/documatic/%25CSP.Documatic.cls…

https://docs.intersystems.com/latest/csp/documatic/%25CSP.Documatic.cls…

In addition, we have read the following topics:

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

We released a new version of ZPM (Package Manager)

New in ZPM 0.2.10 release:

1) FileCopy

Added some improvements to already existing tag FileCopy

Example of module.xml

<?xml version="1.0" encoding="UTF-8"?>
<Export generator="Cache" version="25">
  <Document name="test-binary.ZPM">
    <Module>
      <Name>test-binary</Name>
      <Version>0.0.1</Version>
      <Packaging>module</Packaging>
      <SourcesRoot>src</SourcesRoot>
      <FileCopy Name="lib" Target="${libdir}my-lib"/> <!-- Copies content of lib folder to target -->
      <FileCopy Name="somefile.

DataGrip is a multi-engine database environment targeting the specific needs of professional SQL developers, DataGrip makes working with databases an enjoyable and productive experience.

To work with InterSystems IRIS from DataGrip you'll need to add InterSystems JDBC driver first (once per DataGrip) and after that add all your InterSystems IRIS connections.

Part 1: Add InterSystems IRIS JDBC Driver

1. Go To File → DataSources

2. Go to + → Driver

3. Set Driver properties:

• Name: InterSystems IRIS
• Class: com.intersystems.jdbc.

We've our Cache running on Windows 2012 Server, but I've a Macbook Pro. Earlier I was using Miscrosoft Remote Desktop 8, to remote into our Windows server & everything worked.

Since version 8 is discontinued, I installed Microsoft Remote Desktop 10.5, which works for everything except starting Terminal.

I get error 'NTI Connection Error'

(287) Error writing to Pipe
Reason: (998) Invalid Access to Memory Location.

If I do remote desktop from Windows machine (using same credentials), it works.

Earlier I'd kept both version 8 & 10, to work around this, but with recent MacOS update to 11.

One of the leading benefits of ObjectScript is the speed and efficiency it allows for an experienced developer. Let's look at an example of how you can benefit from ObjectScript today.

Suppose you have a class that stores the names of your users. We'll call the class Data.User, and give it a string property Name Next, we will need a method to create a new user or update an existing one.

This is a remote position for a US Citizen who has significant MUMPS background AND has experience at a deep level with Java, and AWS Services.

The location is in Kirkland Washington, however, obviously during the COVID we will be doing remote work.  Our hope is some is willing to relocated to the Seattle Region after we open up again.

Essential skill sets are:  competent if not excellent in MUMPS.   Cache Knowledge of a deep level.   Knowledge of Java and variants,  AWS - specific to hybrid cloud services - perferablly (blue sky here):  Certification as a AWS Architect - Professional.

Given a complex method flagged with [ SqlProc ] so it is available as an SQL stored procedure, what's the best way to report a non-system error detected in that method - say, for example, an error %Status - so that the SQL query calling it fails descriptively? Is it best to create and throw an exception, or are there special % variables involved (like in a trigger)? I haven't been able to find an answer in the documentation.

Thanks in advance!

Has anyone used the ##class(HS.JSON.Path).%Evaluate() classmethod interrogate JSON and return a specific object value? I need to extract the MessageHeader.destination.endpoint value from a FHIR bundle and can't seem to get that XPath-like method to work.

Hey Developers,

Here is a digest of the Developer Community videos on InterSystems Developers YouTube Channel in December 2020:

Hey Developers,

This post is a compilation of Top Authors, Top Experts and Top Opinion Makers of the InterSystems Developer Community in 2020. And it is a good guide "Who to Follow" in 2021.

We're glad to present these people who have contributed a lot to our community in 2020. 

Let's take a closer look at the DC Wall of Fame 2020 and greet everyone with big applause! 👏🏼 

the report generates statics for each ward and i want to divide specific ward 5c into two wards, the first 12 beds are for 5c - pediatric and the last 12 beds are for 5c-adults.

the report takes input from the user by selecting the wards so if the user chooses 5c, the report should show 2 wards.

the report declare cursor at the begining so how can i divide the ward.

Executive Overview

In most organizations, events drive action. In financial services, for example, a stock dipping below a threshold price may trigger a sell order. In manufacturing, production may start when an order is received. In healthcare, an unusual increase in the number of patients registering in an emergency room could signal the start of a disease outbreak, calling for action on the part of medical staff and public health officials.

In all of these cases, a business process is started, stopped, or modified based on an event or series of events.

In 2020 we implemented HealthConnect as our HL7 interface engine.  Having completed this, we are currently evaluating whether it would be beneficial to migrate our managed file transfers from our current MFT software, MOVEit to HealthConnect.  I am interested in hearing from any InterSystems customers who have previously used MOVEit and currently using HealthConnect for file transfer managment.  Any feedback would be appreciated.

Hi, I am creating a zen page which has a table pane, and loads data, using the onCreateResultSet. I have two controls which allows the user to add a date and type.

I want to add them as parameters into my sql query and update the tablepane. Can you advice on how I can do that?

<button id="fetchapt" label=" " caption="Fetch" onclick="zenPage.Fetch();" hidden="false"/>

ClientMethod Fetch() [ Language = javascript ]
{
   // i can get the values from my controls here

   var par1 = zenPage..getComponentById('dtfrom').

Hi,

The question is about queries on the System->SQL page. I have a class with a few columns on a global and the test output looks as expected, below. This works as expected as well returning a single row: select * from Utils.RoutineAuditReport where counter=4. However, other columns give an odd error like " Field 'AG' not found in the applicable tables^ SELECT * FROM Utils . RoutineAuditReport WHERE UserR = "AG". As you can see below, both the UserR column and the AG entry in it do exist. What could be the problem?

Thanks in advance,
Anna

Hi Community,

We're pleased to invite you to the online meetup with the winners of the InterSystems Analytics Contest!

Date & Time: Monday, January 4, 2021 – 10:00 EDT

What awaits you at this virtual Meetup? 

• Our winners' bios.
• Short demos on their applications.
• An open discussion about technologies being used, bonuses, questions. Plans for the next contests.

Greetings fellow Developers.

Has anyone used Mini Spine Services + PDS to verify NHS Numbers..?

Thank you.

I have a text control : <text id="clinic" label="Type Clinic Code ">. I want to retrieve the value of this control in my zen method. But I keep getting errors.

ClassMethod readValues(bData As %ZEN.proxyObject, act As %String) As %Boolean [ ZenMethod ]

{

  zenPage.getComponentbyId('clinic').getValue() // this doesnt work

%clinic.%GetValue(); // Tried this as well but getting errors

}

Can I get some advice on this? Apologies if this is a simple question. Just learning and developing using zen pages

I am hoping I explain this correctly.

We are using a query expire edge, to pass an API request to one of our vendor systems.

There is no feed into the gateway from an external system, and it is only used to query the external system with member data.

However, it is our understanding that the member needs to be registered on the edge.

Wondering if there is a way to export from the registry the bare demographic info in SDA to import to the new edge?

If anyone has done this and can point me to the right direction (documentation ect...) it would be greatly appreciated.

Thanks,

Ed

I have a operations that is writing 6 values to a table 

Class BHS.Custom.MosaiqCloudPatientsTable Extends (%Persistent, Ens.Request) [ Inheritance = right ]

I need to create a routing rule to evaluate a field in an hl7 ORU message ,  see if it exists in the account column of the table. If it does then allow the message to pass.

This table is not a lookup table. How can I get a function to evaluate a field to this  table?

I am new to zen pages, and trying to see how to get the value of a control.

Below is what I have

<combobox id="comboboxEdit" label="Select">
<option value="1" text="1" />
<option value="2" text="2" />
</combobox>

<button id="appointments" label=" " caption="Fetch" onclick="zenPage.Fetch();" hidden="false"/>

ClientMethod Fetch() [ Language = javascript ]
{

// how can I get the value of the controls here? can I do something like document.getElementById()?

}

Hi, I'm new in this place.

I would like to know how can I use Intersystems Caché in Linux Mint with the best performance?

My computer is not so good and I need a light version from this.

Hi all! 2nd time poster and still kind of a newbie. I Googled and searched the posts but did not find anything quite like my question.  I have an XML to HL7 2.6  MFN_M16 translation.  I created an XML schema and I am using it inside a DTL to translate data to HL7. The XML is rather simple EXCEPT one element as data separated by pipes. This only happens when one item has multiple PAR Locations.  To make a valid HL7 message these multiple PAR Locations each need their own IVT segment.