#InterSystems IRIS

Hi everyone - In IRIS we would like to arrange the access of two users in such a way that each has access to exactly one (his) database only. Which resource does this (%DB_%DEFAULT allows each of the two users access to both databases). If you create new resources (%DB_Database1 and %DB_Database2) and then add them to individual roles (each for the user to), the access for the users, for example, via a REST client does not give the desired separation (instead once Ok, other database 401 Unauthorized both OK). Is there something special to consider or a special resource that could do this or .

Hello everyone

I am new to cache. In an interview i was asked how to optimize a sql query.

I just said I will create index on conditions which are present in where clause. But as per interviewer I should check How query plan is getting executed. This will help in optimizing Sql queries. 

I want to know what will be the answer for how to optimize SQL query in cache. 

Thanks in advance!!

Hello Everyone

I am new to cache. I know there are 2 types of methods in cache. One is Instance method (Which can be call through object creation of particular class) and other is Class methods (which can be call through ##Class(MyPackage.Car).CarModels()). 

I want to know the difference when to create a instance method vs when to create a class methods.

Thanks in advance!!.

How Can I Do It (rebuild index) using ObjectScript?

I wanted to write it as a comment to article of @Evgeny Shvarov . But it happens to be so long, so, decided to post it separately.

I would like to add a bit of clarification about how docker uses disk space and how to clean it.  I use macOS, so, everything below, is mostly for macOS, but docker commands suit any platform.

Hey Developers,

Welcome to the next InterSystems online programming competition: 

🏆 InterSystems IRIS Analytics Contest 🏆

Duration: August 23 - September 12, 2021

Total prize: $8,750

Landing page: https://contest.intersystems.com

I see this available as an option on Docker Hub:

What ARM platform(s) is it designed for?  When I saw it available, I rather hoped it might work on a Raspberry Pi but it failed to start!  

docker pull store/intersystems/iris-community-arm64:2020.4.0.524.0

A quine is a computer program which takes no input and produces a copy of its own source code as its only output.

Wikipedia.

How about a fun challenge?

The task is to write a quine in InterSystems ObjectScript. It can be a class, or a method, or a routine, or just a line to be executed in a terminal. You decide!

Here's some resources you might consider useful:

• $TEXT
• XECUTE
• $XECUTE
• %Compiler.UDL.TextServices:GetTextAsString
• %Dictionary package
• Indirection

Hard mode: do not use source code access functions.

Here's my (extremely uninspired, I know) attempt:

Class User.Quine
{

/// do ##class(User.Quine).Test()
ClassMethod Test()
{
    set sc = ##class(%Compiler.UDL.TextServices).GetTextAsString($namespace, $classname(), .str)
    write str
}

}

It produces this output:

How many different ways of producing a quine are there in ObjectScript?

Hi everyone, 

Learn about iris-lockeddown, a version of the InterSystems IRIS data platform container designed to work with the most stringent container security policies:

⏯ Using Containers in Highly Secure Environments with IRIS Lockdown

New to IRIS. Installed docker container as per instructions. From my system I run:

# docker exec -it iris bash

and then try to start a terminal session, which fails

irisowner@2f54ebfbc52f:~$ irissession IRIS

How do I successfully start a terminal session?

I'm using Deferred Response.

After I have obtained a token, is it possible to retrieve initial request somehow?

This article explains how to use the InterSystems IRIS platform to write a basic IMAP client. First, we present an overview of IMAP, then we discuss the main IMAP commands and client implementation. Finally, we offer a simple use of this IMAP client on the IRIS interoperability application.

Note that this article isn’t a detailed IMAP explanation. For more detailed information, please check the references of this article.

IMAP Overview

The Internet Message Access Protocol (IMAP) lets users retrieve emails.

In Java we can use reflection to get the method arguments in an array, we can also get the name of argument. 

Do we have similar features in ObjectScript? 

Thanks! 

All French-speaking developers are friendly invited to follow a stream in the form of a journal.

Every first Thursday of the month at 12:00 (Paris time), we organize a 30-45 minutes stream on Youtube with the following format :

• News on technologies around InterSystems.
• A section called "Did you know it?" (tips and tricks on IRIS)
• A "dossier", where we develop a subject (example: How language gateway works).
• And we end the program with an Interview of an french developer

Previous episodes  :

• Stream #0 : https://www.youtube.com/watch?v=ah0G7mNqa4E
  • News
    • 2020.4 in GA
      • https://docs.

Hey Developers, 

Learn how to use InterSystems IRIS data platform to meet change data capture (CDC) challenges created by data silos:

⏯ Stay in Sync with Change Data Capture

We invite you to the webinar "InterSystems Reports",  on Tuesday, September 7th, at 10:00 (Moscow time). The language of the webinar is Russian.

InterSystems Reports, a part of InterSystems IRIS and InterSystems IRIS for Health, is a robust, modern report generation and publishing solution that includes:

• Report Designer - a tool for report developers to create and preview reports.
• Report Server, which gives users access to run, schedule, filter, and modify reports.

Hey Developers,

Learn about InterSystems Reports, powered by Logi Analytics, a report-generation tool that enables you to rapidly create and view visual reports of your data.

⏯ A Look at InterSystems Reports

After setting AllowedIPAddresses with a valid IP address 

i get the following errors.

ERROR <Ens>ErrException: <READ>zOnTask+44 ^EnsLib.TCP.InboundAdapter.1 -- logged as '-'
number - @''

what am i doing wrong?

and question:

where in the message viewer can i see the source IP of the message?

Thanks

In my Business Operation I need to execute a bookkeeping method every X seconds.

How can I do that?

There are two workarounds (I dislike both):

1. Execute bookkeeping on process start - but there might be no requests at all
2. Create a BS that sends messages to BO every X seconds - it makes production more complex and also queues might not guarantee that the method is executed on schedule.

Thoughts?

Hi Developers!

Here're the technology bonuses for the InterSystems Analytics contest that will give you extra points in the voting.

Adaptive Analytics (AtScale) Cubes usage - 4 points
InterSystems Adaptive Analytics provides the option to create and use AtScale cubes for analytics solutions.

You can use the AtScale server we set up for the contest (URL and credentials can be collected in the Discord Channel) to use cubes or create a new one and connect to your IRIS server via JDBC.

The visualization layer for your Analytics solution with AtScale can be crafted with Tableau, PowerBI, Excel, or Logi.

Documentation, AtScale documentation

Training

Hi,

How to import production from online lab to local windows 10 instance?

Thanks

Hi,

I wonder if anyone could help me.

I'm used to writing Microsoft SQL database queries, but at the moment I am also trying to write reports on an IRIS database (used to be cache) in Microsoft BIDS.

My chief headache is parameters. They don't behave the "normal way" in BIDS, in that you can't rename them. Therefore, referencing them in the main code is a nightmare for me.

Say my report has two parameters. If i want to refer to both in a dataset, I have to list them in the order they are in the report and both by using a question mark, ie:

WHERE
column1 = ?

and column 2 = ?

Hi Community,

We are pleased to invite all the developers to the upcoming InterSystems Analytics Contest Kick-off Webinar! The topic of this webinar is dedicated to the Analytics contest.

On this webinar, we’ll demo AtScale, InterSystems Reports (Logi), IRIS BI, IRIS NLP and answer the questions on how to develop, build, and deploy Analytics applications using InterSystems IRIS.

Date & Time: Monday, August 23 — 10:00 AM EDT

Speakers:  
🗣 @Carmen Logue, InterSystems Product Manager - Analytics and AI
🗣 @Evgeny Shvarov, InterSystems Developer Ecosystem Manager

Team,

I am trying to use Visual studio code(1.57) for class development and for compiling classes (intersystems tools extension) . It works.

Now, i would like to use TFVC (Team Foundation Version Control) for source control.  

I can see download option where i can manually download the Namespace as folder and classes as files.

Since whenever i save the file, it directly pushes the change to remote system. I am not sure where the local workspace is.

How to configure VS Code to track my changes and Check In / Check out the code.

Data transformations can be changed in Management portal, but the modifications are not synced with visual studio code. Classes are synced from VSCode to Iris. VSCode can take care of the git repository.

I am curious to know how people are developing data transformations on Iris with VSCode? Are you editing the DT classes with VSCode and forget about the UI? Are you exporting from management portal the files to VSCode directory? Are you using a source control hook?

Thank you

Hi Community,

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ Visual Studio Code for ObjectScript: Server-Side Source Control

Hey Developers,

New video is already on InterSystems Developers YouTube:

⏯ Visual Studio Code for ObjectScript: Choosing an IDE/Source Code Combination

I want to try SAM in AWS. I followed these steps:

docker pull store/intersystems/sam:1.0.0.115

git clone intersystems-community/sam: System Alerting and Monitoring (SAM) (github.com)

git clone https://github.com/intersystems-community/sam

tar zpxvf sam-<version>.tar.gz

tar zpxvf sam-1.0.0.115-unix.tar.gz

$ cd sam-<version>

cd /home/ec2-user/git/sam/sam-1.0.0.115-unix/

$ ./start.sh

In your browser, visit:
http://<ip-address-of-host-where-SAM-runs>:8080/api/sam/app/index.csp
You'll be prompted to login. You can use standard InterSystems IRIS credentials like _SYSTEM/SYS.

So I've got the IRIS AMI spun up in AWS EC2; it seems to be running fine.  
I've added an EBS volume to it for persistent storage, and now I'm pondering how to make it actually do something useful.  

What's the best way to do deploy code to this instance?  I can think of a few ways to do it, but what's the least painful way?  Push my code to an S3 bucket and figure out how to load it at system start?  Github project?  

I have described my efforts to optimize IRIS Mirror deployment in AWS ElasticContainer Service (ECS) in my prior article.

IRIS Mirror in the cloud (AWS) | InterSystems Developer Community | AWS
 

I have come to the opinion that IRIS Mirror is not as reliable as needed when deployed in ECS. The root of the problem is the fact that ECS randomly assigns one of the available IP addresses to each EC2 host or Fargate task it starts.

These get stored in iris.cpf file in MapMirrors section as shown here:

[MapMirrors.IRISMIRROR]

FAILOVER1=10.2ab.1cd.146,2188,,10.2ab.1cd.