Synapse Table: syn21994974
Notes:
- Projects are Analyses of one or more Studies, and will link to those studies
- Need to select entries based on dhPortalIndex = 'TRUE' and isDHProject = 'TRUE'
- Need to sort based on ORDER BY 'study'
- Wiki text may come from main project wikis and subpages (in contrast to other projects in which they come from folder and file wikis)
| Display Name | Column Name | Facet Y/N | UI Mapping | Destination | Searchable Y/N | Search hint text | Notes |
|---|---|---|---|---|---|---|---|
| id | Link out to this project | ||||||
| dataCollectionMethod | N | Secondary_Label_6 | |||||
| dataUsed | N | Secondary_Label_9 | Link to Study pages | Use this to name and link to Studies used for this Project, Combine with 'externalDataUsed' as necessary. | |||
| deviceType | Y | Secondary_Label_4 | |||||
| dhPortalIndex | Use this to filter studies/projects for portal | ||||||
| diagnosis | Y | Secondary_Label_1 | Y | e.g. Parkinson's | |||
| digitalAssessmentCategory | Y | Secondary_Label_7 | Y | e.g. tremor | |||
| digitalAssessmentDetails | N | Secondary_Label_8 | Y | e.g. walking | |||
| intervention | Y | Secondary_Label_2 | Y | e.g. levodopa | |||
| investigator | Secondary_Label_10 | Y | e.g. LastName | ||||
| isDHProject | Use this to filter projects for portal = 'TRUE' | ||||||
| keywords | Secondary_Label_11 | Y | e.g. neurodegeneration | ||||
| Clinical or Phenotypic Assessment | reportedOutcome | Y | Secondary_Label_3 | Y | e.g. MDS-UPDRS | ||
| resourceType | Y | Card_Subtitle | |||||
| sensorType | Y | Secondary_Label_5 | |||||
| Project Name | study | Card_Title | link to wiki | Y | e.g. mPower | ||
| Project Description | studyDescriptionLocation | link to wiki | N | Full Project description for Project page | |||
| studyDescription | Card_Description | ||||||
| externalDataUsed | Secondary_Label_9 | Link externally using markdown | Combine with 'dataUsed' as necessary. |
Project Detail Page
Project Detail pages retrieve data from multiple tables.
Project Name (study), and Project Description come from Study/Projects table.
Data from other sections come from the Digital Health Data File View and Digital Health Publications tables.
The configuration for each section with example queries is shown here:
| Field | Column Name | Location | Project Information (example) | Note |
|---|---|---|---|---|
Project Name | study | study card header | Participant Retention in Digital Health Studies | Link to id in Synapse |
| Project description | studyDescriptionLocation | study card body | Pull content from wiki link | |
| Data files | study page body, table | select * from syn21994970 where ((dhPortalIndex = 'TRUE') AND (projectId = 'syn20715364')) | ||
| Publications | study page body, as cards | SELECT * FROM syn22017695 WHERE synID HAS ('syn20715364') |
Add Comment