Announcements

"But of course you don't understand! How can a person who has always traveled in a horse-drawn carriage understand the feelings and impressions of the express traveler or the pilot in the air?"

Kazimir Malevich (1916)

Introduction

We’ve already addressed the topic of why object/type representation is superior to SQL for implementing subject area models. And those conclusions and facts are as true now as they have ever been. So why should we take a step back and discuss technologies that drag abstractions back to the global level, where they had been in the pre-object and pre-type era? Why should we encourage the use of spaghetti code, which results in bugs that are hard to track down, and which relies only on virtuoso developer skills?

There are several arguments in favor of transmitting data via SQL/REST/GraphQL-based APIs as opposed to representing them as types/objects:

#API #Beginner #Data Model #Object Data Model #InterSystems IRIS

9 2

4 1.2K

Question

Eduard Lebedyuk · Jan 27, 2022

Storing dynamic object properties larger than 3641144 symbols

I have defined a class with a dynamic object property:

My class

Class test.Dyn Extends %Persistent
{

Property json As %DynamicObject;

/// do ##class(test.Dyn).test()
ClassMethod test()
{
  do ..%KillExtent()
  for len = 100, $$$MaxStringLength - 1, $$$MaxStringLength, $$$MaxStringLength+1, $$$MaxStringLength *2 {
    set sc = ..save(len)
    write "Len: ",len, " Result: ",$case($$$ISERR(sc), $$$YES: $System.Status.GetErrorText(sc), : "OK"),!
  }
}

ClassMethod save(len)
{
  set json = {}
  set stream = ..getStream(len-8) // -8 because {"a":""}
  do json.%Set("a", stream, "stream")
 
  set obj = ..%New()
  set obj.json = json
  quit obj.%Save()
}

ClassMethod getStream(len)
{
  set stream = ##class(%Stream.TmpCharacter).%New()
 
  if len<$$$MaxStringLength {
    do stream.Write($tr($j("",len)," ","A"))
  } else {
    for i=1:$$$MaxStringLength:len {
      do stream.Write($tr($j("",$$$MaxStringLength)," ","A"))
    }
    do stream.Write($tr($j("",len-i)," ","A"))
  }
  quit stream
}
}

The issue I encounter is that if a length of a serialized json property is more than 3641144 symbols, the object fails to save with the following error (either MAXSTRING or STRINGSTACK):

Length: 100 Result: OK
Length: 3641143 Result: OK
Length: 3641144 Result: OK
Length: 3641145 Result: ERROR #5002: ObjectScript error: <MAXSTRING>%GetSerial+1^%Library.DynamicAbstractObject.1
Length: 7282288 Result: ERROR #5002: ObjectScript error: <STRINGSTACK>%GetSerial+1^%Library.DynamicAbstractObject.1

Is there a workaround? I need to store moderately large jsons (10-15 Mb) and dynamic object properties allow for a very convenient access.

$ZSTORAGE is set to -1.

#JSON #InterSystems IRIS

5 8

0 1.2K

Question

Jude Mukkadayil · Dec 11, 2019

How to get row count of csv using ObjectScript

Hi,

I have written a procedure with the help of object scripting to export data to a csv file. There is more data than the csv limit.

Can anyone please tell me how to get the row count of csv file using object scripting, so that I can write an if condition and write to a second csv file.

Please find the code writing to the csv given below.

#CSV #ObjectScript #Caché

0 14

0 1.2K

Question

Alexey Maslov · Oct 17, 2017

Yet Another Way to Duplicate Quotes in String

This small function is of great need sometimes. My solution is straightforward:

#Tips & Tricks #Caché

2 6

0 1.2K

Question

David Wright · Aug 29, 2016

Regular Expression to Strip HTML Tags

I want to use the Regex Matcher to strip HTML tags, but I get a REGEX error. Can anyone explain what I'm doing wrong?

#ObjectScript #Caché

0 1

0 1.2K

InterSystems Official

Aya Heshmat · Mar 27, 2025 4m read

2025.1 Modernizing Interoperability User Experience

The Interoperability user interface now includes modernized user experiences for the DTL Editor and Production Configuration applications that are available for opt-in in all interoperability products. You can switch between the modernized and standard views. All other Interoperability screens remain in the Standard user interface. Please note that changes are limited to these two applications and we identify below the functionality that is currently available.

#DTL #Embedded Python #Interoperability #Source Control #Caché #Ensemble #InterSystems IRIS #InterSystems IRIS for Health #Health Connect #InterSystems Official

21 23

4 782

Article

Renato Banzai · Jun 3, 2020 4m read

Creating a Chatbot with IRIS and Python

In this article I'm going to show how to integrate the InterSystems IRIS Database with Python to serve a Machine
Learning Model of Natural Language Processing (NLP).

#Artificial Intelligence (AI) #Framework #Machine Learning (ML) #Python #InterSystems IRIS

Open Exchange app

4 0

1 1.2K

Question

Andrew Makinson · Sep 3, 2018

HTTP POST - unsupported media type - JSON

In a EnsLib.REST.Operation I have...

Set tSC=..Adapter.Post(.tHttpResponse,,pRequest.stream)

This sends JSON string over HTTP

I am getting this error back from the server

#Ensemble #Business Operation #JSON #REST API

0 1

0 1.2K

Question

Jimmy Christian · Sep 18, 2023

Loop through an array or collection in DTL

Hello community,

I want to iterate through a defined collection/list of numbers for example 1,3,4,5 in my DTL.

Something like

#DTL #Key Question #ObjectScript #InterSystems IRIS

0 11

0 1.2K

InterSystems Official

Andreas Dieckow · Dec 7, 2016

Platform Compatibility: HP Open VMS

Post has been edited for clarification: Both HP Open VMS versions (for Itanium and for Alpha) are discontinued for future InterSystems releases.

Future product releases, beginning with the next major release after 2017.1, will no longer be offered for the following platforms:

HP OpenVMS for Itanium

HP OpenVMS for Alpha

Products: Caché, Ensemble

Expected Availability: next major release after 2017.1

#Compatibility #OpenVMS #Platforms #Caché #Ensemble #InterSystems Official

3 1

0 1.2K

Question

Mario Villace · Dec 23, 2015

We need to develop a Linux bash script to import/export Ensemble's namespaces.

Hi!

We need to use a bash script under Linux in order to export a namespace's clases (*.cls), project (*.prj), *.inc and all related stuff (except generated and mapped clases). All these elements must be stored on a XML file.

We need to use a bash script under Linux to import and compile previously exported XML file (from Studio, Management Portal, or Export Script) .

Can anyone help us to develop them?
Thanks in advance!

#Compiler #Ensemble

0 5

0 1.2K

Discussion

Eduard Lebedyuk · Mar 6, 2020

Temporary Tables in InterSystems IRIS

Temporary tables are tables available for a current process only (and destroyed when process ends).

What are you approaches to creating temporary tables?

#SQL #InterSystems IRIS

1 5

0 1.2K

Question

Sabarinathan M · Nov 3, 2016

cmd command not working on terminal

I try to run the cmd command in the studio terminal, but i am getting the <NOTOPEN> Error.

Even ZF(-1) also not working. Any help, Please!!!

Note: i restart the Cache instance service with full privilege

Code:

Set Path="mkdir E:\Sample\New"

Open Path:"QR":10

Error:<NOTOPEN>

This command working on my PC, but on server throws error.

Many Thanks

#Caché #ObjectScript

0 3

0 1.2K

Question

Arcady Goldmint... · Aug 14, 2018

Using %DynamicObject and %DynamicArray as general purpose data structures

Traditional Caché Objectscript has the multi-dimensional array as its main form of complex data structure and the $order command as the main means of traversing said data structures. But newer versions of Caché ObjectScript also have data structures that are direct parallels of what languages such as JavaScript provide, in the form of %DynamicObject and %DynamicArray. These have an easy to use iterator feature via the %GetIterator method, and even a handy built-in literal syntax for constructing new objects.

#Object Data Model #ObjectScript #Caché

0 4

0 1.2K

Question

Kurro Lopez · Apr 23, 2021

Sort alphabetically a list of names

Hello everyone,

I don't want to believe that Intersystems didn't add a method/process/rule to sort alphabetically a list of names (in array, $ LB or whatever)

I haven't found any documentation about this. I've even tried comparing two strings but have not found a solution.

My cry for help is...

Does exists any command to compare two strings and check if one of them is lower or upper according to aphabet?

Please, give me a light in this dark

Best regards.
Kurro Lopez

#Caché

1 7

0 1.2K

Article

Stephen De Gabrielle · Jul 5, 2017 2m read

file name passthrough and extending a class to override a method

I needed to pass through a file with Ensemble but the operation wasn't writing some filenames as given because the EnsLib.File.PassthroughOperation 'sanitizes' filenames removing characters that are not valid on some operating
systems;
09000655_AEDC_C3344059_A/E_Martin Browne_09000655_201706221018.pdf
09000655_AEDC_C3344059_A#47E_Martin_Browne_09000655_201706221018.pdf

#ObjectScript #Ensemble #HealthShare

1 0

0 1.2K

Article

Evgeny Shvarov · Nov 12, 2019 3m read

ObjectScript Package Manager Naming Convention

Hi Developers!

Suppose you want to create your ObjectScript library to be distributed via ObjectScript Package Manager. And there is an obvious question: what is the naming convention on the packages and class names?

Naming packages and classnames

#Docker #InterSystems Package Manager (IPM) #InterSystems IRIS #Open Exchange

Open Exchange app

4 6

2 1.1K

Question

Arpitha Ramakri... · May 10, 2017

code to import class files

Hi ,

From the below code, we are able to import the class file to the namespace ( specified path is C:\temp\distr )

I have a class file and a folder in the above specified path. When i run the code, it is importing only the class file but not the class files present in folder.

I would like to know is there any code to import the class files present in folder as well.

#Caché

0 3

0 1.2K

Question

Mike Dawson · Aug 4, 2016

Generic way to test if all the propertiers of an object are null

I need a generic way to check if all the properties on an object instance are null. Has anyone got some code they could share?

I could of course add a method to each class and pass in all the properties and test them but I'm sure there must be a generic way to do this. A generator method perhaps?

Regards

Mike

#Object Data Model #Caché

1 3

0 1.2K

Article

Kurro Lopez · Mar 3, 2024 5m read

How to send messages to Microsoft Teams

Hi community,

The aim of this article is to explain how to create messaging between IRIS and Microsoft Teams.

In my company, we wanted to monitor error messages, and we used the Ens.Alert class to redirect those error messages through a Business Operation that sent an email.
The problem was that we sent those error messages to a support account where there were many emails. We wanted something specific for a specific team.

So we investigated how to make these messages reach the development team directly and they could have, in real time, a notification of an error in our production.
In our company we use Microsoft Teams as a corporate tool, so we asked ourselves: How could we make these messages reach the IRIS development team?

#Best Practices #Business Operation #Monitoring #Tutorial #InterSystems IRIS

Open Exchange app

33 15

8 935

Article

Steve Pisani · Nov 23, 2021 4m read

Mutual TLS setup

Hi,

I recently needed to setup an SSL/TLS configuration in IRIS that supported mutual authentication (where the server IRIS is establish a connection to is verified, and, where IRIS is in turn verified by the remote host). After a bit of research and getting it done, I thought it worthwhile to just go over the process I went through in order to potential help others, and save you some time .

#Security #SSL #InterSystems IRIS

4 1

2 1.2K

Question

Rodrigo Souza · Mar 26, 2019

Task Manager Stopped

So i'm having this problem with the task manager, the tasks simply stopped running. I had a problem with queued massages and trying to figure out what to do i'm afraid I may messed up something else, can someone help me ?

#Development Environment #Management Portal #System Administration #Caché #Ensemble #HealthShare #InterSystems IRIS

0 3

0 1.2K

Question

Gery Gerena · Feb 4, 2017

Angular 1 or Angular 2 for new web project using Caché/Ensemble ?

If you had to choose Angular 1 or 2 for a new web project using Caché/Ensemble as a backend, Which one would you choose?
I'm trying to figure this out with a short pros/cons list:

#Angular #Frontend #Caché

2 14

0 1.2K

Article

Luis Angel Pére... · Jun 16, 2023 10m read

Creating a REST service in IRIS

One of the most common needs of our clients is the creation of REST services that allow access to the information present in IRIS / HealthConnect. The advantage of these REST services is that it allows the development of custom user interfaces with the most current technologies taking advantage of the reliability and performance of IRIS in the back-end.

#REST API #Health Connect #HealthShare #InterSystems IRIS

Open Exchange app

4 0

5 1.2K

Article

Dmitry Maslennikov · Aug 20, 2021 6m read

GitHub Codespaces with IRIS

Some time ago GitHub, has announced the new feature, GitHub Codespaces. It gives an ability to run VSCode in the browser, with almost the same power as it would run locally on your machine, but also with a power of clouds, so, you are able to choose the machine type with up to 32 CPU cores and 64 GB of RAM.

Looks impressive, is not it? But how it could help us, to work with projects driven by InterSystems IRIS? Let's have a look, how to configure it for us.

#Best Practices #Development Environment #InterSystems IRIS #VSCode

17 3

7 1.2K

A concurrent session in IRIS:SQL, Objects, REST, and GraphQL

Introduction

Creating a Chatbot with IRIS and Python

A concurrent session in IRIS:
SQL, Objects, REST, and GraphQL