The Log should display date information

[Christopher Adams]

Currently the Log on the Owner Dashboard displays a list of recent log entries.

Each list item should be modified to make the date of the log accessible. Need to discuss how. Simply adding the date on the same line will make the log entries too long. Perhaps hovering over the log brings up a tooltip.

[rejon (rejon)]

chris is the log master.

[Christopher Adams (christopheradams)]

Useful code snippet:

<span class='' style="font-size:0.85em;font-style:oblique;">(sql(
        (SELECT FLOOR(TIMESTAMPDIFF(Day,'((created&#95;at))',NOW())) AS DiffDate
            ||[-[DiffDate]-])
      )sql) days ago</span>

[Christopher Adams (christopheradams)]

Here is a good trick:

Use the above select statement to call another widget:

(#(inherit:311|SELECT FLOOR(TIMESTAMPDIFF(Day,'((created_at))',NOW())) AS DiffDate)#)

And in that widget put the content as:

((DiffDate)) <php if ((DiffDate)) = 1 then day else days php> ago