InterSystems FAQ rubric

Global mappings can be registered using the system class Config.MapGlobals.

The method to globally map ^Sample.PersonD in a database SAMPLES other than the default database from the namespace USER is as follows (example executed in a terminal).

USER>zn"%SYS"

The third argument of the Create() method of the Config.MapGlobals class is passed by reference, so specify it by appending a period (.) to the variable name.

In addition to using the Config.MapGlobals class, you can also define using the installation manifest class.

Visual Studio Code releases new updates every month with new features and bug fixes, and the February 2024 release is now available. 

Version 1.87 includes: 

• Voice dictation in editor - Use your voice to dictate directly in the editor.
• Multi-cursor inline suggestions - Review and accept inline suggestions for multiple cursors.
• Copilot-powered rename suggestions - Get rename suggestions for symbols from Copilot.
• Side-by-side preview refactoring - Preview refactorings across files with multi diff editor.
• Smarter Python imports - Improvements for adding missing Python imports.

Can anyone give me a hint about this error?

I can compile sources following this approach, create a container and so on, but for example in specific commands to run test, I get the error.

ERROR #6063: Memory allocation for the Monitor failed

--

stats:

CONTAINER ID   CPU %     MEM USAGE / LIMIT     MEM %     NET I/O                  BLOCK I/O            PIDS
29efa407abc9   3.46%     2.094GiB / 77.32GiB      2.71%       40.1MB / 2.1MB   416MB / 4.

The goal is to identify programmatically all SOURCE namespaces on a server to which the routines are mapped. In the example below from the Namespaces page in Management Portal the answer would be USER. But some other namespaces on the same server could be mapped to a different namespace or even mapped to itself.

This code snippet prints all namespaces and source namespaces for their routines.
zn "%SYS"
set statement=##class(%SQL.Statement).%New()
set status=statement.%PrepareClassQuery("Config.Namespaces","List")
set resultset=statement.%Execute()
while resultset.

I am sending an httpRequest from ObjectScript to a python server.   I am not receiving a response in OS
 
OS config On the client side

// Create an HTTP request object
    Set httpRequest = ##class(%Net.HttpRequest).%New()
    
    // Set the server URL
    Set httpRequest.Server = "http://127.0.0.1:8080"
    
    // Set content type to JSON
    Set httpRequest.ContentType = "application/json"

    // Clear any existing entity body"{""name"": ""Lowell Buschert"", ""dob"": ""1970-12-09"", ""address"": ""XXXXX""}"
    do httpRequest.EntityBody.Clear()
    //Set httpRequest.

I save / compile a class and instantly run a debug.  No issue

A few seconds later, try to run the same debug and get presented with either: 

1) Target Source is not compiled (Open launch json) dialog box

                                                    OR

2) The version of the file on the server is newer.

In the meantime I have made no edits to the VS Code window at all. 

If I pull a compare in response to #2 above, I am presented with a bunch of extent info built into the storage definition similar to the lines below.

Hello!

How I can call my Business process - "process.ReconciliationPayments" from method. Like this.

ClassMethod getReportPavlodarEnergoSbyt()
{

s sc = $$$OK

s ensBS = ##class(Ens.BusinessService).%New()

s requestObj.operationDate="2024-02-28"
s requestObj.provider="Provider"
s requestObj.processId=$SYSTEM.Util.CreateGUID()

d ensBS.SendRequestAsync("process.ReconciliationPayments",requestObj, "payment")

q sc

}

s ftp=##class(%Net.FtpSession).%New()
 s ok=ftp.Connect(server,user,password,port)
 s ftp.Timeout = 100
 
 i ok {
   
   s ok=ftp.SetDirectory(directory) 
   i ok {
     n files,file
     
     s ok=ftp.NameList(directory,.files)
     i ok {
       f i=1:1:files.Count() {
         s file=files.GetAt(i)
         i (ftp.SetDirectory(file)) {
           d ftp.SetToParentDirectory()
           continue
         }
         s fname=$p(file,"/",$l(file,"/"))
         s ok=ftp.Retrieve(file,.data)

Hi,

I have a scenario where I recognize that I have a duplicate patient in FHIR , both have a different set of data attached to them (Specimens / Observations / Conditions) and I want to transfer all the data from patient X to patient Y,  and maybe mark patient X as not relevant or delete it IDK yet.

since Patch currently supports only single patch,

"The Conditional Patch query identified more than one resource."

I can't use it as a bulk, but I need to loop through all the resources I find that are connected to patient X,

so I guess my question is how would you do it?

Hi All,

When resending HL7 messages out, the receiving system rejects the message indicating the "Message Control ID already exists" (see error below). Iris retries resending the same message until the receiving system crashes and the BO disconnects in Iris. I would like to suspend the message when Iris receives that error and move on to the next message. Is this possible? Can it be handled by the BO Reply Code Actions settings? What reply code actions should I use? 

The error comes back when using the default Reply Code Actions ':?R=RF,:?E=S,:~=S,:?A=C,:*=S,:I?=W,:T?

I am trying to figure out how to get yesterday's date in object script in the format yyyy-dd-mm. Any help would be greatly appreciated. 

hi,

I am trying to connect to an external MySQL database from IRIS 2023.1 platform. Does anyone know the right adapter to use? Where do you set up the DSN name?

Thank you in advance.

Sheetal

Hi Members,

Watch this video to learn a new innovative way to use a large language model, such as ChatGPT, to automatically categorize Patient Portal messages to serve patients better:

⏯ Triage Patient Portal Messages Using ChatGPT @ Global Summit 2023

Hi All! We have a new online course that those of you who do integration work / create data transformations may be interested in: Editing Data Transformations via Code. This course is meant to build familiarity with the code behind data transformations in InterSystems products, enabling you to identify their class structures, logical elements, and more. Directly editing code can provide an efficient way of updating DTLs in some scenarios, but building expertise with it is key, since you lose the guardrails that the UI provides if you go straight to code.

I know we can use Do ^DBREST and EXTSELCT ^DBREST or EXTALL ^DBREST to recover the database. But now I just want to use Do ^DBREST to achieve database recovery through this method.

Any help would be greatly appreciated

In this paragraph of the article, here is an example of different records to explain how to fill in DirName、Globals and RestAll, but i don't know what is DUA1:[TEST3] ? This doesn't look much like dirname, like this /cachesys/mgr/test/. Can someone explain it? I would greatly appreciate it !

Big news from the Open Exchange platform!
We've been busy behind the scenes, not just giving the place a new look but also packing in some nifty features we think you'll love—many of which were inspired by your requests and feedback. It's all part of our ongoing mission to boost the quality of the apps and ensure the world sees the incredible work you're putting in. From streamlining your workflow to boosting collaboration, our aim is to support and highlight your creativity. Excited for you to explore and experience the new enhancements!

IRIS is known to have a built-in Python bridge and even allows you to write Python server code but what about JavaScript? Let's say I need a JavaScript expression interpreter. What would you recommend as the most effective way to get one? It is highly desirable that the solution does not require administrator privileges and uses in-process communication (I mean not http and not unix-specific interprocess-communication via command line)

Wondering if there's a setting in VSCode to stop continuting commenting in VSCode?

For example, if I have

//this is a comment

and press enter at the end, it will continue on the next line with

//this is a comment
//|

I would like to stop this behavior, or have it only continue with a block comment.

Is this possible in VSCode? I think it's part of the ISC extension that causes it, as it doesn't happen for other languages.

Thanks!

How to remove accentuation of a word?

Ex:

Árvore = Arvore

você = voce

Então = entao

The words above are in brazilian portuguese, I need to get rid with the accentuation such that I can compare two sentences.

Thanks in advance.

Welcome to the January'24 Developer Community Release!

We've been really busy making our Developer Community an even more amazing place to be. Therefore we have lots of new updates for you to sink your teeth in:

📌 Nickname

📌 Credly badges

📌 Subscriptions

📌 Play/pause GIFs

📌 Auto tags

Let's have a closer look at all these wonderful updates!

Hello everyone,

I'm looking for a way to retrieve the result of the ZW command in a global, is this possible?

How do you tell the last date/time a LookupTable (LUT) was updated?

(In HealthConnect)

I just realized that for the latest version of IRIS for Health 2023.3 the method InstallFoundation from HS.HC.Util.Installer has just disappear. I checked the official documentation (here) but I can't find any reference to it like in previous versions (here).

Is there anyway to create it by code?

I want to address the nasty problems about reading a flat text in ASCII, UTF*
explicitly excluding HTML, EBCDIC, and other encoding.
According to Wikipedia there are at least 8 variations of control characters.

• CR+LF is typical for Windows
• LF is typical for the Linux/UNIX world
• CR is Mac's favorite

As you can deduct from the names the inspiration comes from mechanical typewriters.

In IRIS* similar as in Caché or Ensemble or .

Hi Developers,

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ Transforming HL7 V2 Messages in Health Connect

There is an interesting new feature in the recently announced 2024.1 preview, JSON_TABLE. JSON_TABLE is one of a family of functions introduced by the 2016 version of the SQL Standard (ISO Standard, published in early 2017). It allows for JSON values to be mapped to columns and queried using SQL. JSON_TABLE is valid in the FROM clause of some SQL statements.

The syntax of JSON_TABLE is quite large, allowing for exceptional conditions where the provided JSON values don't match expectations, nested structures and so on.

The basic syntax is quite straightforward.

Welcome to the first quarterly platform update of 2024.  If you’re new to these updates, welcome!  This update aims to share recent changes as well as our best current knowledge on upcoming changes, but predicting the future is tricky business and this shouldn’t be considered a committed roadmap. 

With that said, on to the update…

InterSystems IRIS Production Operating Systems and CPU Architectures

Minimum Supported CPU Models

As a reminder, we announced that InterSystems IRIS will start to have minimum required CPU functionality for Intel/AMD-based systems starting with IRIS 2024.

In the previous article we saw how we could recover a resource stored in the database of our particular HIS, so today we will see how we can add new records in our HIS whose origin is an FHIR resource that we receive in our system.

CRUD operations with FHIR

One of the main functionalities of FHIR is its support for CRUD operations through the Rest API, this implies that any system that works with FHIR must provide support for HTTP calls of the GET, POST, PUT and DELETE types.

Need to fetch data from SQL server management studio to ensemble, using jdbc or ODBC. 

Step by step solution would be highly appreciated.