Update study cards data query

Description

As an interim solution until https://sagebionetworks.jira.com/browse/PORTALS-1314 gets resolved:

  • Update Data query in study cards to something like: SELECT dataType, assay, COUNT(id) AS Files FROM syn20821313 WHERE (dataSubtype <> metadata OR dataSubtype IS NULL) GROUP BY 1, 2 ORDER BY 3 DESC AND ”study” HAS 'BrainGVEX'

I updated the schema to reflect this.

This is intended to be the same implementation currently in the AD Knowledge portal.

Environment

None

Activity

Show:
Jay Hodgson
September 11, 2020, 10:38 PM

Oh I see! For example, on the "BrainGVEX" study page you would see these tables?

Kelsey Montgomery
September 11, 2020, 11:47 PM

That will be perfect once my PR is merged as well - the query for METADATA should have metadataType instead of dataSubtype. Here is the query in Synapse. Strangely, adding “dataType as “Data Type”” into the query breaks it: see here.

Jay Hodgson
September 12, 2020, 12:12 AM

: Could you review this once the change rolls out to staging?

Jay Hodgson
September 12, 2020, 12:57 AM

After looking into this, it's very full of bugs due to the client sql parsing issues.
Will revert the sql to the original, and resolve this as Won't Fix, and instead focus our effort on bringing Explore 2.0 here.

Jay Hodgson
September 12, 2020, 1:13 AM

Assignee

Jay Hodgson

Reporter

Kelsey Montgomery

Labels

Validator

Kelsey Montgomery

Development Area

Portals

Release Version History

None

Priority

Major
Configure