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.
Oh I see! For example, on the "BrainGVEX" study page you would see these tables?
: Could you review this once the change rolls out to staging?
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.