search

tulip / ppe-logistics

Issue Tracking for PPELogistics.org
2 stars 1 forks source link

MiamiMedCOVIDHelp Dashboard showing workcenter IDs instead of names #183

Closed ianslai closed 4 years ago

ianslai commented 4 years ago

Per Megan Matthew:

For some reason, one of our institutions is coming up like this in the Dashboard, it looks fine on the Tulip end of things though. It's called "holy cross Hospital"

image (1)

This is in the Executive Summary: https://www.ppelogistics.org/supplier/mmch/dashboard/01

ianslai commented 4 years ago

This is indeed due to the workcenter ID/name refactor.

To fix this, edit the GS dashboard - PROD data source and change the SQL to return the wcname.

Specifically, change line 2 from

    demandcenter AS customer,

to

    workcenters.wcname AS customer,
contextref commented 4 years ago

Fixed. I checked other pages of the report, they seem fine. There are a couple of data sources that still return the old column but they are not used in the active parts of the report.