How I can access identity column value in SqlComputeCode with property?
 

We have in DB two books, first is loaned because it has the Friend ID, and the other is in the shelf.

I execute a class query to get all loaned books:

    Query BooksLoaned() As %SQLQuery
    {
        SELECT *
        FROM Library.Book
        WHERE Friend IS NOT NULL
    }
 

Which I have tested throught the portal:

My task is to retrieve all the loaned books and return them in an array. Method code:

Hi all, New user here. I have an instance of Google Cloud Iris Health Community Edition running and am logged in on terminal. I follow the instructions for Google Cloud IRIS Health Community Edition. How do I get to iris? iris status yields nothing, there is no /bin/iris and sudo docker ps -a shows no containers but there probably is a iris container somewhere on the instance?  'Visit the site' yields ERR_CONNECTION_REFUSED 

Hi Developers,

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

I would like to Compact globals in a database to free up space.   

I would begin the process on Saturday morning, but am concerned, due to the size, that it would not complete by Sunday evening.  I understand that the process is setup so that it can run with users on the system, however, as the advice indicates, this would not be ideal.

Can the process be stopped if it does not complete by the time you want/need it to?

Do you know how to guestimate how long the process would take?

This is the Freespace for the database in question.  There are 1047 globals of which one of them takes up 50%.

The 2019.3 versions of InterSystems IRIS, InterSystems IRIS for Health, and InterSystems IRIS Studio are now Generally Available!

These releases are available from the WRC Software Distribution site, with build number 2019.3.0.311.0.

InterSystems IRIS Data Platform 2019.3 has many new capabilities including:

The 2019.1.1 version of HealthShare Health Connect 2019.1.1 is now Generally Available!

This release includes maintenance updates in a number of areas, as described in the online documentation here.

It also includes two new features, described in the online documentation here:

• Support for InterSystems API Manager
• X12 Element Validation in Interoperability Productions
• In-Place Conversion from Ensemble - based Health Connect (version 15.03) to Intersystems IRIS - based Health Connect

The 2019.1.1 versions of InterSystems IRIS and IRIS for Health are now Generally Available!

These are maintenance releases in the EM (Extended Maintenance) stream.  The changes are reflected in the 2019.1 documentation, which is available online and features a new look including a card-style TOC layout.

The build number for these releases is 2019.1.1.612.0.  A full set of kits and containers for both products are available from the WRC Software Distribution site, including community editions of InterSystems IRIS and IRIS for Health.

Caché  2018.1.3 and Ensemble 2018.1.3 maintenance releases are now available.   

Full product installation kits can be downloaded from the WRC Software Distribution site.

This is a maintenance release with many updates across a wide variety of areas.

For information about the corrections in this release, refer to the release notes.

This release also adds support for Red Hat Enterprise Linux 8, in addition to the previously supported platforms detailed in the 2018.1 Supported Platforms document.

 The build number for this release is 2018.1.3.414.0. 

Hello!  I have basic web services application that java clients connect to the cache web services.  Using the browser, the user enters in the following url.

http://localhost:57772/csp/foia/%25SOAP.WebServiceInvoke.cls?CLS=SOAPFoia.SOAPServiceFoiaWeb&OP=FoiaApp30
'

Hi there

I've noticed extreme slowness using the portal in my Healthconnect dev enviroment lately.

Any page in the Portal takes a lot of time Loading.

Any ideas of what it could be?

Kind Regards,

Joao

All of the sudden, Cache Studio's Debug->Run command started to fail with error '6704 Target has exited debugger' (German: Kein Anbinden möglich). What could be a reason of that? Today we installed Cache Web Terminal (https://intersystems-community.github.io/webterminal/
), could it be possible that the terminal somehow hijacked some debugging api end-point?

Update: any idea what error 6704 means exactly? Studio was able to launch debugging job but it unexpectedly exited? German text seems is trying to say "Can't connect"

Hi Developers!

Here is the release of what's was enhanced and fixed in the DC engine in October 2019.

• New look-and-feel and features for the Developers Events;
• "Smart" social sharing in Twitter;
• 5 min delay before sending emails, nested tags for group tags, better articles linkage, and other small enhancements and bug fixes.

See the details below.

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.

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"

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!)

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.

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: