Synapse Table: https://www.synapse.org/#!Synapse:syn10142562/tables/
...
Display Name | Column Name | Facet Y/N | UI Mapping | Destination | Searchable Y/N | Search hint text |
|---|---|---|---|---|---|---|
| Grant Name | grantName | N | Card_Title | Link | Y | e.g. immunity |
| Grant Number | grantNumber | N | Secondary_Label_2 | Y | e.g. CA202123 | |
| Consortium | consortium | Y | Secondary_Label_3 | Y | e.g. PS-ON | |
Key Investigators | keyInvestigators | N | Secondary_Label_1 | Y | e.g. LastName | |
| Institution | institution | N | Card_SubTitle | Y | e.g. Vanderbilt | |
| Link | grantId | N | N | |||
| Abstract | abstract | N | Card_Description | Y | e.g. metastasis | |
| Grant Type | grantType | Y | Secondary_Label_4 | e.g. U54 |
...
Additionally, we should display projects, publications, tools, and datasets associated with that grant. This should query those respective tables using grantName, i.e.,
...
SELECT * FROM syn10923842 where "grantName" = 'Quantitative and Functional Characterization of Therapeutic Resistance in Cancer'
tools:
SELECT * FROM syn21488853 where "grantName" = 'Center for Modeling Tumor Cell Migration Mechanics'
datasets:
SELECT * FROM syn18488466 where "grantName" = 'Center for Modeling Tumor Cell Migration Mechanics'
...