I don't know query extract date in db. but you can try this plugin. track ticket or wiki page change http://trac-hacks.org/wiki/AnnouncerPlugin
On Oct 6, 5:52 am, tex <[email protected]> wrote: > Hello. > > I made following custom query that enables me to track task&story > owner changes. But problem is, that I don't know how to extract date > from time field. I saw some examples with strftime for trac, but this > function does not exist in mysql. How can I change query so that > change date is included? > > Query: > select t_s.id, t_s.summary, t_s.type, CONCAT(ifnull(if(t_c.oldvalue! > ='', t_c.oldvalue, 'none'), 'none'),' -> ',t_c.newvalue) AS > 'owner_change', t_s.owner AS 'current_owner', tc_s.value as > 'current_sprint' > from ticket t_s > join ticket_change t_c on t_s.id = t_c.ticket > join ticket_custom tc_s on t_s.id = tc_s.ticket > where (t_s.type = 'story' or t_s.type = 'task') > and t_c.field = 'owner' > and tc_s.name='sprint' > > Env: > Agilo PRO 1.0.2 > Trac: 11.5 > Mysql: 5.x --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Agilo for Scrum" group. This group is moderated by agile42 GmbH http://www.agile42.com and is focused in supporting Agilo for Scrum users. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/agilo?hl=en -~----------~----~----~----~------~----~------~--~---
