Changes between Version 9 and Version 10 of EpochFieldPlugin
- Timestamp:
- Apr 8, 2012, 3:16:27 AM (12 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
EpochFieldPlugin
v9 v10 26 26 == Example == 27 27 === epoch field === #field 28 trac.ini(or use CustomFieldAdminPlugin):28 specify '''format=epoch''' for the custom-field in trac.ini as follows(or use CustomFieldAdminPlugin): 29 29 {{{ 30 30 [ticket-custom] … … 37 37 38 38 === epoch report === #report 39 in trac.ini :39 in trac.ini, specify field-names you want to translate from epoch to datetime-string in regular-expressions, as follows: 40 40 {{{ 41 41 [epochfield] … … 44 44 time_columns = .*_time, .*時刻 45 45 }}} 46 report query as: 46 47 and, for example, report query as: 47 48 {{{ 48 49 select id, summary, ticket.time, … … 62 63 ) AS c on (c.ticket = ticket.id and c.status = "closed") 63 64 }}} 65 then the epoch field (status change time in above example) shows as datetime string. 64 66 [[Image(report.png)]] 65 67