[otrs] Report on time per project (dynamic field)

2014-08-25 Thread Will Sheldon
Hello all :) We have a dynamic field added to track project number (if this is the wrong way to add project accounting I’d be happy to know the correct way). We also have time units enabled and made mandatory (Frontend::Agent; Ticket::Frontend::AccountTime - Yes; Ticket::Frontend::NeedAccounte

Re: [otrs] Report on time per project (dynamic field)

2014-08-25 Thread Gerald Young
Hi Will, This might (?) be helpful. http://forums.otterhub.org/viewtopic.php?f=60&t=12546#p50624 If you're interested in tickets that have a dynamic field value, check out http://forums.otterhub.org/viewtopic.php?f=53&t=16009#p77686 WHERE create_time BETWEEN NOW() and DATE_SUB(NOW(), INTERVAL 7