#Global Masters

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.

Hi Community,

We launched an integration between Open Exchange and Global Masters. Now, when you leave reviews for applications on OEX - you are getting points and badges automatically, no need for any extra steps! You get:

💰 200 points automatically for each published review on Open Exchange.

🏆 Bonus points and badges for a number of reviews:

Hey Developers,

We love Global Masters program for dynamic, fun and networking. We love that we can get to know you better and provide you with some valuable things.

We are excited to have more members in Global Masters, and we'd like to ask your help on that:

❔ Do you know other developers who work with InterSystems technology and would love Global Masters?

▶ Here's the dedicated GM Referral page where you can leave your colleague or co-worker contact details, or get your unique referral link - to send it yourself 😊

Dear Global Masters participants!

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

Last year we created a roadmap based on your responses and successfully introduced new gamification system to make higher levels more achievable, new rewards, and new types of challenges. Time to make your wishes for 2021, because this program is FOR you!

Please spend 5 min and answer 11 questions about Global Masters. We guarantee that we carefully consider every single comment.

➡️ Global Masters Survey 2020 (5 min)

Hey Developers,

Gartner Peer Insights launched a new incentive for reviews and we are glad to announce it for you. If you have not reviewed InterSystems IRIS on Gartner yet, here is your chance to make it and get two prizes:

1. 🎁 Three months free access to exclusive Gartner research from Gartner Peer Insights:

Your Peer Insights Plus access will get you the most respected research across IT, allowing you to make better decisions. You’ll get regular email alerts on vendors and updates on markets. And you’ll be able to search reviews by topic, compare unlimited numbers of vendors, and personalize vendor shortlists.

2. 🎁 $25 VISA Card from InterSystems

How it works:

Dear Global Masters Advocate Hub participants!

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

Hi Developers!

Recently we announced two new challenges on Global Masters: 'Bugs Bounty' and 'Pull Requests'.

And we are getting a lot of submits to the challenges which are not the thing we are expecting there. So I hope this post will give some shine to this quest.

'Bugs Bounty'

Ok! What are we expecting from 'Bugs bounty'?

There are a lot of Open Exchange solutions that come with public open-source repositories on Github: project and repo, another project and the repo, another one and its repo, and many more on Open Exchange.

Hey Developers!

Good news! Just in time for the holidays, Gartner Peer Insights is offering customers a $25 digital Visa Gift Card for an approved review of InterSystems IRIS or Caché this month!

We decided to support and double the stakes. So! In December '18 you can get the second $25 digital Visa Gift Card for Gartner review on Caché or InterSystems IRIS on InterSystems Global Masters Advocacy Hub!

See the rules below.

Hi Community!

We introduced a new tag for the posts:

Global Masters