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 DAY)
On Mon, Aug 25, 2014 at 4:03 PM, 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::NeedAccountedTime - Yes)
I’m trying to produce a report covering the last week showing time per project (totals) and time per project broken down by ticket, listing clientID, ticket#, subject and project.
Firstly, I have no idea how to do this :( I’ve had a play around with the stats generator to no avail. I’m not even sure if I should be using TimeAccounting or TicketAccountedTime..
Secondly, I’m not sure how to display just time for the last 7 days (some tickets remain open for several weeks and can accrue upwards of 30-40 hours work)
If anyone has done this I’d love to have a chat. If anyone can provide support in getting this setup I’d be happy to pay for a little training…
Will Sheldon IT Manager Office:604 568 0313 x114 Fax:604 568 0314 Cell:778 689 1244 Skype:will.sheldon http://skype.appno.net/?skype=will.sheldon&user=will #300-152 West Hastings Vancouver, BC, V6B 1G8 Canada www.appnovation.com
Click here to unsubscribe from further Appnovation communications.
--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
