Data Querying Tool

HOME > SETUP > DATA QUERY TOOL

The Data Query Tool is an open-source extension of LORIS which enables users to query and download datasets. Front-end users can design and store queries to extract any data available in LORIS, including imaging data.

Installing the Data Query Tool:

Please see the Data Query Tool Readme (in beta) for installation instructions. Detailed instructions for some systems are available in the DQT repository wiki

Loading the Data Query Tool:

Custom php scripts are provided in the LORIS codebase for loading data into the Data Query Tool.
Before attempting to load data into the Data Query Tool, the Data Dictionary must be generated.

In your LORIS tools/ directory, run the CouchDB_Import_* scripts to import each type of data :

• Base candidate data : CouchDB_Import_Demographics.php : Imports the base candidate data, run first

• Instrument data : CouchDB_Import_Instruments.php - omit if Behavioural data not used

• Imaging (MRI) data : CouchDB_Import_MRI.php - omit if Imaging data not used

• Radiological review module data : CouchDB_Import_RadiologicalReview.php - omit unless module in use

cd /var/www/$projectname/tools php CouchDB_Import_Demographics.php php CouchDB_Import_Instruments.php php CouchDB_Import_MRI.php php CouchDB_Import_RadiologicalReview.php

The MRI import script may require some editing or configuration to find the exact path for all imaging data.  Selected mincs may should be populated for the appropriate session under the field "Selected_$SCANTYPE" e.g. Selected_t1.  Files should then be available for download under the "View Data" tab either by clicking the link after running the query, or clicking on "Download all as zip" button.

CouchDB_Import_*.php scripts are provided in the tools/ directory to push Demographic, Instrument, MRI and Radiological Review data from LORIS into the DQT. Note that CouchDB_Import_Demographics.php must be run first. 

### Help
A User Guide is available within the DQT's Help section, by clicking on Question Mark icon in top menu bar.