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
Front End (Recommended)
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%");