Versions Compared

Old Version 8

changes.mady.by.user Brian White (Unlicensed)

Saved on

compared with

New Version Current

changes.mady.by.user James Eddy (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Source data

Synapse Table: https://www.synapse.org/#!Synapse:syn21918972/tables/

DEPRECATED Synapse File View: https://www.synapse.org/#!Synapse:syn10142562/tables/

...

Explore page config

Type / name of card: "Grants"

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

Column Type

Link Format

Facet Y/N

Facet Order

Card UI Mapping

Destination

Link Query Key

Link Value Column

Searchable Y/N

Search

hint text

Order

Search Hint Text

Grant Name

grantName

STRING

portal query

N

Card_TitleLink

NA

title

Grants/DetailsPage

grantId

grantId

Y

1

e.g. immunity


grantId

ENTITY


N

NA





N

NA


Grant Number

grantNumber

STRING


N

Secondary_Label_2

NA

secondaryLabels[1]




Y

5

e.g. CA202123

Consortium

consortium

STRING


Y

Secondary_Label_3Y

1

secondaryLabels[2]




N

NA

e.g. PS-ON

Key

Investigators

Investigators

keyInvestigators

STRING_LIST*


N

Secondary_Label_1

NA

secondaryLabels[0]




Y

4

e.g. LastName

Institution

institution

STRING_LIST*


N

Card_SubTitle

NA

subTitle




Y

3

e.g. Vanderbilt

Link

Abstract

grantId

abstract

N

LARGE_TEXT


N

Abstract

NA

abstractY

description

NCard_Description




Y

2

e.g. metastasis

Grant Type

grantType

STRING


Y

Secondary_Label_4

2

secondaryLabels[3]




N

NA

e.g. U54

...

*<TYPE>_LIST columns for multi-value annotations not yet implemented

...

Details page config

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:

...

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'

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'