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 fr

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 improvements

Inte

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 better

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 don't see a

When dealing with a support issue of one of our Deltanji source control sites this week I learned that if you're using InterSystems versions earlier than 2018.1 on Unix-type platforms it's possible that a class you export in UDL format will subsequently fail to import. So I'm posting this information here in case it helps other folk.

If you're doing Zen development your classes are likely to contain ClientMethod definitions scripted in Javascript.

Hello,

Is there a way to list all items in a production (incl their status/color) by using a sql query? This is for monitoring purposes. 

Thank you in advance!

Regards,

Luk

When calling the below stored procedure using the management portal (Run Query) no data is being retrieve, but if it is directly executed management portal data will show.

"IN" does not work changing it to "=", "like" the stored procedure will work. Does any one know how to fix this ?

Pass values to code is  'AB','TS','SK','GM'

Query LoadData(code As %Library.String) As %SQLQuery [ SqlProc ]
{

SELECT STRING(Descrtiption,' (',Code,')') as Description,Code FROM Test.Codes 
WHERE Code  IN  (:portCode)
}

Hello everyone,

I want to introduce you my project.

There was a common task in my work to create documents, in which I need insert some information about person: full name, birth date, address and etc. I wrote the application to do it in the simplest way.

The idea is not brand new and was implemented in other languages. I wanted to make a similar tool for Cache Object Script. The concept is following.

You create a template document in LibreOffice or Microsoft Word using special semantics.

Than write a method or procedure in which all variables used in template are defined.

InterSystems Online Learning has updated courses to include the latest information about InterSystems IRIS. See descriptions below, and try a course today!

Troubleshooting Productions
Get an introduction to troubleshooting productions, with a focus on locating and understanding some of the key Management Portal pages when troubleshooting.

DTL Basics
Learn how to create data transformations using the graphical interface in the Management Portal.You'll also see how to map fields, use functions to modify the fields and use literals as values for the fields.

Hi Community,

As you may know, we successfully held InterSystems Developers Meetup in Boston at Global Summit 2019. And now it's time to find out which solutions development on InterSystems IRIS have been discussed! 

Please welcome the Meetup video recording on InterSystems Developers YouTube Channel:

⏯ InterSystems Developers Meetup - Global Summit 2019

I am having trouble sending URL encoded payload to eFax in FormData. Does anyone have experience working with the eFax? Their support is not the greatest.

This is what I am trying to send

s rObj.ContentType="application/x-www-form-urlencoded"

d rObj.InsertFormData("id", "123456789")

d rObj.InsertFormData("xml", $zcvt(filestring,"O","URL"))

Any suggestion would be greatly appreciated. 

Hi, We have DSM-Mumps Database,Now We are planning to migrate DSM-MUMPS Database migrate into IRIS

please let me know anyone How to migrate DSM-MUMPS Database migrate into IRIS?

Hello!
There is a class query “MemberStatusList” in the SYS.Mirror class that I would like to call from a .NET client application. 
I know that means that there is also a generated class method called MemberStatusListFunc. 
What is the best way if any exist to call them from a .NET application?
Just see if anything responded I tried using something like
…
IRIS iris = IRIS.CreateIRIS(conn);
var returnValue = iris.ClassMethodString("%SYSTEM.Mirror", "MemberStatusList", "NAMEOFTHEMIRROR")
---
That executes the method and returns the reference as a string to a %SQL.ClassQueryResultSet.
Obviously I would

The Learning Services Online Learning team has posted new videos to help you learn the benefits of InterSystems IRIS. Take a peek to see what you stand to gain from making the switch to InterSystems IRIS!

Why Multi-Model?
Stefan Wittmann presents use cases for the multi-model data access of InterSystems IRIS data platform. He shows the multi-model architecture that allows you to use the data model that best fits each task in your application — relational, object, or even direct/native access — all accessible through the language of your choice.

The Speed and Power of InterSystems IRIS
InterSystems

HI

We can easily do a <call> from graphic BPL's

I was wondering what is the best way we can call another Business Process or Operation via code.

Thanks in advance

I have a text file that I pick up in a Business Service and need to send it to our vendor via JSON.  I assumed (probably wrongly) that I could just create a RESTful Business Operation, plug in the server IP and URL as well as complete some of the other fields on the BO to send the file.  When I do this, I get the following error:

ERROR <Ens>ErrException: <PROPERTY DOES NOT EXIST>zOnMessage+5^EnsLib.HTTP.GenericOperation.1 *HTTPHeaders,Ens.StreamContainer -- logged as '-' number - @' Set tHeaderKey="" For { Set tHeaderKey=pRequest.HTTPHeaders.Next(tHeaderKey) Quit:""=tHeaderKey Set

Hello,

Is there an elegant way to define a dynamic "Archive path" for EnsLib.File.InboundAdapter ?

What i mean is to have a sub-folders structure (under the root archive path) with a name similar to: yyyymmdd
This way the adapter "could" store the files on those sub-folders (and create a new one for the 1st file for a specific date).

When a production is processing hundreds of thousands of files every day, we might end up with an archive with huge number of files (many millions) which is then hard to handle (read, search) especially on Windows O/S.

Of course that there is always a "programmatic"

Looking at the DTL, we can pretty much understand what the provided mapping from FHIR to SDA3.

But, is there any Intersystems document, where the mapping To/From FHIR is documented, at least FHIR to SDA3 ?

Hi Community,

We're pleased to invite you to the Europe's biggest data science gathering called Data Natives Conference 2019 on 25-26 November in Berlin, Germany! Join us and learn how InterSystems technology can support your AI & ML initiatives to help you shape our world! 🔥

What's more? 

Take part in @Benjamin De Boe's keynote "From data swamps to clean data lakes" in which he will portray best practices for sustainable AI/ML. And visit InterSystems booth on the 1st floor and discuss real-world use cases and state-of-the-art tools with our experts!

Hi, 

What is a Foundation Production and what does it do?

We are currently on HealthShare Health Connect  15.03 and we are starting the process of moving to HealthShare Health Connect 2019.1.

The 2019.1 Installation Guide is pretty clear that it is essential, but I'm having trouble working out exactly what it does?

Leading on from this is what should I call it?

From the installation guide: 

5. For Local Name, enter the name that will identify the Foundation production. This name will become the namespace that contains the class definitions for the production

So the name I give it will be the name

Hi,

I'm after feedback and comments on the sort of tools and approaches the wider InterSystems community uses for QA Testing applications written in Cache/Ensemble or IRIS.   I am aware of the %UnitTest package, and understand how that works... but:

- Do you use an alternative or framework built around this native Unit Testing tool ?

- What is your experience with %UnitTest if you use it ?

- Is there a tool you would recommend for your UI (I know this is not specifically an InterSystems' related question)

- What process do you use to routinely run tests on your application ? 

Any other

In our Iris Messages.log file, we have this line:

CTALERT: ZU Changes: $ZU(69,10) has changed; $ZU(69,68) has changed; $ZU(69,70) has changed

Hi everyone, 

I have just started to use JavaGateway and I didn''t encountered so much difficulties since I've got the output of the Java class I have called. 

This is the class I have implemented: 

Method OnRequest(pRequest As EnsLib.HL7.Message, Output pResponse As EnsLib.HL7.Message) As %Status{set MDMarchiv=pRequest.OutputToString()$$$TRACE(MDMarchiv)#dim RPConverter = ##class(training.hl7.HL7toRP).%New()set output=RPConverter.hl7toRp(MDMarchiv)$$$LOGINFO("after transformation: "_output)set RPStream = ##class(%FileCharacterStream).%New(output)#dim finalResponse As %FileCha