Hi Developers, 

We hope that you enjoy participating in our Global Masters Advocate Hub and have fun completing our exciting challenges. 

And now it's time to announce the Winners for February 2021! Please welcome our awesome Global Masters Heroes!

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

🥇 @YURI MARX GOMES, Software Architect, YM Services, Brazil

🥈 @Robert Cemper, ex Senior Sales Engineer from InterSystems, Germany

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

Learn more about the competition and our awesome winners below.

When using "IDENTITY" as my primary key, I can select the last inserted ID with

SELECT LAST_IDENTITY() FROM %TSQL_sys.snf;

Actually this is how Hibernate + Iris' Driver acquires the inserted ID when mapping with

@GeneratedValue(strategy = GenerationType.IDENTITY)

Now, considering that I am using the type "SERIAL" as my primary key instead, how can I get the last inserted ID?

Note that with "SERIAL" I can forcefully insert any value for this ID, from which Iris will continue generating values...

Hi Community,

Our 2020 Virtual Summit has been scheduled for late October and early November, and we are hard at work on its creation.

SIGN UP FOR NOTIFICATIONS about registration and updates.

Hi Developers!

Many of you work in the companies which produce tools, solutions, frameworks on InterSystems Data Platforms.

You can list your Company on Open Exchange to have an option to publish tools, solutions, and frameworks on behalf of your Company:

This article describes how to do that.

You may have missed it, but it's here.

Now popups from SMP when you're restarting the instance or just lost connection can be suppressed.

All you need to do is set this global:

set  ^%SYS("Portal","DisableConnectivityPopup") = 1

Available for 2018.1.2 and later. Documentation.

Thank you, @Alexander Koblov for the find!

Hi,

We get a lot of errors in the CSP Gateway eventlog like this:

I would like to know the workflow of $za . If you explain me with example that will help.

In case you've never used the "About" link at the top of Management Portal, here's a screenshot of the kind of information it shows. I've highlighted the link and some of the information I find it handy to get from here.

Hello,

I don't know why I can't get into management portal. I saw something related to permission issue of group allowed to start and stop and have already changed to root and Admin but still doesn't work.

Installation info:

I started "httpd server" and "IRIS".

Good morning,

First of all we would like to thank you for your time reading, thinking and aswering this question.

We have been developing a Transformation to convert a source ORU_R01 to a target ORU_R01. For each OBX segment we need to check an if, and then, if it is true we just need to put this OBX and continue to the next iteration, otherwise, if it is false, we need to put (copy) the ORC + OBR + TQ1 before this OBX, and then put this OBX, and after that, the SPM.

Hi Developers,

This July, you've posted the whooping 83 new questions on the Developer Community:

I have an accepted tenant and want to share my deployment.


how is this possible?

Cures Act USCDI/ C-CDAv21 certification. I am looking for SDA3 examples for Newman-Bates-Kid/registry settings/advices on how to learn / whatever is helpful. InterSystems xsl files are clean but I am not working very often with xsl. I am mainly looking at Provenance and Clinical Notes, the 2 last errors we have. InterSystems documentation, so far I know, is very poor: only classes and some pages. Support has a small knowledge about SDA3 -> C-CDAv21 even if they try very hard to help.

I read under Topics and Rules of InterSystems Datasets Contest: