ObjectScript | InterSystems Developer Community

Question

Having been inspired with Shared code execution speed question/discussion, I dare to ask another one which is annoying me and my colleagues for several weeks.

We have a routine called Lib that comprises 200 $$-functions of 1500 code lines total. It was noticed that after calling _any_ function of another rather big routine (1900 functions, 32000 lines) the next call of $$someFunction^Lib(x) is getting 10-20% slower than previous call of the same function. This effect doesn't depend on:

#ObjectScript #Performance #Caché #InterSystems IRIS

0 17

1 172

Article

Henry Ames · Jun 18 2m read

Options for Python Devs + Poll!

I am writing this post primarily to gather an informal consensus on how developers are using Python in conjunction with IRIS, so please respond to the poll at the end of this article! In the body of the article, I'll give some background on each choice provided, as well as the advantages for each, but feel free to skim over it and just respond to the poll.

#Embedded Python #ObjectScript #ODBC #Python #InterSystems IRIS

4 4

2 95

Question

Jean Millette · Jun 3

What's this odd behavior with "select count()" and a Unique Index?

Hello,

I have a class with a "Unique" index (pxfactidIndex) on a %Numeric property (pxfactid) (partially-edit code snippet below):

#Indexing #ObjectScript #SQL #InterSystems IRIS

0 8

0 107

Discussion

Evgeny Shvarov · Jun 21

CreatedAt and LastUpdated - do you use it?

Hi fellow developers!

Curious if you guys use CreatedAt and LastUpdated properties in your classes?

Created to stamp when the record was created and LastUpdated when it was last updated. Where it can be useful - almost everywhere )) I find it convenient in records sorting (e.g. by creation or last update), in sync (with other systems), and so on, for better analytics.

Do you use it all the time for all the classes?

If don't, why not? What do you use instead?

What property type do you use - %TimeStamp? %DateTime?

What is the best practice to have CreatedAt filled automatically during creation and LastUpdated on every successful save (guess it could be in %OnSave)?

Please share your experience /thoughts?

#Object Data Model #ObjectScript #InterSystems IRIS

0 14

0 98

Question

Colin Gadumer · Jun 5

Pass a string to a routine from powershell

Hi Community,

i'm trying to figure out how to pass a string to a routine from Powershell:

#ObjectScript #HealthShare #InterSystems IRIS #Health Connect

0 8

1 94

Article

Marco Bahamondes · Jun 24 3m read

Exposing a Basic REST API with InterSystems IRIS: Step-by-Step Docker Example

Introduction

InterSystems IRIS allows you to build REST APIs using ObjectScript classes and the %CSP.REST framework. This enables the development of modern services to expose data for web apps, mobile apps, or system integrations.

In this article, you'll learn how to create a basic REST API in InterSystems IRIS, including:

#API #Docker #Framework #GitHub #JSON #Management Portal #ObjectScript #REST API #SQL #InterSystems IRIS

3 3

1 41

Article

Harry Tong · Jun 6 2m read

Converting Oracle Hierarchical Queries to InterSystems IRIS: Generating Date Ranges

If you're migrating from Oracle to InterSystems IRIS—like many of my customers—you may run into Oracle-specific SQL patterns that need translation.

Take this example:

SELECT (TO_DATE('2023-05-12','YYYY-MM-DD') - LEVEL + 1) AS gap_date
FROM dual
CONNECT BY LEVEL <= (TO_DATE('2023-05-12','YYYY-MM-DD') - TO_DATE('2023-05-02','YYYY-MM-DD') + 1);

In Oracle:

#Databases #JDBC #Management Portal #ObjectScript #ODBC #Python #SQL #Caché #InterSystems IRIS

2 1

0 61

Question

Evgeny Shvarov · Jun 29

JSON fields and Class properties - are they case sensitive?

Hi noble devs!

Just building a simple frontend->JSON->IRIS backend story, and figured that IRIS while importing via %JSON.Adaptor wants JSON fields to match property names, meaning even should match the case. Like: