Hi all,

I am using ExecDirect() method to get SQL resultset of type %SQL.StatementResult. 

now I am fetch a column something like this rs.%Get("Amount") but if amount column is empty then it is return me empty string. If There is any way to set something like this in IRIS rs.%Get("Amount",0.00) if that is possible.

Hello Everyone,

The Certification Team of InterSystems Learning Services is in the process of developing two exams focused on using SQL in InterSystems IRIS and we need input from our InterSystems IRIS SQL community. Your input will be used to evaluate and establish the contents of the exam.

How do I provide my input? We will present you with a list of job tasks, and you will rate them on their importance as well as other factors.

I need to create a routing rule where I've got to check for the value of "-" in field 5 of a repeating RQD segment, if the "-" is found in any of the RQD-5 I want to send it to a transform, if the rule doesn't find a "-" in any of the RQD-5 I want to send it to another transform.

Unfortunately we are running an older version of Ensemble and the foreach function is not available. 

The other thing to add is the transforms are writing the output to a flat file so my business process is using the EnsLib.MsgRouter.RoutingEngine class.

Sample message:

Hi I am trying to run a debugger in VS Code.  I have the settings.json file and the launch.json file.  I am trying to debug code using the attach to a process method, however when I run the debugger I get the following error. 

Launch.json code 

{

    // Use IntelliSense to learn about possible attributes.

    // Hover to view descriptions of existing attributes.

    // For more information, visit: https://go.microsoft.com/fwlink/?linkid=830387

    "version": "0.2.0",

    "configurations": [  

        {

            "type": "objectscript",

            "request": "attach",

Has anyone tried loading Cache 2017 on Windows 11?

I'm working with my corporate IT department to get a version published that will work on Windows 11 desktops but I have to prove that it can be loaded before they will give me the rights to install it.

It looks like Cache 2018 is supported but we're still supporting a bunch of 2017 installations until we can begin the move to IRIS.

Meanwhile the new laptops are all being issued with Windows 11 and the installers are all blocked by corporate. 

Description

With InterSystems IRIS FHIR Server you can build a Strategy to customize the behavior of the server (see documentation for more details).

This repository contains a Python Strategy that can be used as a starting point to build your own Strategy in python.

This demo strategy provides the following features:

• Update the capability statement to remove the Account resource
• Simulate a consent management system to allow or not access to the Observation resource
  • If the User has sufficient rights, the Observation resource is returned
  • Otherwise, the Observation resource is not returned

Hi everyone,

This one had me breaking a sweat 😅

When a SOAP request has a %Stream.GlobalBinary property, it fails to serialize to base64 when stream is larger than ~43MB with 

ERROR #6301: SAX XML Parser Error: <MAXSTRING>xeWrite+7^%occXMLInternal

Unless you enable the following parameters :  

Parameter BASE64LINEBREAKS = 1;Parameter USEPPGHANDLER = 1;

The first one instructs %SOAP.WebBase to insert line breaks in the XML text, and the second one to use globals rather than local array memory during serialization (to avoid <STORE> error, depending on your available $zstorage)

How to call multiple SQL gateway connections in BO

Convert epoch time to standard date in (dd mon yyyy) or (yyyy-mm-dd)

Hello,

We have added the ability to select a default Peer Review Document for a System. To select it, open the CCR Systems page, and pick the desired Document from the dropdown.

The System-level default document overrides the Organization-level document when reviewing a CCR. The User-level document has precedence over both. The introduction of a System-level default peer review document allows different Systems within an Organization to follow different Peer Review practices.

Idea sourced from InterSystems Ideas Portal

Previous Posts:

Using AI to Simplify Clinical Documents Storage, Retrieval, and Search

Doctor-Patient Conversations: AI-Powered Transcription and Summarization

Introduction

The healthcare industry is continuously evolving, and the need for efficient document management and patient data management is more critical than ever. In this article, we will focus on the specific aspects of integrating Google Docs and Google Sheets with FHIR data in the context of healthcare data interoperability.

Google Docs Integration for Clinical Documents

This project is an experiment to use OpenAI API to answer to user prompts in the healthcare domain using FHIR resources and Python code.

Project idea

Hi Community,

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ HealthShare Analytics Solution: So Many Tools, So Much Power @ Global Summit 2022

InterSystems announces its fifth preview, as part of the developer preview program for the 2023.2 release.  This release will include InterSystems IRIS and InterSystems IRIS for Health.

Highlights

Many updates and enhancements have been added in 2023.2 and there are also brand-new capabilities, such as Time-Aware Modeling, and enhancements of Foreign Tables (but still as an experimental feature). Note that some of these features or improvements may not be available in this current developer preview.

Based on your experience, do you know any reason why IRIS would enter a deadlock/hang state ? 

When such thing occurs, it's no more possible to connect to Portal or Studio, despite IRIS service (IRIS.EXE processes) being still active. CPU/memory/network usage are usually very low (eg: it does not occurs because server is overloaded). The only fix is a full restart of IRIS (eg: by clicking on IRIS icon in notification toolbar and choosing appropriate action).

Hi guys, 

I want to develop a web application in which a user can log in through the user credential of intersystems that is created in Management Portal for a specific role. How can I authenticate the user and get any token or login cookie through which user can call other apis

InterSystems FAQ rubric

The InterSystems ObjectScript language does not allow you to define methods of the same name with different arguments. It is generally classified as a programming language called a dynamic language.

In ObjectScript, you can freely control which arguments are used when executing a method, so unlike languages ​​such as Java, which are not dynamic programming languages, there is no need to strictly distinguish methods by the number of arguments at the compilation stage.

Hi Community,

Please give me an example on how to configure email alerting based on the rules and send out emails accrordingly.

As a message comes into the business service component I want to check specific fields and if a field for example active = true i want to send it to a different email and if active = false I want to send it to a different email as well.

Guide me on how to accomplish this requirement and let me know if InterSystems uses a default SMTP server or I must have that server in place.

Regards

Hi all,
I am creating a property in my class something like below. I want to initialize it to 0.00 this a default value.

Property currentLimit As %Numeric(SCALE = 2);

What is the difference between iris2021 and IRIS2020

I am having a datatype DATE value from db 41966. And I want to convert it to epoch time.
Also, in case of DATETIME value how can I convert it to epoch.

The Caché epoch is January 1, 1840  and the Unix epoch (or Unix time or POSIX time or Unix timestamp) is the number of seconds that have elapsed since January 1, 1970 . How do you convert the current date and time to Unix epoch time?

Good day,

Is there a way to change the theme in management portal? or at least the color of the header.

Issue is, some users have access to Development and Testing and Production environments. I would like a way to color-differentiate the environments to reduce the errors. 

VS Code has a powerful snippets capability, and its Marketplace offers a way for developers to publish their snippets so others can use them. However, publishing on Marketplace takes some effort and snippets targeting InterSystems coders will realistically only be of interest to a very small number of Marketplace visitors.

This inspired me to create oex-vscode-snippets-template, a GitHub template for creating repositories dedicated to publishing code snippets for InterSystems devs.

NOTE:  This content was originally presented at the InterSystems Global Summit in 2014, however related topics often come up on the Developer Community so I have decided to turn this into an article for easier reference and discussion.  However, much of the content was pulled directly from the presentation slides so the article format resembles that of a PPT deck more than paragraphs.

Introduction

Teams that deal with many environments (e.g. for development, testing and production) multiplied by many systems (e.g. billing app, hr app, support app) can face a number of changes:

Are you all ready for something you wish you knew ages ago (or, in my case, a DECADE ago)?  Open up a portal in your favorite instance and go to:

System Administration->Configuration->Additional Settings->Startup

Scroll down to "Terminal Prompt" and click 'Edit'.  This allows you to edit what you see on your terminal prompt.  You can change that to my current setting: 8,3,2

What does this do?  It adds your instance name for your prompt.  So now your prompt can look like:

DEVELOPMENT:USER>

Hi colleagues!

InterSystems Grand Prix 2023 unites all the key features of InterSystems IRIS Data Platform!

Thus we invite you to use the following features and collect additional technical bonuses that will help you to win the prize!

Here we go!

• LLM AI or LangChain usage: Chat GPT, Bard and others - 6
• InterSystems FHIR SQL Builder- 5
• InterSystems FHIR - 3
• IntegratedML - 4
• Native API - 3
• Embedded Python - 4
• Interoperability - 3
• Production EXtension(PEX) - 2
• Adaptive Analytics (AtScale) Cubes usage - 3
• Tableau, PowerBI, Logi usage - 3
• InterSystems IRIS BI - 3 
• Columnar Index Usage - 1
• Docker container usage - 2 
• ZPM Package deployment - 2
• Online Demo - 2
• Unit Testing - 2
• Implement InterSystems Community Idea - 4
• First Article on Developer Community - 2
• Second Article On DC - 1
• Code Quality pass - 1
• First Time Contribution - 3
• Video on YouTube - 3

InterSystems is currently looking for a U.S.-based Developer and Startup Evangelist!

Are you a strong developer who loves writing, speaking and teaching other developers about technology while taking a meaningful role in shaping the experience they have with the platform itself?

As you know, if you regularly read the articles that are published in the Community, last May InterSystems organized the JOnTheBeach2023 Hackathon held in Malaga (Spain). The topic that was proposed was the use of predictive analysis tools that InterSystems IRIS makes available to all developers with IntegratedML. We must thank both @Thomas Dyar and @Dmitry Maslennikov for all the work and effort they put into making it a resounding success.

Let's briefly introduce IntegratedML

IntegratedML

Problem

In a fast-paced clinical environment, where quick decision-making is crucial, the lack of streamlined document storage and access systems poses several obstacles. While storage solutions for documents exist (e.g, FHIR), accessing and effectively searching for specific patient data within those documents meaningfully can be a significant challenge.

Motivation