The Issue

I help support a legacy ZEN application that makes extensive use of the “dataGrid” component. The application reuses a ZEN page with a“dataGrid” for different views of similar data; depending on the view, the application hides or displays some of the columns of the “dataGrid”. The application does this client-side, setting the “hidden” property of the “columnDescriptor” true or false as needed.

Users have reported the following bug in the app: On views which hide a column, data in the other columns are shifted so as to appear under the wrong headers. In order to demonstrate the iss

Hi,

Has anyone tried the  InterSystems IRIS for Health Community Edition on Azure

https://azuremarketplace.microsoft.com/en-us/marketplace/apps/intersystems.intersystems-iris-health-community
It seems the image is the InterSystems IRIS for Health image instead of the Community Edition.

Thanks,

Rui
 

I have a cube that lists services, processes, and operations information and wanted to make the names of the items more user-friendly to end users and to use a flag to determine which components would be displayed in the dashboard.

We created another table/cube that has a status flag (1/0) to determine whether we would look at the item, the existing name, and the human-readable name.

What is the best way to reference the data in the new cube from the original cube to use the human-readable name?

Thank you, LG

Hi Developers!

This is the digest of new solutions and applications submitted to InterSystems OpenExchange in October 2019!

New applications in October 2019

simplemirror by Mario Sanchez Macias

This is a very simple docker-compose with a simple class that creates a mirror. It will create 2 folders (mirrorA and mirrorB) with the Iris installation files and mirror database MIRRORDB. Also creates a namespace MIRRORNS.

objectscript-rest-docker-template by Evgeny Shvarov

Very simple template to start development REST API with for persistent data in IRIS using  Docker.

IRIS OAuth example by Dmitrii Kuznetsov

This is a template for InterSystems ObjectScript Github repository. The template goes also with a few files which let you immedietly compile your ObjecScript files in InterSystems IRIS Community Edition in a docker container

vscode-multi-connection by Dmitry Maslennikov

Example project, how to configure and use multiple connections in one namespace with VSCode-ObjectScript

iris-datatransform-unittest by Alberto Fuentes

IRIS Data Transform UnitTest Sample

SetEnv by Eduard Lebedyuk

Set Environment Variables

DocumentTemplate by Zenkov Artem

DocumentTemplate allows you to use ODT and DOCX files as templates for rendering reports or letters.

msgpack by Maks Atygaev

Implementation of MessagePack protocol where you need something more compact and speed then JSON. https://msgpack.org

Twitter Sentiment Analysis with IRIS by Amir Samary

Use IRIS Natural Language Processing and its interoperability capabilities to fetch realtime tweets and analyze their sentiment as well as their metadata.

Apache POI by Eduard Lebedyuk

ObjectScript part for apache-poi integration. Allows reading xlsx.

RabbitMQ adapter by Eduard Lebedyuk

InterSystems IRIS adapter for RabbitMQ

Greetings community. I would like to know how to migrate a BD in production to a local environment. When I have a system in production (BD Sql Server) what we do is mount a local copy to do the analysis with the data and not occupy resources of the system in production. My question is: How do you do it with Intersystems technology? I already tested the PowerBi connector and it looks great, but that's where the question came up.
 

Hi Everyone,

Please welcome the new Global Summit 2019 video on InterSystems Developers YouTube Channel:

⏯ InterSystems IRIS and Intel Optane Memory

Hi Everyone,

New Coding Talk, recorded by @Evgeny Shvarov, is already on InterSystems Developers YouTube:

GitHub Repository Template To Develop and Debug ObjectScript in InterSystems IRIS

I am de-serialzing a FHIR Resource CodeSystem in STU3 FHIR resources from JSON in my Business Process using the following code:

set pCodeSystemResource = ##class(HS.FHIR.vSTU3.Model.Resource.CodeSystem).%New()
set tStream = ##class(HS.SDA3.QuickStream).%OpenId(pFHIRRequest.QuickStreamId)
if $IsObject(tStream) {
    set tSC = ##class(HS.FHIR.Utils).FHIRToHSFHIR(pFHIRRequest.ContentType, tStream, .pCodeSystemResource, "HS.FHIR.vSTU3.Model.Resource")
}

At this point it was validated that the ResourceType in the pFHIRRequest is "CodeSystem"

The error I am getting is in the  FHIRToHSFHIR Implement

Good Morning! How can I use the method Rewind() to read a file JSON?

For IRIS 2019.1 and later, the documentation has a new look and feel. Check it out:

https://docs.intersystems.com/irislatest/csp/docbook/Doc.View.cls
 

The underlying changes include a new style sheet and a complete rewrite of the code we use to generate HTML.  (There is now an underlying API for retrieving content as JSON, as well as a large set of unit tests -- for those of you who like that kind of thing!)

We're adopting the same HTML generation code for various static HTML files also served up on docs.intersystems.com, including the Supported Platforms document, the PDF index document, a

Hi,

I am trying to add an OR condition in the DTL but not able to. Sorry if this is a silly question, but can you advice?

I want to add a condition where if source.45 is "" or "..." then map "" to the target. But I am not able to add the OR condition

Currently I have as below

What will I need to do to add an "OR" condition to the DTL?

Would appreciate your guidance

Regards,

ED

Introducing non-persistent messages. eXpert-to-eXpert

Background

InterSystems Ensemble as a tool does a lot for the Developer. One of the nice features is the Message trace utility. It shows a message flow diagram. The diagram shows the progress of the message processing real time. You can get many-many useful information from the production. In any case, someone needs to find a bug in a production implementation, without the Message trace utility it could turn into a real nightmare. 

On the other hand, keeping message “traceability” is not for free. A heavy loaded production can very quickly run out of resources just because of the house keeping functions of Ensemble. House keeping functions such as maintaining message header, log entries, message queue generates a significant load on the Caché database used by Ensemble.

This article is about to show how to force Ensemble work more for the everyday life, instead of being prepared for “any-time-debugging”.

This is an eXpert-to-eXpert article. Therefore, I assume the deep understanding of Ensemble.

Hello,

We need to create a versioning of an existing API, so we going to set a default version (so far) for current connections to version 1

My first attempt is:

Hi,

     I am trying to update an year on a date field in a cache database table but it showing an error message. But the functions are working on select query. The query I used is 

update RB_ResEffDateSessPayorRestr SET RESTR_DATETo = DATEADD(YYYY,1,RESTR_DATETo) where YEAR(RESTR_DATETo)=2020

I tried to update only the year which are 2020.

Can anyone please help me, Is there any error in the query?

Thanks

I must be missing something. We have done encoded PDF's in the past with the Encoded PDF in OBX.5.5. When I have used this code in the past I was only working with 1 OBX, but I have a case where I am having multiple OBX's and having to loop through them and I am renumbering the outbound OBX.

<code>
<![CDATA[ // OBX]]></code>
<assign value='1' property='varOBXindex' action='set' />
<assign value='1' property='varOBX1' action='set' />
<foreach property='source.{ORCgrp(1).OBRgrp(1).OBXgrp()}' key='k1' >
<if condition='source.{ORCgrp(1).OBRgrp(1).OBXgrp(k1).OBX:ValueType}="ED"' >
<true>
<assign value='

Working on "HealthShare 2019.1 [HealthShare Modules: Core:17.0.9941 + Patient Index:17.0.9941 + Clinical Viewer:17.0.9941 + Active Analytics:17.0.9941] - Cache for Windows (x86-64) 2018.1.1 (Build 312_1_18859U) Tue Mar 19 2019 00:43:30 EDT"

In creating a DeepSee Cube - Pivot - Dashboard I am not finding out how to sort my rows by the row label value.

My Rows are numeric values, but they are sorting lexically not numerically. By this I mean that given the  Row Values 1, 2, 3, 10, 100 the rows ar being displayed in the Analyzer  in the alphabetic order of:

1 followed by 10 followed by 100 fol

Hi Community!

I'm pleased to announce the official start of InterSystems Developer Community in Spanish!

Here is the landing page which describes the thing:

Hi All,

We have a licensed version of Ensemble but for now, we use only the DB capabilities of Cache. As we create a custom Namespace, for e.g "Test", a new Ensemble Namespace is automically created by the system --"TestENS".

Is there any way where we can identify the system created ENS namespaces ?

Hi guys,
I ran into a strange (for me) situation, when I run same query but change the WHERE clause the plan is different and is not connected to the additional condition.
Query that doesn't use the necessary index:

SELECT * FROM Portal.ProductStats ps  left JOIN  Portal.ProductCacheUpdates pcu ON (pcu.Item=ps.Item) WHERE ps.Item=?
Takes 0.4 sec,  doesn't use index on item from Portal.ProductCacheUpdates table
SELECT * FROM Portal.ProductStats ps  left JOIN  Portal.ProductCacheUpdates pcu ON (pcu.Item=ps.Item) WHERE ps.Item=? AND  ps.dateImported<pcu.dateEdited
Takes 0.003 sec, uses index on item

Hi,

   I needs to send FileBinaryStream which stored in cahce DB to NodeJS.

Thanks

Preview releases are now available for the 2019.4 version of InterSystems IRIS, IRIS for Health, and IRIS Studio!

Container images are available via the WRC's preview download site.

The build number for these releases is 2019.4.0.379.0.

InterSystems IRIS Data Platform 2019.4  has many new capabilities including:

• Polyglot Extension (PeX) available for .Net
• ICM support for Tencent Cloud
• List Class available in the Native API for Java and .Net
• New CSF (Configuration State File) facility
• System security, performance, and efficiency enhancements
• Container and Cloud Deployment improvem

Hi Community,

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

⏯ Adopting InterSystems IRIS

Hi Developers:

The latest issue of our Developments newsletter just hit inboxes, but if yours wasn't one of them, you can download it from our landing page.

In this issue, you'll get links to some of the keynotes from Global Summit 2019, go on a deep dive into machine learning, and learn about a November webinar on the Machine Learning Toolkit.  

If you don't get Developments, consider SUBSCRIBING. 

Happy fall,

Jacquie
 

Hi,

       I am new to FHIR resources here i need to store patient  current location with patient resource but location resource does not linked with patient. I need help this. In FHIR R4 resources  having separate i implemented successfully  in my project but i am suffered how to link location and patient. I fount resources from https://www.hl7.org/fhir/resourcelist.html

    My Code implemented by nodejs with typescript language here i added graphql instead of rest
  

Hi all....

I couldn't find documentation on how to create a blob using the cache JDBC driver.
I found only one reading example:

https://cedocs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?…

The createBlob Method of the connection class was not implemented:

https://cedocs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?…
 

Does anyone know how to create a blob without compromising the java heap space?

When deploying IRIS in a container, what are recommendations for permitting users terminal access? There is docker exec -it, but that does not work from a user's workstation where - in the old deployment model - they would connect to the server over ssh using Putty and open a terminal session from there.

Can anyone tell me how to add a simple running total in Cache SQL.

I'm selecting a quantity in the first column and want a running total in the second:

9 ,   9

2 , 11

7 , 18

Would you like to be sure your data transforms work as expected with a single command? And what about writing unit tests for your data transforms in a quick and simple way? 

When talking about interoperability, there are usually a lot of data transforms involved. Those data transforms are used to convert data between different systems or applications in your code, so they are running a very important job.

Testing strategies

Having a look at the concept of Test Pyramid and some articles about it, we can have a quick idea that having a solid base of low level cheaper automated tests is a bett

I'm trying to setup Iris Community on a GCP node and the following fails

iris load https://github.com/intersystems/quickstarts-multimodel-python

Error:

sudo: /tmp/195/load.sh: command not found

in /opt/ISC/info.sh

    local directory url
    url=$1
    #get the directory where the bash script lives and add a random numbered new dir
    dir1="/tmp"
    dir2=$(($(od -An -N1 -tu1 /dev/urandom)))
    directory="$dir1/$dir2"
    
    #get the code and set permissions
    sudo git clone -q $url $directory
    sudo chmod -R 775 $directory

    #run the repo specific code
    sudo $directory/load.sh

I