Build 172, which requires server 0.0.52, marks the start of the implementation of custom reports. This build allows you to query patient, diagnosis, results, and medication tables in a single report. An example is given how to perform the following query
Find all females over the age of 50 with a ICD9 diagnosis of uncontrolled diabetes with an HbA1c greater than 7.5% with their last test being before 1st Jan 2006.This query is generated using the QBE GUI editor. More complex enquiries are likely to be encoded for you to save you the time of creating them yourself. In the long term we hope to provide all the queries you need to satisfy P4P reporting requirements.
There is a caveat in that any complex queries will, when there are large numbers of records, tie up the database server so no other Synapse user can do anything until the query has been completed. This is a result of client database architecture. So, when you have large numbers of patients ( over a few thousand ) and results, it is best to leave performing such queries until the system is not being used by others.