InterSystems IRIS

Syndicate content 49 

ObjectScript doesn't include any built-in method for appending one JSON dynamic array to another. Here's a code snippet I use that's equivalent to the JavaScript concat() method.

Call it with any number of arguments to concatenate them into a new array. If an argument is a dynamic array, its elements will be added. Otherwise the argument itself will be added.

Last reply 4 May 2020
+ 1   0 2
139

views

+ 1

rating

Hi, everyone!


I want to share a personal project that started with a simple request at work: 

Is it's possible to know how many Caché licenses we are using? 

Reading other articles here in the community, I found this excellent article by  David Loveluck 

Last reply 3 May 2020
+ 10   7 7
1,332

views

+ 10

rating

Hi Developers!

This is the digest of new solutions and applications submitted to InterSystems OpenExchange in April 2020!

19 New applications in April 2020

FHIR Server and API Manager for MIT COVID-19 Challenge by Steven LeBlanc

This demo shows how InterSystems API Manager (IAM) can be used to view and test FHIR resources with InterSystems IRIS for Health. It comes pre-configured with a FHIR server, pre-populated with synthetic patient data. The new InterSystems API Manager (IAM) includes OpenAPI Swagger specs to quickly generate REST client code to work with many common FHIR resources.

Production Manager by Nikolay Soloviev

REST API to manage IRIS Interoperability Productions.

rest-api-contest-template by Evgeny Shvarov

Template repository for InterSystems IIRS REST API Programming Contest

JSON-Filter by Lorenzo Scalese

ObjectScript server-side JSON filter.

objectscript-openapi-definition by Guillaume Rongier

The objectif of this library is to generate the ObjectScript Class from an OpenApi definition.

FHIR-HL7v2-SQL-Demo by Guillaume Rongier

Ready to use a demo of an FHIR Server and HL7v2 transformation to the FHIR Server on IRIS For Health Intersystems The FHIR repo can be a query in SQL.

CloudWatch-IRIS by Anton Umnikov

Configuring AWS CloudWatch with InterSystems IRIS

+ 2   0 1
0

replies

40

views

+ 2

rating

Hi Community!

The registration phase for the second InterSystems Online Programming Contest has already ended, and now the voting week begins! 

We have 7 applications - so you have a set of applications to choose from!

How to vote?

This is easy: you will have one vote, and your vote goes either in Experts Nomination or in Community Nomination.

+ 4   0 2
192

views

+ 4

rating

The %Net.SSH.Session class lets you connect to servers using SSH. It's most commonly used with SFTP, especially in the FTP inbound and outbound adaptors.

In this article, I'm going to give a quick example of how to connect to an SSH server using the class, describe your options for authenticating, and how to debug when things go wrong.

Here's an example of making the connection:

Last reply 1 May 2020
+ 9   0 4
1,339

views

+ 9

rating

Okay, we've got a quite useful way to very easily Import and export our objects as JSON, similar to what we already had before for XML.

So, It's a %JSON.Adaptor. But the issue here I faced with, working with Stream properties. 

I have an example, when I generate an object, with stream binary stream properties. Export and Import the same, but getting the different resulting objects, depends on the original size of streams.

Last reply 30 April 2020
0   1 1
145

views

0

rating

During runtime I build an object which is essentially a wrapper over in-memory table:

col1 ... colN
val11 ... valN1
val12 ... valN2

 

I want to use this object as a part of INSERT or UPDATE queries, based on a value of some column (the main use case one of the columns is an ID value)

What's the best way to expose the object to SQL?

Last reply 30 April 2020
0   0 3
195

views

0

rating

Hi Community,

We're pleased to invite you to join the upcoming InterSystems IRIS 2020.1 Tech Talk: API-First Development on May 5 at 10:00 AM EDT!

In this week's InterSystems IRIS 2020.1 Tech Talk, we'll discuss API-first development and how InterSystems is embracing this industry trend with our API Manager, and specifically with our FHIR offerings. First, we'll talk about InterSystems API Manager. This tool controls your web-based API traffic in a single location. You can throttle throughput, configure payload sizes and whitelist/blacklist IPs, among many other features.

FHIR stands for Fast Healthcare Interoperability Resources. Release 4 brings this HL7 standard to maturity, and the FHIR R4 support in InterSystems IRIS for HealthTM is big. You'll learn how to work with FHIR data in InterSystems IRIS, and see our developer portal in action, where you can access FHIR resources using the OpenAPI specification.

   

0   0 1
0

replies

179

views

0

rating

If you define a Persistent Class / Table the class compiler generates for you an appropriate Storage definition.
A different option is to define a SQL mapping for an already existing Global storage.  This has been excellently
explained already in a different series of articles.   The Art of Mapping Globals to Classes 1 of 3

Last reply 28 April 2020
+ 9   1 2
159

views

+ 9

rating

i've noticed a strange bug in the 'problem highlighting' of VSCODE and i wasn't sure if this is a problem with the internal library definitions of iris, or with the plug-in itself.

 

The first line is the correct macro call, but the second one is the one throwing the error. (preprocess vs prepOrocess)

How is this syntax checker's list of strings compiled?

Last reply 27 April 2020
0   0 2
100

views

0

rating

As you know in Caché / IRIS you have the possibility to define a property as Multidimensional as documented here:
https://docs.intersystems.com/iris20201/csp/docbook/DocBook.UI.Page.cls?KEY=GOBJ_proplit#GOBJ_proplit_multidim
and the explanation of how to use it
https://docs.intersystems.com/iris20201/csp/docbook/Doc.View.cls?KEY=GOBJ_proplit#GOBJ_proplit_multidim_values

Though the access is quite comfortable (in traditional COS sense) there are 2 main restrictions that hurt:

#1) It is not saved to disk unless your application includes code to save it specifically.
#2) It cannot be stored in or exposed through SQL tables
   there are some more
I'll show how to overcome these limits

+ 11   1 0
0

replies

111

views

+ 11

rating

Hi Developers!

Want to participate again in the competition of creating open-source solutions using InterSystems IRIS Data Platform? 

Then we're pleased to announce the second InterSystems IRIS Online Programming Contest!

And the topic for this contest is InterSystems IRIS with REST API.

The contest will again last three weeks: April 13-May 3, 2020

Also, please join the InterSystems Contests Discord Channel to chat about contest and technology.

 

Last reply 27 April 2020
+ 4   2 2
1,228

views

+ 4

rating

The typical WHERE condition in SQL relates mostly to some content of the rows you work on.
So it needs to be calculated and checked for each row you access.
Differently (and that's why I named it STATIC) is a WHERE condition that is independent of the rows you access.

Last reply 27 April 2020
+ 13   1 3
176

views

+ 13

rating

A VIEW in SQL is basically a prepared SQL statement.
It has to be executed and assembled like any other SQL query.
MATERIALIZED VIEW means that the content is collected before hands and can be retrieved rather fast.
I saw the concept first with my favorite competitor named O* and they made a lot of noise about it.

  { favorite: because I could win every benchmark against them devil }

+ 10   0 1
0

replies

122

views

+ 10

rating

I enjoy the challenge of being in a contest. Currently I participate in InterSystems IRIS with REST API Programming Contest. My idea for this contest was to create an app to help me keep track of tasks for my Status Reports. I started with the template provided by Evgeny Shvarov. I created a persistent class for Tasks and a REST Dispatch class. I defined my URL map and I even figured out how to test my REST app using Postman.

Last reply 25 April 2020
+ 1   0 1
60

views

+ 1

rating

When I describe InterSystems IRIS to more technically-minded people, I always start with how it is a multimodel DBMS at its core.

In my opinion that is its main advantage (on the DBMS side). And the data is stored only once. You just choose the access API you want to use.

Last reply 24 April 2020
+ 6   3 2
378

views

+ 6

rating

Hi Developers!

Today we launched the second programming contest on InterSystems IRIS, the landing.

The topic is the REST API.

And we introduced a few technology bonuses.

Here I want to provide details on what application eligible, what are the technology bonuses and how to collect all of them.

Here we go!

Last reply 24 April 2020
0   0 2
253

views

0

rating

Simple problem:

  1. I leave a long-running command in terminal
  2. Switch to another task(s)
  3. Remember that I need to check on my command after a few hours

Is there any way to force terminal to the foreground after current command ends?

This is Windows with cterm/iristerm although Putty/Kitty solution would also be nice.

Last reply 23 April 2020
0   0 4
167

views

0

rating