I'm in a tricky situation where a new required property is being added to a class, along with an index on it. The existing data has nulls, so the index build fails. I can't run a query to update the rows where there are nulls, because it tries to use the index, which hasn't been built yet.

I realize that a valid workaround would be to remove the index, add the property, run the query to do the update, then re-add the index, but this feels overly messy (and doesn't fit well with my logic for incremental deployment).

Hey Developers, 

We invite you to take part in the European Healthcare Hackathon 2021 which will take place on November 19-21 2021. Participation is free, the deadline for applications to the ON-LINE track is prolonged until 15 NOV.

We will have an InterSystems challenge there: "Innovate with FHIR". Prize fund in InterSystems track:

🥇1st place: 1500 EUR
🥈2nd place: 1000 EUR
🥉3rd place: 500 EUR
And we prepared prizes for ALL participants of our challenge!
Read the details about our challenge under the pic :) Are you in? Let us know in the poll below!

Hey Community, 

Get an introduction to the purpose and key concepts of Fast Healthcare Interoperability Resources, or FHIR:

⏯ FHIR: Healthcare Data Standard Designed for the Future

Any suggestion that can make programming with Studio easier and smarter is welcome.

In the Caché Foundations course, students are learning about Caché Development and ObjectScript syntax at the same time. To help students complete the exercises, we provide an ObjectScript Quick Reference (aka "the Cheat Sheet").

It is not a reference for all of ObjectScript! It is a list of the ObjectScript commands and functions that students use during the course, along with common syntax for objects, collections, etc. It also contains some useful macros.

We are providing a pdf version to the Developer Community.

I have an incoming data partner who occasionally passes a non-ASCII character in some free text fields which is causing some downstream systems to be unable to accept the message. Ideally I'm looking for some way to just process the entire message as a data transformation applied in the business rule, as we already have a pre-processor transform to remove the PD1 segment. 

ClassMethod Transform(pRequest As EnsLib.HL7.Message, Output pResponse As EnsLib.HL7.Message) As %Status
{ Set $ZT="Trap",tSC=$$$OK
  Set pResponse = pRequest.

Hi folks!

Could you please share your experience on how do you create REST API with InterSystems IRIS that uses bearer authentication?

How do you generate tokens? How do you maintain it (how much time tokens exist?).

Thanks in advance!

Ladies and gentlemen!

Is there a way (some secret call? ) to turn on a debug mode for a particular IRIS web app?

The reason is to log debug information in REST-API dispatch methods if the app is in debug mode.

Of course, I could use "a global", but if there is any standard way?

Hey Developers, 

Don't miss our new video on InterSystems Developers YouTube:

⏯ Working with FHIR Profiles in IRIS for Health

Hello!

While creating DBF file ,  I get unreadeable symbols. For example ╠┼╥└╦╦╙╨├╬┬

How set encode to WINDOWS-1251 ? 

This code doesn't help

w $zconvert(fldValue,"O","CP1251")

Thank you!

Dear All

I am trying to interface LAB instruments with LAB System using ASTM over TCP. I read the documentation here . But I can't understand how to connect instrument and LAB system in same port, please see the screenshot of interface below. Please help.

Details:

• For Servece I use "EnsLib.EDI.ASTM.Service.TCPService" class.
• For Proccess I use "EnsLib.MsgRouter.VDocRoutingEngine" class.
• For Operation I use "EnsLib.EDI.ASTM.Operation.TCPOperation" class.

Hello,

We are connecting to our client's Intersys database with python3.8 on our Ubuntu 20.04.2 LTS, we are having trouble gettin the intersys.pythonbind module to work.

We are able to install the intersystems_irispython-3.2.0-py3-none-any.whl but, when we try to run the code we always get:

Traceback (most recent call last):

  File "./get_well_life.py", line 4, in <module>

    import intersys.pythonbind

ModuleNotFoundError: No module named 'intersys'

Please could you tell us what may be going wrong?

Please also feel free to ask for any additional infomation.

Thanks and regards!

Hi folks!

Consider you are logged in to a REST API in InterSystems IRIS with user A.

What is the way to log out in a browser?

E.g. to login with another user B?

Hi Community,

We're pleased to invite you to the online meetup with the winners of the InterSystems Interoperability contest!

Date & Time: Friday, October 29, 2021 – 12:00 EDT

What awaits you at this virtual meetup? 

• Our winners' bios.
• Short demos on their applications.
• An open discussion about technologies being used. Q&A. Plans for the next contests.

Hi, I am new to InterSystems database. I am developing an application to display real time skillset statistic data, including max waiting time per skillset. I have access to the database through ODBC, using InterSystems ODBC driver. But I don't know from which table or view to get real time data of maximum waiting time per skillset. I appreciate any advices.

Hi

I am in the process of trying to implement version control software with studio.  Has anyone got any recommendations (either Linux based/windows based) as a place to start I have installed Gitlab and I wanted to know whether anyone has come across any obstacles using this.

I was also wondering whether anyone has developed any hooks for Gitlab that works well with Studio as I would prefer if there was a more integrated solution with studio?  Any help with this would be great.

Thank you.

Kind Regards,

Salma

It's time to announce the Winners for October 2021! Please welcome our awesome Global Masters Heroes!

The storm of applause goes to these developers and their great contribution to DC in October 2021:

🥇@Muhammad Waseem

🥇@Robert Cemper

🥈@Julian Matthews

🥉@Eduard Lebedyuk

Learn more about the competition and our awesome winners below.

Hey Community! 

New video is already waiting on InterSystems Developers YouTube: 

⏯ Introducing the InterSystems IRIS Smart Factory Starter Pack for Manufacturing

I’m happy to announce that there is space available in a training on the InterSystems Change Control Record (CCR) application at the end of November. Class is open to InterSystems employees, partners, and customers that use the InterSystems CCR application (ccr.intersystems.com).

Capacity is limited, so please register now!

Course Name: InterSystems Change Control: Tier 1 Basics

When: November 30, 2021 – December 2, 2021, 9am to 5pm US Eastern Time

Where: Live, instructor-led virtual classroom with hands on exercises. You will receive connection details shortly before class.

Hey Community,

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

Hi Community,

We're pleased to invite you to the upcoming webinar in Spanish called "Self-Service Analytics & Reporting"!

Date & Time: November 17, 4:00 PM (CET)

Speaker: @Alberto Fuentes, Sales Engineer, InterSystems Iberia

The webinar is aimed at Data Analytics or Business Intelligence professionals.

We have CSP deployed using CACHE and after research, though it's still supported, CSP isn't recommended for production.  What is Intersystems recommended direction?

Advisory: Discontinued Technologies and Features | InterSystems Developer

CSP | InterSystems IRIS Data Platform 2021.1

https://docs.intersystems.com/irisforhealthlatest/csp/docbook/DocBook.UI.Page.cls?KEY=GSTD_Intro#GSTD_Int_CSPFile

I want to write some code differently to run on Primary, Backup and DR depending upon their status.

If its Primary then do something, if Backup then something else and if DR then do something different from both Primary and Backup.

This can identified whether a system is Primary or Not Primary by calling below method

w $SYSTEM.Mirror.IsPrimary()

1 means Primary and 0 means Not Primary. But a Not Primary member may be a backup or a Async DR or a Async Reporting.

How to identify if a system is a DR or Backup or Reporting?

In my previous article I demonstrated the steps to connect to Caché from Appeon PowerBuilder by using ODBC.
In this article I will demonstrated how to Retrieve data from Caché with Appeon PowerBuilder (https://www.appeon.com/products/powerbuilder) by using ODBC

I am using Company.cls from Samples-Data (https://github.com/intersystems/Samples-Data/tree/master/cls/Sample) 

So Let's start:

Step 1 : First of all we need to establish a connection (https://community.intersystems.

I have a SIU message that has multiple AIS segments in an RGS group. I need to reorder the AIS segments based on the AIS 3.1 value.

What is the most efficient way to do this in a transform?

EnsLib.HL7.Adapter.TCPInboundAdapter has a Connected property that I assume is set to the state of the connection session with the remote host; i.e. 1 when Connected, 0 when not. I'm assuming this is the property the Production Configuration web page uses to display the state of the service (green for Connected, red for not Connected, etc.).

How can I interrogate the value of that property of an active service, via a method running in separate process?

(It really seems like I should know this, but I'm just not finding the right magical incantation)

I was looking at the thread of messages on the topic of "Performance when constructing a comma-separated string", and I started writing a response but got distracted, the page refreshed, and I lost my text. I couldn't spend the time rewriting my response, so I started writing this document instead.

I started writing MUMPS at the beginning of my career. I wrote very tight and dense code blocks where exercises such as the string example were authentic challenges.

One of our apps uses a class query to support a ZEN Report and works just fine in that report, producing the expected results every time. We’ve since migrated to InterSystems Reports and noticed that, for a report using the same class query, 100s of extra rows with the same column values appear at its bottom.

We eliminated InterSystems Reports as the source of the problem by recreating the same “extra rows” issue with an Excel spreadsheet calling the same class query as a stored procedure.

What was the issue?

 Hi Community,

Take advantage of our 90 days of replays. 

Go to Virtual Attendee Hub if you are registered.

Go here to register. (Yes, you can still register.)

How to develop an interoperability solution in one code base and then use it to generate many individual interfaces

Overview

In 2009 I wrote the first of several Interfaces for LabTrak. The Interfaces allowed existing National Health Laboratory Services (NHLS) clients to send Patient Demographics and Orders to LabTrak. LabTrak would, in turn, send the results of those tests back to the client. I wrote 3 or 4 at the time and an Interface that fed data from LabTrak into the NHLS Corporate Data Warehouse.