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 14 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/NFacet Order
UI Mapping
Destination
Searchable Y/NSearch OrderSearch hint text
Grant NamegrantNameNNACard_TitleLinkY1e.g. immunity
Grant NumbergrantNumberNNASecondary_Label_2
Y5e.g. CA202123
ConsortiumconsortiumY1Secondary_Label_3
NNAe.g. PS-ON
Key Investigators
keyInvestigators
NNASecondary_Label_1
Y4e.g. LastName
InstitutioninstitutionNNACard_SubTitle
Y3e.g. Vanderbilt
LinkgrantId

N

NA

NNA
AbstractabstractNNACard_Description
Y2e.g. metastasis
Grant TypegrantTypeY2Secondary_Label_4
NNAe.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'


  • No labels