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

How Can I resolve this?

ERROR #5001: Failure to determine first and last IDs in source table 'dc_irisbi.KeyResult'. Check indices on the source.

I trying to use this class in a deepsee cube, when I build, I get this error

Hello!

I call a Java-based web service from HC and get an error message back:

"ERROR # 6243: HTTP request to SOAP WebService returned response with unexpected CONTENT-TYPE: text / html; charset = utf-8."

The content (payload) that is sent from my HC-client is coded in iso-8859-1 but SOAP debug shows that Soap envelope  to be sent with:

"Output from Web client with SOAP action = urn: submitFile
<? xml version = "1.0" encoding = "UTF-8"?> etc "

and I guess that's what is causing the error message?

How can I change from "UTF-8 to ISO-8859-1 in the soapcall??

Grateful for answers!

Regards Michael

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

Hi,

Under the social tab of my profile I found "InterSystems SSO" account along with my other social accounts.

What is InterSystems SSO account and to utilize it?

Thanks

Hey Community,

Here is a digest of the Developer Community videos on InterSystems Developers YouTube Channel in August 2021:

Hello, 

The database is increasing a lot (almost a 1TB) and getting bigger with no sense after migration, the use of the plataform did not increase after the migration so is strange for us this increase.

how can I check everything is ok in the database? for example any table getting bigger.

Before the migration the logs were like:

07/22/21-17:18:26:304 (19701) 0 Starting Expansion for database /opt/Intersystems/HS/HS_201521705/mgr/cachetemp/. 276 MB requested.

07/22/21-17:18:26:373 (19701) 0 Expansion completed for database /opt/Intersystems/HS/HS_201521705/mgr/cachetemp/. Expanded by 276 MB.

but

Could you help me please. I am a VistA Application Administrator for the State of Tennessee and I have been using your web site: https://www.bmirwin.com/vnode/dictionary/index.php to write reports for the Health Departments in my state and I see it was shut down on 9/1/21. It was such a great site and I found it very easy to use. Is there a replacement site where I can get that information. It was so well formatted.

Thank you,

J.R. Shuey

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

<NOTOPEN>

How do I successfully start a terminal session?

I am trying to add a custom z-segment to a message.  The Below code does not error out but I also do not get the segment added.  Any assistance would be greatly appreciated.  

Class CDSM.AddFedExID.AddFedExIDProcess Extends Ens.BusinessProcess [ ClassType = persistent, Language = objectscript ]
{

/// Add "Business Process" or "Business Operation" for the target
Property TargetConfigName As %String;Parameter SETTINGS As %String = "TargetConfigName:Additional";

Method OnRequest(pRequest As EnsLib.HL7.Message, Output pResponse As Ens.Response) As %Status
{
#dim newrequest = pRequest.%ConstructClone()
#d

I'm using Deferred Response.

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

I'm creating patient extensions and I'm sending an SDA file to be interpreted by Information Exchange.

How do I map the custom SDA3 so that Information Exchange can see these new extensions?

I'm using SDA3.

How do I programatically query a task set up in the task manager? I need to know the code being executed.

Thanks

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.in

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

Hello Again,

We still need additional beta testers for this exam so that we can set a statistically valid passing score. Thus, if you match the exam candidate description given below, we would like you to beta test the exam!

Exam title: HealthShare Patient Index Technical Specialist

Exam candidate: An IT implementation professional who:

• has 6-12 months experience with installing, configuring and supporting the HealthShare Patient Index product to provide either a standalone system or as a master patient index for the HealthShare Unified Care Record, and
• also has domain expertise in the use of

New to Health Connect so please forgive me if this is a stupid question! Is there a specific error code returned when a user initiates an abort from the jobs tab of the business host? I want to be able to treat the Abort as Completed due to our complex business process. Currently, hitting abort just retries the message to the same business operation. Want I want to do is provide the error code used by the Abort (if there is one) and treat it as OK

Thanks in advance.

I have a client running cache on an AIX platform.I put together a objectscript to allow for the viewing the processes running against the database using a select from SYS.Process.One of the values I want in the view of the processes information is Jobtype but I want to convert it from the numeric value to a string value.In the Intersystems documentation there is a reference to an include file $syPidTab.inc that should include macros that make this translation.I have not been able to track down this include file.

There is  a finite list of date formats that users want to use to enter a date in a form. These formats include single digits for month and day and double digits for year.  The field is represented by a dateText control.

How would one get to allow a dateText control to accept multiple date formats ? I see only 3 listed here, do those include using single digits for month and day ?

I tried to set the value of format = "#(myPageProperty.myValue)# " but I got a compilation error in Studio so that went nowhere. Has anyone ever been able to set the format value depending on the user input value?

I