Hi Community,

Our 1st InterSystems Portuguese Tech Article Contest ended. We received several interesting content in: 6 amazing articles 🔥

A great thanks to all that participated on our competition !

And now it's time to announce the winners ....

Meet the winners of the 1st InterSystems Portuguese Tech Article Contest and their amazing articles:

Hello

We have a solution with an EnsLib.EMail.InboundAdapter as services that scan a mailbox on incoming mail with attachments.

When a new email arrives, the service sends the request (with a property %Net.MailMessage) to the process. In the process, we try to loop through and retrieve part 2 which we assume is the file.

set Part = pRequest.Mail.Parts.GetAt (2)

We can read out the file name:
Set FileName = Part.FileName

But how, and is it possible, to save the attached file to disk drive?

Hi guys,

How to find out the number of active connections (including SQL, http, tcp and all remote connections) of an IRIS instance? A core based license is used.

I've checked the document and find %SYS.ProcessQuery.

I'm currently using this sql:

select count(distinct Pid) From %SYS.ProcessQuery
where ClientIPAddress is not null
and ClientIPAddress <> '127.0.0.1'
and ClientIPAddress <> 'localhost'
and IsGhost = '0'

Is it accurate or do we have a better option?

Thanks in advance.

Hi Team,

I am Working on one data transformation, In the data transformation the data transformation data needs to be saved in the globals.

Can you please help me to save the data into the globals in a Persistent class.

Thanks in advance

Hi All....
its possible get all extended classes from abstract class?

Could someone tell me a method that does this? or will I have to implement something by reading the data dictionary?

I am use cache 2018

Hi everyone, how do you run multiple quires?

I have tried couple of different ways, but not working.

SET sql = 2

Set sql(1) = "UPDATE QUERY"

Set sql(2) = "UPDATE QUERY"

Set sqlStatement=##class(%SQL.Statement).%New()

Set sc1=sqlStatement.%Prepare(.sql)

If $$$ISOK(sc1) {

Set tResult = sqlStatement.%Execute()

}

else{

$$$LOGERROR("Failed")

}

Hello, good morning

First thank you for your time in reading and answering our question.

We have been reading, inquiring, researching about how to make multiple dispatches from 1 Process of type "DICOM.BP.QueryProcess" to several target Operations.

We need some help to further develop this use case, and some advice 🧭, examples or recommendations

Hey Developers,

What is the best way to containerize your InterSystems IRIS application? Discover your options:

⏯ Containerizing InterSystems IRIS Applications

https://www.youtube.com/embed/9_Zp6mzUXFI
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

Since the ObjectScript plug-ins for VS Code use web services to connect to IRIS, is it possible for a VS Code user to authenticate against IRIS using OAuth?

Hi

I'm using an embedded SQL statement with a a cursor-based Embedded SQL query that uses host variables in the where clause, however, what I'm doing doesn't seem to work. Can anyone help?

The code I'm using is

Hi,

i have made a testing package (name "test.a") and want to move it now into an other new package (f.example work.a)

is that possible?

Michael

How can I get the Python error object(exception return value) from the embedded python method?
I have an embedded Python method like as below;

Hi Developers,

New video is already on InterSystems Developers YouTube:

⏯ Adaptive Analytics in Action: Financial Services Use Case

https://www.youtube.com/embed/pqgHHigIW5g
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]