Hello everybody.

My question originated when trying to help a coworker...

There is a system module, specifically a ClassMethod that inserts records into a table as per the pseudocode below:

set Obj = ##class(FooSchema.FooTable).%New()
set Obj.

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

Hi, Community!

Want to share with you one debugging approach from the Russian forum.

Suppose I want to debug the application  and I want it to stop the execution on a particular line.

I add in code this line:

l +d,-d

When I want to start debugging in this line I block d in terminal

USER> l +d

And execute the app.

The app stops on this line and lets me connect to it with Studio debugger.

To release lock I do in terminal

USER> l -d

And what are your debugging practices?

Hello community!

I found a bug or may be I missed something.

I want to get  field name in "PID" segment by field number in HL7 Message using following object script expession:

set nl = $CHAR(10)
set str = "MSH|^~\&|MIHIN PATIENT GEN|1.2.3.4.5.9.99.999.9999.1004||2.16.840.1.113883.3.1481|20200103000000+0000||ADT^A01^ADT_A01|1092|P|2.6|1091|||||||||Windward General Hospital|"_nl
_ "EVN||20200110000000+0000|||||1.2.3.4.5.9.99.999.9999.

Hi Team,

I am trying to call  Datetime in CUSTOM.Training.Functions class please refer the below line.

My Datetime method 

ClassMethod DateTime(DateTime As %Integer)
{
Set Year = msg.SetValueAt(,"PIDgrpgrp().PIDgrp.PID:7.1","set")
Q Year
}
 

But i am not able to get the value of date of birth into the Datetime method, Kindly help how to get data of date of birth value into the method.

Thanks in advance

I have recently started making more use of Docker Desktop on my Windows 11 workstation, particularly in conjunction with VS Code's Remote - Containers extension and the iris-python-template repo from @Guillaume Rongier

Sometimes the container would start smoothly, but other times it would fail and report being unable to use a port.

Eventually I tracked the problem down. The Windows NAT Driver service apparently uses an OS facility to reserve a large range of ports.

Hello and welcome to the March'22 Community Release!

We’ve made some enhancements to your experience recently in the InterSystems Community:

• Brand new Community search
• General Community stats
• Facebook profile connection 
• Post page updates: tags, author block, draft highlighting

Let's have a closer look below. 

Hello everyone!

When running the command 

do ##class(TestCoverage.Manager).RunTest(,"/nodelete",.userParams)

I now get the following error.

ERROR #5002 : ObjectScript error:  <FUNCTION>zStart+45^%Monitor.System.LineByLine.1  <<==== **FAILED** TestCoverage.Manager:OnBeforeAllTests:::

These tests run fine in Studio. 

Also the TestCoverage works fine on all the other namespaces. So far i'm experienceing this problem on this 1 namespace.

The solution of stopping the LinebyLine monitor doesn't help like in the case of ERROR #6060

Can someone please point me in the right direction?

How do you get a $ZTIMESTAMP in local time?.

I have found this solution and it works:

 Set LocalTimestamp=$ZDATETIMEH($ZTIMESTAMP,-3)

Do you use any better way?

Hello,

Using ^TESTGLOBAL as an example, if my data structure is as follows:

Good morning,

First of all, thank you very much in advance for reading and responding.

Also, thank you for any support, because it is a relief, support, contribution, help to have people with more understanding, knowledge and practice, reading, and thinking this doubt.

There is the following need:

Two 2 circuits are available:

1st DICOM Circuit of "Studio" ( Classic Service ).

Service: class: DICOM.BS.QueryService

Process: class: DICOM.BP.QueryProcess

Operation: class: EnsLib.DICOM.Operation.TCP

We test from the "Console" of the "Studio" by means of:

do ##class(DICOM.BS.QueryService).

I am using SQL Outbound adapter and inserting a HL 7 Message by executing a stored procedure and getting an error 

The reason i found is that segment delimiter is causing an issue and following is sample code 

Method AddMessage(pRequest As EnsLib.HL7.Message, Output pResponse As Ens.Response) As %Status
{
    Set tQuery="{call dbo.HL7Message_Insert(?,?,?

I want to avoid  the pop up error messages or redirect them to a file when a terminal launched from a batch file wasn't able to open. I that example the name of the instance was wrong. I am looking for a kind of silent mode or whatever let me avoid this messages. 

I am working on a setup using the iris docker image (iris:2020.4.0.547.0).  I need the timezone to be a different timezone than the host.  Is there a way to do that by passing in an options / variable? 

 InterSystems is pleased to announce version 2.0.0 of the Language Server for VS Code. The Language Server augments the VS Code ObjectScript extension to provide better syntax coloring, embedded documentation, code completion and more. Detailed information is available in the GitHub repo's README. Version 2.0.0 adds support for a number of new platform architectures including M1 Macs! It also reduces package size, improves SQL coloring, and fixes a number of other issues detailed in the CHANGELOG.

If your Open Exchange app has an online demo or demo which could be downloaded, you can add the link to it in your app profile.
To do so:

1. Login to Open Exchange
2. Go to your account to "Application" section
3. Click on the app which has a demo 
4. Go to Settings -> Edit
5. Put your link to the demo into Demo URL field
6. Save the changes 
7. Send the application for approval

Online demo example of the iris-python-faker

Hi, I’m using $ZDATETIME to return the following

• USER>w $ZDATETIME($zdth($zstrip("2022-03-29T15:10:00+0100","<>W"), 3,5),3)
• Output: 2022-03-29 15:10:00

I would like to return just the YYYYMMDDHHMM i.e. stripping out the seconds.

 Does $ZDATETIME have an option for this?

Did anybody tried/ suceeded to install IRIS System on a NAS Server?

Hey Developers,

Now it's time for all French-speaking users of our community!

We're super excited to announce the official start of the InterSystems Developer Community in French!

Let me introduce you @Guillaume Rongier, @Robert Bira and @Irène Mykhailova as managers of the French Community.

Hi Team,

I am getting the below error while calling Method from ClassMethod in the same cls file.

Please help me with this, So It would be very helpful for me.

Hello,

First of all thanks for your help

How would you recommend us to filter in the message viewer to find inside a property called "mensaje" of type " %XML.GlobalCharacterStream" which is inside a class called " Mensajes.Request.Laboratorio.peticionER7Request", the text "24642"?

We have tried:

It shows:

ERROR #5540: SQLCODE: Message -37: Unary function %EXTERNAL does not support sequence fields.

ORIGIN ELEMENT: %ZEN.Component.tablePane (resultsTable)

In addition we have tried to output the %XML.

Hi,

The company I work for has one software application that uses an IRIS database, with almost all the others using SQL databases.

On a SQL database, we can create local tables and create views. These are invaluable when it comes to reporting, and everyone here is quite up to speed with using SSMS to create functions, stored procedures, etc.

However, when it comes to IRIS, no-one seems to know anything.

Hello,

I need support for my case!!
I have 18 GB health care cache Database i face delay with filter and transmit data around 20 - 45 Minutes, I need solution to fixed my issue.

I did Rebuild indexes & Tune Table .

Thanks,

Hi Developers!

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

• Data-model implementation - 5
• Functional index implementation - 5
• Data Move usage - 3
• Embedded Python - 4
• Docker container usage - 2 
• ZPM Package deployment - 2
• Online Demo - 2
• First Article on Developer Community - 2
• Second Article On DC - 1
• Code Quality pass - 1
• Video on YouTube - 3

See the details below.

Hi guys!

The final day of the Hacking Health Camp 2022 in Strasbourg, France, is upon us and today we will see all the wonderful creations of the teams. They worked hard through the night and our teams onsite and online worked with them and answered their questions.

I need to turn off Journalling for a particular database programmatically.

How can I make it happen?

Hi guys!

We're continuing our updates of the 2nd day of Hacking Health Camp 2022 in Strasbourg, France.

All our mentors @Irène.Mykhailova, @Lorenzo Scalese, @Laurent Viquesnel and @Guillaume Rongier are very busy exchanging ideas with teams and giving advice. 30 minutes per team to lead them to the best solution possible.

And of course, we have a dedicated team to answer ensuing questions about FHIR while the coaches are working in their respective groups.

I have the object query:

s Rset=##class(%ResultSet).%New("%SYSTEM.License.UserListAll")

I can loop through that query and it generates the report information that I need.

I have a Python process where I use the intersys import to connect to the Cache instance. But I have been unable to determine the correct syntax in Python for this query. Being that 'UserListAll' is a query I attempted to user:

res = <query>.prepare("select * from %SYSTEM.License_UserListAll")

That failed stating 'UserListAll' did not exist. Though this did not seem to be correct, I also attempted:

<query>.prepare_class("%SYSTEM.

Hi Community,

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

⏯ Exploring Machine Learning with R Language Gateway

See what's new in InterSystems Learning Services! In the March 2022 newsletter, you will: 

• Get an overview of the new documentation search features.
• Find content to help you prepare for certification as an HL7 Interface Specialist.
• Learn the latest on Embedded Python. 
• See how to start performing analytics in InterSystems IRIS® data platform.