Query and Report Centre
From CTRNet Wiki
This page will be used to share common reports and queries developed by ATiM users. The SQL for queries and reports needed to make changes to your database tables and create new forms will be provided by download through this wiki. Additionally, this site provides a forum for developer's who have created their own queries, and would like to share the SQL for these new queries for all ATiM users.
Common queries allow you to capture information stored in ATiM in a meaningful way. These queries would capture information:
- Banks
- Participants
- Collections
- Diagnoses
- Aliquots
- Samples
- Events
The Difference between queries and reports
A query might include checking all the participants at a biobank who developed CLL, and also smoked in excess of 20 Pack years prior to diagnosis. The characteristics of this query are: • Highly focused (low level) • Returns a very limited and specific data volume • Will usually not save the information anywhere – but should be able to
A report may require total number of diagnoses of CLL patients recorded by bank/by year. The characteristics of the report are: • Will require the use of aggregate functions • Will usually return a large volume of data • Will often be used to view patterns over time
* Queries and Reports will be exportable to .csv files
