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 106

Hello there friends,

I am new to DC and I need to advance up my self.

I see that we get awarded with badges and so on through that process.

But i do not exactly get the idea of it.

I see that we have a challenge of becoming the insightful commenter and so on.

I would like some one to help me out with it so that i could get to the next level.


1 3
0 141

Hello there Community,

I am so pumped and curious about this platform.

The more I search about it, the more deeper it goes just as the maze.

I followed the following link https://community.intersystems.com/post/global-masters-advocate-hub-star... and it took me to a page where i learnt more on what Global Masters is and also more about the Advocate Hub.

But then I came across an very confusing this named as the Global Masters Gamification Platform.

1 3
1 287