Hey Developers,

Ready to participate in our annual December competition?

Join the Advent of Code 2021 with InterSystems and participate in our ObjectScript contest to win some $$$ prizes!

So I've been reviewing a lot of questions posted in the InterSystems community regarding NULL properties in JSON. I've also been reviewing the JSON documentation. None of these things have been able to help me so far.

1. We don't seem to have the %JSON.Adaptor class available for us to use in our system.

2. I'm not really confident enough to create JSON Type classes or backporting code, etc.

I created a dummy class and I need my JSON to look like this:
{
    "notanumber":"28001",
    "aboolean":true,
    "anumber":12345,
    "adecimal":1.

Is it possible to call java programs inside SQL statements, like the new LOAD Data, or is this just internal?

I Have a problem with a Signature validator to XML file, when this file have more than one Signature tag.

Like This

Hi Team,

I want to generate HL7 based on passing the HL7 version in InterSystems IRIS.
If there is any possibility to implement in InterSystems IRIS or not?
If yes, then give a solution regarding for same.

Thanks,

Harshdeep Acharya

Hello everyone! Don't miss the Developer Community Post Digest for December 2021.

Hey Developers! Here is a digest of new solutions and applications submitted to the InterSystems Open Exchange in December 2021.

Hello,

I have a question about defining properties for various of services, operations and processes in Productions. Let’s say I have developed a container running an IRIS instance with a single namespace and a production with pre-defined set of components. I’m planning to deploy this container to dev, staging and production environments. These different environments use different settings for the operations, etc. For example, dev-environment could use some test endpoint for an HTTP component, e.g. https://testdomain.com/test and production environment https://proddomain.com/prod.

Hi Devs!

Recently, I needed to create templates for newsletters.
I couldn't find any tools, so I decided to use the CSP (Caché Server Pages) to build the templates.

Let's figure out how to make a newsletter similar to Weekly OEX Digest.

Weekly OEX Digest

There are strict requirements for HTML email messages.
Basic requirements:

1. The page should be static;
2. You have to use inline styles for mailer compatibility (so much code);
3. Use custom fonts, some images, etc.

I am a newbie who is trying to learn how to set up a basic connection to Iris using a node js application. I am astounded at the lack of documentation there is on how to do this and even more concerning there are a few errors within the documentation. For example I am on the Native API application within the below link.

https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cl…

And it says that you need to create a directory the thing is that it doesn't state which directory this needs to be or any other history.

trying to lock a table via .Net Command results in IrisExcpetions no mater what i try; 

Documentation says the Command is supported by TSQL Implementation - any known tricks how to implement this comand?

Hi all,
I try to build a little project for the dataset contest, you can find it here on github: Openflights dataset
My plan is to use just plain SQL. So I've made a few experiments with the new feature LOAD DATA.

Unfortunately all loads produce errors like:  
 Error: [SQLCODE: <-400>:<Fatal error occurred>]
[Error: <<UNDEFINED>zExecute+83^%sqlcq.OPENFLIGHTS.cls4.1 *%qparsets>]
[Location: <ServerLoop>]

The statements I use looks like this:

This happend with the preview release "IRIS Version 2021.2.0.617". While this error occurs, most rows are written to the database, but some rows are missing.

For me the best moments were:

1 - Global Masters WON the 2021 Influitive BAMMIE Award for Most Passionate Community

2 - Tech Article contests

3 - InterSystems Programming Contests

4 - 10,000+ DC members

5 - Partner directory and business services

6 - 500+ applications on OEX

7 - Open Virtual Summits

8 - Prizes from GM points

9  - Free online learning courses

10 - Discord channels

11 - Innovations from IRIS Data Platform

12 - Multilanguage communities, including portuguese, spanish and chinese community

13 - Advent of Code

The XData (https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls?KEY=GOBJ_XDATA) is a powerful feature to set documentation and metadata information for classes and methods. The %CSP.REST class uses XDATA to mapping REST calls (https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls?KEY=GREST_csprest), so in this article you will see how to use XData into your apps as code, not only as documentation.

When you write XData comments/definitions, the IRIS store it into %Dictionary.ClassDefinition (for classes) %Dictionary.MethodDefinition (for methods).

Hi

I am a very experienced Ensemble and IRIS developer who has spent his entire career either working for InterSystems or with their products. I was a Senior Sales Engineer with InterSystems for 14 years with a further four years working for InterSystems TrakHealth. I started working for the InterSystems UK office and from there I spent several years travelling to InterSystems offices in Europe, Scandinavia, the Middle East, Israel and eventually ending up in the South African office. I moved back to South Africa in 2001.

Hi Community,

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

In this webinar, we’ll do a quick tour of the new LOAD DATA feature, also chime in on packaging global data or file data with ZPM, and run a data-generation script as part of a method in the zpm install. 

As always, our experts will answer the questions on how to develop, build, and deploy datasets using InterSystems IRIS.

Date & Time: Tuesday, December 28 – 10:00 AM EDT

Speakers:  
🗣 @Benjamin De Boe, Product Manager, InterSystems  
🗣 @Evgeny Shvarov, InterSystems Developer Ecosystem Manager

Where can I download the ODBC35 driver version 2018.1.4 64 bit?

Hi,

In a Business Operation i have the following code.

I need the identity of the latest row inserted in a table in MSSQL.

i Have the following code:

---------------------------------------------------------

set insertmaster= "INSERT INTO dbo.dataMasterArchive(deviceToPatientLogID) values (?)"

set tSC = ..Adapter.ExecuteUpdate(.nrows1,insertmaster,pRequest.deviceToPatientLogID)                                
$$$ThrowOnError(tSC)

set sql ="SELECT SCOPE_IDENTITY()"
set tSC = ..Adapter.ExecuteQuery(.tResult,sql)
$$$ThrowOnError(tSC)

set maxID =

Hello.

I want to store a mailbox in Caché, persistently.

Does anyone have some code for downloading all messages from mailbox into Caché? And maybe automatic syncing after download? I know, there is  %Net.POP3 but maybe someone has already done that.

Thank you.

Hi

I'm using a class which extends  %XML.Adaptor adaptor and I want to create an XML file with multiple namespaces, like the following:

<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
</soap>

However, I don't see how to do this with the code I have. So far, I have

 Class GMMHTIE.Docman.Messages.Request.RequestWrapper Extends (%Persistent, %XML.Adaptor)
{
 Parameter XMLNAME = "soap:Envelope";
 Parameter NAMESPACE = "http://www.w3.

Hey everyone,

Lots of new content to read! Thanks to our wonderful participants of the 2nd InterSystems Tech Article Contest!

🌟 25 AMAZING ARTICLES 🌟

So it's time to announce the best of them!

For those that, at some point, need to test what means that of ECP for horizontal escalability (computing power and/or users and processes concurrency), but they're lazy o have no much time to build the environment, configure the server nodes, etc..., I've just published in Open Exchange the app/sample OPNEx-ECP Deployment .

UnitedHealth Group is looking for an IRIS expert to help guide our development team, providing subject matter expertise and sound software design skills.

This is a permanent, full-time, 100% telecommuting position.  The job will be a mixture of software design, consulting and hands-on development.  The ideal candidate will have excellent communication skills, a solid understanding of computer science and be an energetic team player.

I need iterate multiple times the same ResultSet. How can I do a rewind on it?

Does someone knows if any Studio version or, if in its new versions, it will be able to recognize new Javascript statements like arrow function, let, const etc ?

let there be less <UNDEFINED> or <SUBSCRIPT> Errors in my life.

Hey Developers,

Learn about the latest updates to InterSystems HealthShare Health Insight and what is coming next:

⏯ InterSystems HealthShare Health Insight: New & Next

We have a couple of systems that send us a URL link to a PDF instead of base 64 encoding it in the HL7 message. Has anyone ever tired to take that URL, and retrieve the file off of the server to save it off somewhere?

Hi Developers, 

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

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

🥇 @Robert Cemper, ex Senior Sales Engineer from InterSystems, Austria

🥈@Oliver Wilms, Integration Engineer, Take2 Consulting, USA 

🥉 @Mary George, Team Lead, Barts Health NHS Trust UK

Learn more about the competition and our awesome winners below.