Greenplum Query results to Email HTML table

Greenplum Query results to Email HTML table - Printable Version

+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: General Coding Help (https://python-forum.io/forum-8.html)
+--- Thread: Greenplum Query results to Email HTML table (/thread-9466.html)

Greenplum Query results to Email HTML table - krux_rap - Apr-10-2018

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

RE: Greenplum Query results to Email HTML table - Larz60+ - Apr-10-2018

Quote:I'm trying to send email results from Greenplum query as HTML table with status Red/Green

Ok, what have you tried?
where are you having problems
Show the code you have written so far and where you think the problem lies.