Preview releases are now available for the 2020.4 version of InterSystems IRIS, IRIS for Health and IRIS Studio. As this is a preview release, we are eager to learn from your experiences with this new release ahead of its General Availability next month.

hello, 

 I need help...rsrs

 I have a query that return only one CLOB field and only one line, of oracle and  in field have a xml.

 if use  pResultSet.Get the string truncate the xml.

 I want display the xml as a service, because have many lines... i don't need iterate in xml, only get to oracle and display as xml soap.
 
 any tip help. 

thk

We are seeing performance issues in purging objects/tables that have parent-child relationships defined. Due to the number of child objects we're seeing very long duration to purge a single parent and all child tables. Is there a better way to do this and get a more performant purge task? I was thinking to purge the child tables individually first and then delete the parent is one way. Is there any other approach?

David

Hi!

I need to know how long time a message has been in a possible queue before our business service starts handling the message. Is it possible to read with objectscript or another way?

The business service is an EnsLib.SOAP.Service

Grateful for answers

Greetings Michael

Hi,

is it possible to access a property defined as %List from sql? I´d like to search for a object containing a specific value in it´s %List defined property. Is there a predefined sql function for that within IRIS?

best regards,
Sebastian

Hi Community,

I'm developing an IRIS environment for a project and I would like to take some questions to pass on to the developers that I haven't found yet here in the community:

1. Is it possible to debug the process in VSCode in real time?

2. How can we use the terminal in VsCode for some configuration or just import applications (Example: Web Terminal)?

Background: We have our own SQL map that predates InterSystems'. A program writes an XML file for each table map class as $system.OBJ.Export would. $system.OBJ.LoadDir loads the XML files into .cls files.

The reason is a long story, but we need to update parameter EXTENTSIZE (only) in existing classes. This does not seem to happen. As a test I used $system.OBJ.Export to make an XML file and edited EXTENTSIZE in the two places it appears in the XML:

<StorageStrategy>SQLStorage</StorageStrategy>
<Parameter name="EXTENTSIZE"><Default>1001</Default></Parameter>

Background: We have our own SQL map that predates InterSystems'. A program writes an XML file for each table map class as $system.OBJ.Export would. $system.OBJ.LoadDir loads the XML files into .cls files.The reason is a long story, but we need to update parameter EXTENTSIZE (only) in existing classes. This does not seem to happen.

Hi Developers!

Recently we released the updated version 0.1.3 of ObjectScript Package Manager (ZPM) which comes with the support of simplified ObjectScript sources folder structure.

What 'simplified' does mean?

Before 0.1.3 ZPM expected the following structure:

/src

---/cls  - for ObjectScript classes

---/cls/package_name/class_name.cls

---/cls/package_name/class_name2.cls

---/mac - or Mac ObjectScript routines

---/mac/package_name/mac_routine.mac

---/mac/package_name/mac_routine2.mac

---/inc - for ObjectScript macro include files.

---/inc/package_name/include_file.inc

We are still looking for 5-6 people to review the design for the HealthShare Patient Index Technical Specialist Certification exam. for details, see the original announcement.

Regards --- Kate Schell

 Hi, I would like to ask how to develop the socket API with HealthShare, such as developing the socket external BS, and the socket-call BO. Thx!

Hi Community!

Let's warmly welcome @Nigel Salm as our new Moderator in the Developer Community Team!

Who is this guy? Let's get to know Nigel better!

Hi Community,

Please welcome the new video recorded by @Robert Cemper on InterSystems Developers YouTube:

⏯ IRIS easy ECP workbench

Hi Developers!

Many of you publish your InterSystems ObjectScript libraries on Open Exchange and Github.

But what do you do to ease the usage and collaboration to your project for developers?

In this article, I want to introduce the way how to introduce an easy way to launch and contribute to any ObjectScript project just by copying a standard set of files to your repository.

Let's go!

InterSystems states that Caché supports at least three data models – relational, object and hierarchical (globals). On can work with data presented in relational model in a program written on C# the same way one works with any other relational DB. To work with data presented by object model in C# one needs to use .NET Managed Provider or some kind or ORM. And starting with version 2012.2 one can work directly with globals (or use direct access to hierarchical data) via Caché eXTreme for .NET. 

The Command extension enables the execution of Multi-Line Commands from Terminal prompt.

Terminal Multi-Line Input with Edit, Insert, Delete, Print extension for IRIS and Caché
IRIS and Caché have just single command lines in terminal available
This Multi-Line Commands Editor also will execute the Multi-line Commands.
In addition, it is independent of access to %SYS and can be installed in any namespace

Special thanks to @Jeffrey Drumm  who inspired me to this and supported me as beta-tester.

This small tutorial described how to „register“ the ADO.NET Database Provider (Driver) for InterSystems IRIS and InterSystems Caché on a Windows machine.

Before we start: Why need the ADO.NET Database Provider to be registered?

This small tutorial described how to „register“ the ADO.NET Database Provider (Driver) for InterSystems IRIS and InterSystems Caché on a Windows machine.Before we start: Why need the ADO.NET Database Provider to be registered?ADO.NET provides factory classes standardize the way programmer will create a provider-specific Connection. This simplifies the way programmers create provider specific instances in a generic data access API.

Hi,

I'm doing a query in SQL and I need to sort my data by some non-repeated field.

Unfortunately, my data is grouped in a way that I cannot guarantee that any column will not have repeated data, so one solution would be to take the row number.

Also, the Cache is not accepting Row_Number () in my querry and I would like to know if there is another solution to return line numbers or some way to add this function to the Cache.

Best regards.

Three new sets of maintenance releases are now available: 

• Caché  2018.1.5, Ensemble 2018.1.5, and HSAP 2018.1.5
• InterSystems IRIS 2019.1.2, IRIS for Health 2019.1.2, and HealthShare Health Connect 2019.1.2
• InterSystems IRIS 2020.1.1, IRIS for Health 2020.1.1, and HealthShare Health Connect 2020.1.1

Installation kits and containers can be downloaded from the WRC Software Distribution site.

Installation kits and containers can be downloaded from the WRC Software Distribution site.These are maintenance releases with many updates across a wide variety of areas.

Dear Folks,

I have recently studied deepsee and developed few dashboards needed for our web app users. I am trying to embed them in our existing web app which uses angular with delegated user access. I need to embed the native IRIS dashboard into it. ( I can't use Highcharts or any other js tools). 

How do I setup the dashboards to work with delegated authentication (Without providing access to management portal or other parts) ? Also should I use the default csp/{Namespace}/_DeepSee.UserPortal.DashboardViewer.zen? or any other web application URL ?

Thanks

Hi Developers!

Here're the technology bonuses for the InterSystems Developer Tools Contest that will give you extra points in the voting.

Docker container usage - 2 points

The application gets a 'Docker container' bonus if it uses InterSystems IRIS  running in a docker container. Here is the simplest template to start from.

ZPM Package deployment - 2 points

You can collect the bonus if you build and publish the ZPM(ObjectScript Package Manager) package for your Full-Stack application so it could be deployed with:

zpm "install your-multi-model-solution"

command on IRIS with ZPM client installed. 

ZPM client. Documentation.

Unit Testing - 2 points

Applications that have Unit Testing for the InterSystems IRIS code will collect the bonus.

Learn more about ObjectScript Unit Testing in Documentation and on Developer Community.

Online Demo of your project - 3 points
Collect 3 more bonus points if you provision your project to the cloud as an online demo. You can use this template or any other deployment option. Example. Learn more on deployment in Monday's Kick-Off webinar.

Code quality analysis with zero bugs - 2 points

Include the code quality Github action for code static control and make it show 0 bugs for ObjectScript. Learn more in Monday's Kick-Off webinar.

Article on Developer Community - 2 points

Post an article on Developer Community that describes features of your project. Collect 2 points for each article. Translations to different languages work too.

Video on YouTube - 3 points

Make the Youtube video that demonstrates your product in action and collect 3 bonus points per each. Example.

The list of bonuses is subject to change. Stay tuned!

This article contains the materials, examples, exercises to learn the basic concepts of IAM.

You have all resources available on this git : https://github.com/grongierisc/iam-training.

Solutions are in training branch.

This article will cover the following points :

• 1. Introduction
  • 1.1. What is IAM ?
  • 1.2. What is an API Management ?
  • 1.3. IAM Portal
  • 1.4. Flow of this training
• 2. Installation
  • 2.1. What do you need to install?
  • 2.2. How IAM works with IRIS
  • 2.3. Setup
  • 2.4. Install IAM
    • 2.4.1. Iris Image
    • 2.4.2. IAM Image
    • 2.4.3. Update the docker file
    • 2.4.4. Update the docker-compose
    • 1.1.1. What is IAM ?1.2. What is an API Management ?1.3.1.4.2.2.1. What do you need to install?2.2.2.3.2.4.2.4.1.2.4.2.2.4.3.2.4.4.2.4.5.

Hi Developers!

As you may know, InterSystems Developer Community can help you to find a job. There are two options for developers: find a job for yourself or hire staff for your company. Just post an ad on the InterSystems Developer Community and find what you are looking for!

How does it work? Check the details below: 

Currently, I am working on a CSP application that is supposed to generate reports. Users will have varying access to said reports. To achieve that, I plan to use LDAP (because it's used in other systems where those users already exist).

What’s new from InterSystems Learning Services? Be the first to know – subscribe to the monthly Learning Newsletter! Read March’s newsletter and subscribe.

Hi Developers, 

Please welcome the new video on InterSystems Developers YouTube:

⏯ Building Health IT Apps with Artificial Intelligence

Hey Developers,

We're pleased to invite you to the upcoming webinar in English called "InterSystems IRIS & the industry 4.0 roadmap - Smart Factory Starter Pack"!

🗓 Date & time: March 31, 02:00 PM CEST

🗣 Speakers:

• @Marco den Hartog, CTO, ITvisors
• @Aldo Verlinde, Sales Engineer, InterSystems

Moving over from Studio To VSCode like many other will do now the ObjectScript plugin reached version 1.0, I noticed I was missing some items in the objectscript explorer. For example when creating a Rest API using the spec first approach, 3 classes are generated, an application.impl, application.disp and application.spec class, but the disp class was missing in the Object Explorer.

As the application.disp is a generated class, for showing these classes you need to turn this on by hitting the switch on the object explorer:

There's also a switch to enable/disable System Items.

A while back I asked the developer community for a way to loop through repeatable HL7 segments and check them against a Data Lookup table within a Business Rule.

The example I got was the following...

A while back I asked the developer community for a way to loop through repeatable HL7 segments and check them against a Data Lookup table within a Business Rule.The example I got was the following...ClassMethod GroupIDExists(pHL7Msg As EnsLib.HL7.Message, pSegment As %String, pField As %String, pLookupTable As %String) As %Boolean
{
            #dim tSeg as EnsLib.HL7.Segment
            set tSegCount = pHL7Msg.SegCountGet()
            set i = 1
            Set tFound = 0
            //get new values
            set tval=""
            while ((i <= tSegCount) && (tval="")) {

AWS launched their first generation of Amazon EC2 A1 instances last year, powered by Arm-based AWS Graviton processors. At AWS re:Invent 2019, Amazon announced the second-generation AWS Graviton2 processors and associated Amazon EC2 M6g instance type, boasting up to 40% better price performance over current generation Intel Xeon based M5 instances.

AWS launched their first generation of Amazon EC2 A1 instances last year, powered by Arm-based AWS Graviton processors. At AWS re:Invent 2019, Amazon announced the second-generation AWS Graviton2 processors and associated Amazon EC2 M6g instance type, boasting up to 40% better price performance over current generation Intel Xeon based M5 instances.The AWS Graviton2-based M6g instances are currently in preview, and InterSystems jumped on the opportunity to measure their performance with the InterSystems IRIS Data Platform.

Managed File Transfer (MFT) feature of InterSystems IRIS enables easy inclusion of a third-party file transfer service directly into an InterSystems IRIS production. Currently, DropBox, Box, and Kiteworks cloud disks are available.

In this article, I'd like to describe how to add more cloud storage platforms.

Here's what we're going to talk about:

• What is MFT
• Reference: Dropbox
  • Connection
  • Interoperability
  • Direct access
• Interfaces you need to implement
  • Connection
  • Logic
• Installation