Hi guys, just a quick question on how get the sql statement that has been executed in a %ResultSet?

so basically after the execute command I would like to save the SQL statement generated in a eg, a global and check sql statement?

Set rset1 = ##class(%ResultSet).%New()
Set sc = rset1.Prepare("Select statment ")
Set:+sc sc = rset1.Execute(parm1,parm2)

Maybe something like s ^sql=rset1.Getstatment !?

Thanks

Seeking opportunities either remote or local to Massachusetts for an experienced HealthConnect developer.

Have experience in transaction HL7 messages, mostly ADT and Results.  Developing rules, transforms and message schemas.

I have created a Class method to list employees that are subordinated to a certain boss. But I don´t know how to relate the data in the way it was given to me.

For Example:

• ^Employee(IdEmployee) = Name

                  ^Employee(1) = "Jessica"

                    ^Funcionario(10) = "Rose"

• ^HistEmployee(IdEmployee, Date) = Salary^Job^IdEmployeeBoss

                    ^HistEmployee(10, 64628) = "3500^Secretary^1"

So, based on this seetings, Jessica is Rose's boss. But I don't know how I can make a relation between that string and the subscript. Can someone help me?

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

The storm of applause goes to these developers and their great contribution to DC in January 2022:

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

🥈 @Muhammad Waseem, HIS Team Lead, International Medical Center, Jeddah, Saudi Arabia

🥉 @Prashanth Ponugoti, Technical Architect, Optimus IT Infra Ltd, London, United Kingdom 
 

  Learn more about the competition and our awesome winners below.

Hey Community,

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

Hi Community,

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

In this webinar, we’ll present two templates to start working with Embedded Python :

1. What is Embedded Python and Jupyter;
2. Embedded Python with Interoperability (PEX hacked to use Embedded Python).

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

Date & Time: Monday, February 7 – 12:00 PM EDT

Speakers:
🗣 @Guillaume Rongier, InterSystems Sales Engineer  
🗣 @Bob Kuszewski, InterSystems Product Manager
🗣 @Evgeny Shvarov, InterSystems Developer Ecosystem Manager

Hey Developers,

It's time to announce the Top Contributors of the InterSystems Developer Community for 2021!🎉

We are pleased to reward the most active contributors across all regional DC sites (EN, ES, PT, JP, CHN):

• Top Authors
• Top Experts
• Top Opinion Makers

Let's take a closer look at the DC Wall of Fame 2021 and greet everyone with big applause! 👏🏼 

Hi Community,

We got requirement to Migrate whole interfaces from prod instance (cache2017.1 ) to new instance iris2020.1.

Currently around 100+ integrations (health share and health connect) up and running in prod instance (cache2017.1 ) , we need to migrate this live server to brand new server with iris2020.1.

Could you please suggest me guidelines and best practises while doing this migration.

Please ping me any document reference for this kind of Lift and Shift Migration.

After migration done, we will use new Live (iris2020.1 )instance only.

Thanks,

Prashanth

Hi Developers!

Here're the technology bonuses for the InterSystems Python Contest 2022 that will give you extra points in the voting:

• Embedded Python - 4
• Python Native API  - 3
• Python Pex - 3
• NoObjectScriptLine - 5
• Questionnaire - 2
• Docker container usage - 2 
• ZPM Package deployment - 2
• Online Demo - 2
• First Article on Developer Community - 2
• Second Article On DC - 1
• Video on YouTube - 3

See the details below.

Is it supported to be able to use member functions to define a set, in particular a set defined with a member range in the form:

set = member1:member2? 

The docs only show hardcoded values being used for member1 and member2 and I can get it to work if I use hardcoded values.  However if I try to use member functions it throws an error:

"ERROR #5001: Both parts of a range must be members"

While the below does not give me the correct answers without using the %All function, it does work.

Valant Medical Solutions is a market-leading, software-as-a-service organization serving the needs of the behavioral healthcare industry. Our mission is to develop disruptive technology solutions that exponentially improve behavioral healthcare quality to better serve mental health providers and their patients. We’re seeking enthusiastic, passionate individuals to join us as we transform the industry!

Hello again CCR community,

We have officially released our CCR Technical Implementation Specialist certification exam for beta testing. The beta test will be available until March 1st, 2022. 

Interested in beta testing? Please review all the exam details and recommended preparation here, and then contact the Certification Team at certification@intersystems.com to get signed up as a beta tester!

Thank you!

Summary: Responsible for overseeing all aspects of the enterprise interface environment. This includes the implementation, configuration, coordination, maintenance, troubleshooting, security, monitoring, and support documentation of interfaces between various hospital applications. Integrations can include HL7, batch, custom scripts, etc. as required. Incumbent must ensure the interface environment maintains the highest reliability and performance along with keeping the environment on the cutting edge of current technologies.

Hi Folks,

I created a persistent class as below 

Class myclass.DataBase Extends %Persistent
{

Property ID As %String;

Property Skill As list Of myclass.SerialTablelist;
}

and Created another Serial class as 

Class myclass.SerialTablelist Extends %SerialObject
{

Property PSkill As %String;

Property OSkill As %String;
}

Now I will save the id as below

do rs.Prepare("Insert into myclass.DataBase(ID)VALUES(?)")
do rs.Execute(ID)

I am facing issue with the AS LIST OF 

Could any one guide me how to save the Skill (PSkill ,OSkill ) using resultset (I am able to )

I am having a scenario where I need to check difference between current date and a past date should be less than 31 in Routing Rule. Can anybody help me how to code that?

Hi All,

We have been using DeepSee which has been the integrated Analytic Dashboard built over Cache Cubes. It works fine but it's visual capabilities are limited and most probably is getting phased out.

If I am not wrong, Tableau is the suggested alternative to DeepSee .

Hi,

I'm a java developer,have  integration package for springboot?(maven or gradle)

How to deal with it EnsLib.EDI.XML Restrictions on the return length of the. Document class

Hello CCR Users,

This is a last call for feedback on a few Angular pages in beta before we release them to all CCR Users later this month. 

These pages will be released from beta:

• Create CCR
• Clone CCR
• Merge CCRs
• Group Details
• Standard Changes
• Peer Review Docs

Group, Standard Changes and Peer Review Docs are lower traffic pages, so we especially appreciate feedback on those.

Any issues or feedback can be reported here or in your regular support channels. Non beta users can toggle their beta status here in the CCR app.

Thanks!

I have an SDA feed from an Edge server that eventually is fed into HSHI / Analytics. This edge server is loading up patient demographics (in the Patient object), which feeds the HSAA.Patient table in HSHI / Analytics.  

However, we have other edge servers also feeding into the same HSHI database, and these other edge servers have better demographic information.  

HSHI appears to use the most recent demographic information from all edges.  What's the best way to de-prioritize patient demographic information from this particular edge (or this particular Facility) when feeding it into HSHI?

Hi all - we just released the first episode of Season 2 for our Data Points podcast by Learning Services. This episode features a conversation with @Bob Kuszewski about Embedded Python. If you're a Python developer, or if you're simply interested in the functionality, check it out! For more information, head over to https://datapoints.intersystems.com.

Hi guys,

I've two Ensemble instances running in a 2016 server but only one of them showing in startup programs.

the ensemble cubes doesn't showup in the programs list from the Start button as well so how can I add the cube so I can access it's facilities (Studio, MP,...etc)

Thanks

I'm using cache  win10-x64  version 2017.2.1.801

I want to uniquely identify the installation of cache, and from that create a meaningful unique folder names to store files. 

so to generate \192-168-1-100\KEVDEV\testfolder \ and \192-168-1-5\LIVE\testfolder\

so in this case, I could- use the IPaddress and thesecond part of $SYSTEM (cache instance name) - at least this way, I can instantly see where it came from with little risk of overwriting between cache instance.

I'm required to do a transformation around patient physical addresses.  If (for whatever reason) a patient has multiple addresses, I want to move the home address to the first iteration of PID:11 and remove all other iterations.  I've accomplished the first bit using DTL, but for patients who have multiple addresses they are left with empty trailing iterations.  Here is an example I mocked up:

How can I remove those trailing iterations?

This is part of the DTL I've written to do my transformation:

<foreach property='target.{PID:PatientAddress()}' key='i' >
<if condition='source.

Spring Boot is the most used Java framework to create REST API and microservices. It can be used to deploy web or executable web or desktop self-contained apps, where the application and another dependencies are packaged toghether. Springboot allows you do to a lot of functions, see:

Note: to learn about SpringBoot see official site - https://spring.

(I wasn't able to find this in the docs or the Community, so feel free to point me to a reference that I missed)

How can I determine the effective User and Group that will be used when an InterSystems IRIS process is doing file I/O on the file system for UNIX?  Bonus points if you can tell me how to do it from within InterSystems IRIS as well as from the host OS.

Thanks!

I'm trying to write a method that runs an OS command with $zf(-100,"/ASYNC") and then waits for it to finish before returning, but I can't figure out how to check if the child process (in $zchild) is still running. $System.Process.State($zchild) always returns "RUN" even once the child process is gone. Is there some better way to check this, short of running another OS-specific command and processing the output (which is just really annoying and unelegant)?

Finding errors in your code or examining unexpected behavior is the main purpose of Debugging
I will try to refresh the traditional tools away from the helpers you have in Studio, VScode, Serenji, ....
to the basics which have been there before your preferred EDI used it in the background.

Hey Community, 

New video is already on InterSystems Developers YouTube:

⏯ Git & GitLab for Shared Development Environments