Title: IRIS DBA

Location: pleasanton,ca remote work from united states only

Duration:12+months

Skills: intersystems Iris, cache and health care background

Hi community,

I need to write an SQL query with hierarchical order, I have a table with a column referencing itself, similar as the sample bellow:

I created a Custom Business Service to receive a multipart message with a file and I need to save only the file, not all message. How Can I extract only the file from the pInput to save in a File? This is my code:

Someone have experience consuming special wss ?

I need generate this values on Iris :

<dsig:DigestValue>

<dsig:SignatureValue>

you can see an example here :

https://github.com/Axway/axway-open-docs/blob/master/conversion_outputs/apigw_polref/content_sign_message.md

for any help, Thanks in advance

Hi Everyone!

New session recording from Global Summit 2018 is available on InterSystems Developers YouTube Channel:

High Availability and Disaster Recovery

https://www.youtube.com/embed/ak9tV5pZaAM
[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]

Hello,

I have a series of data organized by time (year and month) so I can use a time dimension to drill down data. So far so good.

However, I need to display the data not by calendar years and months but rather by seasons. The season has 12 calendar months but starts in September. So I'd like to see the data from September / Year N to August / Year N+1 using the same hierarchy as normal time dimension.

Has anyone done something similar?

Obviously, the season can start by any month, not only September :)

TIA!

InterSystems FAQ rubric

You can check the free disk space at any time using the system utility class: SYS.Database and query: FreeSpace.

Hi Community,

We're pleased to invite you to the upcoming webinar in Hebrew:

👉VS Code - Beyond the Basics 👈

📅 Date & time: February 6th, 3:00 PM IDT

https://www.youtube.com/embed/uT5sqSwtF0k
[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]

Hello,

I have a method in an operation wich return a list of %String (listId).
I call it multiple time in a Business Process and want to have all the lists I get put into one.
Not having "set context.listIdProcess = callresponse.listId" , but a way to add the elements of listId in context.listIdProcess.

There is an other way than append each element of the list?

Thanks for yours answers,

Corentin

The power of the presented tool becomes visible with a large JSON file.
The example I have prepared is composed of the daily results of AoC 2023.
Anonymization makes it usable for demo purposes.

Have a Zen report with a huge query that we are trying to break down and be more efficient.

Looks like Zen only wants to take a result set class as the data (or XML, but writing to a file to generate these reports is probably even more overhead).

Is there a way I can move through a result set object, delete rows I don't want based on some objectscript commands and the pass that to the report?

Or can I pass a dynamic object?

Thanks.

Why when I use a SQL on the Cache, the condition between "the expression" and "the expression", not permite to me, delete the all ID of this data class?

Hi Developers,

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

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

🥇  @Sergey Mikhailenko, Chief Specialist, AO Mosvodokanal, Russia

🥈  @YURI MARX GOMES, Software Architect, YM Services, Brazi

🥉 @Nigel Salm, Senior Systems Architect at Health System Technologies, South Africa

Learn more about the competition and our awesome winners below.

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.