tulip/ppe-logistics

MiamiMedCOVIDHelp Dashboard showing workcenter IDs instead of names

Closed this issue · 2 comments

ianslai commented

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

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

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.