...
- 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)
...
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') |