Type / name of card: "Grants"
...
Note that there is no explicit aliasing between Column Name and Display Name. Rather, camelCase Column Names are automatically rendered as Camel Case. The table below just makes that clear.
Facets should be ordered in the order they appear in this table.
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.,
projects:
SELECT * FROM syn18483791 FROM syn21599334 where "grantName" = 'Center for Modeling Tumor Cell Migration Mechanics'
...