Question
· Oct 28, 2023
escape bracket in SQL

I've written a stored procedure for SQL as follows. The second parameter is a search path that may use a single quote or bracket as part of its expression.

When the expression uses a single quote, I can double it within SQL, and it works well. In this example, 'testDate' is written as ' ' testDate ' ' .

Select HISOL_MEAS.SQLProc_JSONpath(fullAnnotation,'HbA1cTests.sort(''testDate'',false).resultValue') As reverseSortedTests

In the next example I'd like to use brackets (see below), which causes an error.

0 5
0 369

Hi Everyone,

Our next online Developer Roundtable will take place on September 28 at 9 am ET. Our experts will cover the topic:

  1. "Running IRIS workloads in the cloud (AWS, GCP, Azure): VMs or Containers, networking setup, availability, mirrors, backups", presented by @Eduard Lebedyuk , Senior Cloud Engineer, InterSystems

We will have time for Q&A and open discussion.

>> Watch the recording

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

3 3
0 384

Hey guys,

I do love Global Masters (and all the rewards that I get from it) and one of my favourite activities is answering quiz questions. And just now I've had a really cute question What is the result of: WRITE "99" + "cents"? which brought a smile to my face (because I do love to add questions like this to the tests for my students). This made me think that I would really like to somehow show my appreciation to the author of this question.

7 3
0 195

Hi Everyone,

Join us at the online Developer Roundtable to discuss Generative AI Use Cases in Healthcare on August 31, 10 am ET.
Learn Use Cases + Reference Architecture in Healthcare, and witness the demo of LLMs. We will have time for Q&A and open discussion as usual.

Speaker: @Nicholai Mitchko , Manager, Solution Partner Sales Engineer, InterSystems

Background: Nicholai runs a team of 10 solution engineers at InterSystems that help healthcare companies design, develop, and deliver solutions at enormous scale. In his free time, Nicholai works on large language models, including developing his own models which appear on the Huggingface OpenLLM leaderboard.

See the recording on our YouTube channel:

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

3 4
0 332

Hi Everyone,

Join the next online Developer Roundtable on July 27 to discuss how to optimize your dev practices. We'll have 2 short demos from our experts, time for Q&A and open discussion.

Invited experts:
@Timothy Leavitt , Development Manager, InterSystems
@Alex Woodhead, Senior Systems Developer, InterSystems
@Evgeny Shvarov, Senior Manager of Developer and Startup Programs, InterSystems

UPDATE: see the recording below or watch on YouTube

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

3 4
0 475

Hi Community,

If you wish to share with others your solution/tool and/or your company services which are connected to our products, we will be happy to organize a webinar for you to promote it. We will organize your webinar without any fuss on your side, you just need to tell us what you want to talk about and when you want to do it.

From its side, InterSystems team will:

4 0
0 165

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

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

🥇 @Robert Cemper, ex Senior Sales Engineer from InterSystems, Austria
🥈 @Luis Angel Pérez Ramos, Sales Engineer, InterSystems, Spain
🥉 @Pietro Montorfano , Systems Management Specialist, InterSystems, Italy

Learn more about the competition and our awesome winners below.

6 5
0 297

Hi Community,

We invite you to take part in the Health Data De-Identifier Early Access Program. Sign up, tell us your feedback and grab some nice points: 2000 to all participants, 5000 extra for completing the survey.

If you are interested:

1️⃣ Join EAP group via this challenge

2️⃣ Follow these instructions

3️⃣ Complete the survey (leave your email so we could award the points on Global Masters; please note: you must be EAP participant in order to proceed with survey completion)

3 0
0 180

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

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

🥇 @Muhammad Waseem, HIS Team Lead, International Medical Center, Jeddah, Saudi Arabia
🥈 @Luis Angel Pérez Ramos, Sales Engineer, InterSystems, Spain
🥉 @YURI MARX GOMES, Software Architect, YM Services, Brazil

Learn more about the competition and our awesome winners below.

7 8
0 236

Hi Everyone,
Do you know that April 22 was the Earth Day?
Join us in celebrating Earth Day on Global Masters - by learning about our efforts for sustainability and how you can drive change on a personal level.
There you will not only learn about ways to reduce your carbon footprint, but you will also have the opportunity to get some extra points for it. The campaign is live till April 30
It's also a good time to check the reward catalog - we added a couple of new prizes for several regions. Hope you will enjoy them!

1 0
0 102

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

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

🥇 @Muhammad Waseem, HIS Team Lead, International Medical Center, Jeddah, Saudi Arabia
🥈 @Robert Cemper, ex Senior Sales Engineer from InterSystems, Austria
🥉 @YURI MARX GOMES, Software Architect, YM Services, Brazil

Learn more about the competition and our awesome winners below.

6 3
0 321

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

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

🥇 @Muhammad Waseem, HIS Team Lead, International Medical Center, Jeddah, Saudi Arabia
🥈 @Heloisa Ramalho, Software Developer in the Application Services, InterSystems, USA
🥉 @Robert Cemper, ex Senior Sales Engineer from InterSystems, Austria

Learn more about the competition and our awesome winners below.

8 1
1 287

Save the date! March 16th, 9 am EST | 2 pm CET we will host the first Thursday Tea with Global Masters!

This is a 60-min fun & networking event, as well as a short update and Q&A about the Global Masters program.

>> Please prepare a short 1-2 min presentation about yourself for this event - even better with some pictures 📷 we will also make 5-min breakout rooms to discuss your favorite hobby.

RSVP in this challenge on Global Masters.

0 0
0 224

Hey Developers,

Enjoy watching the new video on InterSystems Developers YouTube:

Understanding your InterSystems Login Account & Where to Use It @ Global Summit 2022

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

2 3
0 252

Hi Developers,

Thank you for spending another great year with us on Global Masters. We hope you enjoy the program!

This is the moment you can share your thoughts about Global Masters. What do you like about it? What you'd like to change?

Time to make your wishes for 2023, because this program is FOR you💫

We will build a roadmap for 2023 based on your answers, and we will continue working hard to make it the best developer gamification program!

➡️ Global Masters Survey 2022 (5 min, 10 questions)

2 1
0 119
Announcement
· Feb 14, 2023
Community Roundtable: AI / ML

Hi Community,

We are gathering again for the next Community Roundtable. Many of you asked for a roundtable about AL / ML, and we are delighted to bring such a roundtable to you!

Our invited expert from InterSystems: @Thomas Dyar Product Specialist - Machine Learning.

Join our 60-min discussion, prepare your questions, and use cases! There will be a short demo as well.

UPDATE: the recording is available here.

6 5
0 328

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

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

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

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

Learn more about the competition and our awesome winners below.

7 5
0 253

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

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

🥇 @Cristiano.Silva , InterSystems Developer at First Line Software

🥈 @Iryna.Mykhailova , Associate professor, Igor Sikorsky Kyiv Polytechnic Institute

🥉 @Rob Schoenmakers , Integration specialist at SInt Maartenskliniek

Learn more about the competition and our awesome winners below.

5 3
0 253

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

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

🥇 @David Hockenbroch, senior analyst, WoodWare Systems, United States

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

🥉 @Dmitriy Maslennikov, Co-founder, CTO and Developer Advocate, CaretDev Corp, UAE

Learn more about the competition and our awesome winners below.

4 4
0 239