Apr-10-2018, 04:24 PM
Hello,
I'm trying to send email results from Greenplum query as HTML table with status Red/Green
Select Server, Last_Date from Table;
Query Results
Server, Last_Date
Prod, 2018-04-09
Final email Output in HTML Table
Server Status LastDate
Prod GREEN(BOX) 2018-04-09 (if the date is within 24 hours) - Green color status
UAT RED (BOX) 2018-04-08 (if the date not within 24 hours) -- Red color Status
Thanks
I'm trying to send email results from Greenplum query as HTML table with status Red/Green
Select Server, Last_Date from Table;
Query Results
Server, Last_Date
Prod, 2018-04-09
Final email Output in HTML Table
Server Status LastDate
Prod GREEN(BOX) 2018-04-09 (if the date is within 24 hours) - Green color status
UAT RED (BOX) 2018-04-08 (if the date not within 24 hours) -- Red color Status
Thanks