· 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 195

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 155

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 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 309


I am having an issue when I am publishing data to FHIR which is hosting in AWS. I am sending the data to the Cloud FHIR url but getting the below error.

Any idea how to resolve this issue? Any example to cretae FHIR repository using Object script?

:<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN"> <html><head> <title>404 Not Found</title> </head><body> <h1>Not Found</h1> <p>The requested URL was not found on this server.</p> </body></html>

0 2
0 77