9.4. Standard site queries
The site administrator can create a library of queries that every researcher can use.
Common “standard” queries might include:
how many patients are in the de-identified database?
when was the database last updated?
when were the associated NLP tables last updated?
These queries can have placeholders, marked out by double square brackets.
For example, the administrator might enter this query:
SELECT * FROM anonymous_output.ace WHERE brcid = '[[brcid]]'
and give it a title of “Look up ACE values for a given patient”. When the user runs this query, they are asked to fill in the blank in an HTML form:
SELECT * FROM anonymous_output.ace WHERE brcid = '__________'
and after they’ve entered a brcid
value of XYZ
, the query that will be
run is
SELECT * FROM anonymous_output.ace WHERE brcid = 'XYZ'