Type / name of card: "Grants"
Synapse Table: https://www.synapse.org/#!Synapse:syn10142562/tables/
Number of secondary fields to display: 4
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.
Any column that should be faceted in the portal (i.e., faceted on an explore page or have a column facet on a table) must be faceted on the corresponding Synapse table/view. There is a performance penalty incurred with each additional facet – hence, facet only those columns needed by the portal and limit to those likely to be useful.
Display Name | Column Name | Facet Y/N | Facet Order | UI Mapping | Destination | Searchable Y/N | Search Order | Search hint text |
|---|---|---|---|---|---|---|---|---|
| Grant Name | grantName | N | NA | Card_Title | Link | Y | 1 | e.g. immunity |
| Grant Number | grantNumber | N | NA | Secondary_Label_2 | Y | 5 | e.g. CA202123 | |
| Consortium | consortium | Y | 1 | Secondary_Label_3 | N | NA | e.g. PS-ON | |
Key Investigators | keyInvestigators | N | NA | Secondary_Label_1 | Y | 4 | e.g. LastName | |
| Institution | institution | N | NA | Card_SubTitle | Y | 3 | e.g. Vanderbilt | |
| Link | grantId | N | NA | N | NA | |||
| Abstract | abstract | N | NA | Card_Description | Y | 2 | e.g. metastasis | |
| Grant Type | grantType | Y | 2 | Secondary_Label_4 | N | NA | e.g. U54 |
Detail pages:
Detail pages should display the above information (i.e., from the card) in the header/banner of the page. The query to get that information should be on this table using grantId and will look like this on the browser:
https://staging.csbc-pson.synapse.org/Explore/Grants?grantId=syn7416702
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 syn21599334 where "grantName" = 'Center for Modeling Tumor Cell Migration Mechanics'
publications:
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'
Add Comment