Subprojects

Overview

Subprojects are defined in the front-end by the Configuration module, and are stored in the subproject table of the database. The Subproject plays an important role in determining the instrument battery that will be assigned to a candidate at a timepoint. The subproject can be used as a variable when determining which instruments are populated -- this allows for subproject-specific batteries to be defined in the test_battery table.

Adding Subproject Options

Subprojects are defined in the Configuration module, which can be found in LORIS under the Admin menu tab. Click on To configure study subprojects click here link at the top of the page. Refer to the help section of the module for further instructions on how to add or modify subprojects.

SQL

Subprojects can be added directly in SQL using the following command.

INSERT INTO subproject (title) VALUES('SCI');

API

not yet available. See API documentation for latest additions

Interaction With LORIS

Projects

Subprojects must be associated to at least one Project in order to be able to create timepoints for candidates. This association should be defined directly on the front end through the Configuration module.

Note: the only way to view a list of all the projects affiliated to a subproject is via the MySQL back-end.

Sometimes it's useful to add project-subproject affiliations directly in the MySQL back-end, for example when adding datasets to your LORIS. The following MySQL statement is provided as an example for linking already-defined subprojects with an existing project:

sql INSERT INTO project_subproject_rel SELECT p.ProjectID, s.SubprojectID FROM Project p, subproject s WHERE p.Name = "%PROJECT_NAME%" AND s.title IN("%SUBPROJECT_1%", "%SUBPROJECT_2%", "%SUBPROJECT_3%");