Skip to end of banner
Go to start of banner

CSBC/PSON Grant Schema

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 12 Next »

Type / name of card: "Grants"

Synapse Tablehttps://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.

Display Name
Column Name
Facet Y/N
UI Mapping
Destination
Searchable Y/NSearch hint text
Grant NamegrantNameNCard_TitleLinkYe.g. immunity
Grant NumbergrantNumberNSecondary_Label_2
Ye.g. CA202123
ConsortiumconsortiumYSecondary_Label_3
Ye.g. PS-ON
Key Investigators
keyInvestigators
NSecondary_Label_1
Ye.g. LastName
InstitutioninstitutionNCard_SubTitle
Ye.g. Vanderbilt
LinkgrantId

N



N
AbstractabstractNCard_Description
Ye.g. metastasis
Grant TypegrantTypeYSecondary_Label_4

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 syn18483791 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'


  • No labels