Link to home
Start Free TrialLog in
Avatar of maximus1974
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.

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

Open in new window

Capture.PNG
ASKER CERTIFIED SOLUTION
Avatar of Chris Stanyon
Chris Stanyon
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial