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 -~----------~----~----~----~------~----~------~--~---
