maximus1974
asked on
Need guidance on how to change font color using CSS
I want to change the font color of a row to white when an order is Priority = 1 with the database. I assume I will accomplish this by using CSS.
I am using third party that came with our ERP which displays dashboards. Can anyone point me in the right direction on how
to accomplish this? below is the complete sql statement I am using to display results in the dashboard. Also attached a screenshot of how the
results are displayed.
I am using third party that came with our ERP which displays dashboards. Can anyone point me in the right direction on how
to accomplish this? below is the complete sql statement I am using to display results in the dashboard. Also attached a screenshot of how the
results are displayed.
SELECT WO_NUMBER AS WONUM
,PART_NUMBER AS PN
,DESCRIPTION AS DESCR
,PRIORITY
,CASE CONTRACT_TYPE WHEN 'PBH Pool' THEN 'PBH' ELSE 'TM' END AS CONTRACT
,DAYS_OPEN AS TAT
,CASE WARRANTEE_FLAG WHEN 'F' THEN ' ' WHEN 'T' THEN 'W' END AS INFO
,TECHNICIAN AS TECH
,case when days_open > 5 or priority >= 1 then '#ff0000' else case when days_open > 3 then '#f68835' else '#66b65d' end end row_color
FROM BA_VIEW_WIP_SHOP_SCREENS
WHERE STATUS IN ('OPEN', 'AWT SHOP EVAL', 'SHOP EVALUATION') AND SHOP = 'SH AVIONIC ARO'
order by days_open desc
Capture.PNG
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.