![]() ![]() You might want to add this then, but it is a wild shot really:SELECT ost_ticket.number AS "Ticket Number", ost_ticket_cdata.subject AS "Subject", ost_user.name AS "Created By", CONCAT(ost_staff.firstname," ", ost_staff.lastname) AS "Agents Name", SUM(ost_thread_entry.time_spent) AS "Time Spent", CONCAT("",ost_ticket.ticket_id) AS "Link" FROM ost_ticket LEFT JOIN ost_staff ON ost_ticket.staff_id=ost_staff.staff_id, ost_thread_entry, ost_thread, ost_ticket_cdata, ost_user WHERE ost_ticket.ticket_id=ost_thread.object_id AND ost_thread.id=ost_thread_entry.thread_id AND ost_ticket.ticket_id=ost_ticket_cdata.ticket_id AND ost_er_id=ost_user.id AND ost_ticket.created>='' AND ost_ticket.created<='' AND ost_user.name='Full Name' AND ost_ticket.status_id IN ('1','2') GROUP BY ost_ticket.ticket_id Remove or add the extra number depending what you need:+-+-+-+| id | name | state |+-+-+-+| 1 | Open | open || 2 | Resolved | closed || 3 | Closed | closed || 4 | Archived | archived || 5 | Deleted | deleted || 6 | Faulty Unit returned | open || 7 | AR sent | open || 8 | Monitoring | open || 9 | Feature Request | open |+-+-+-+ Hello how did you delete the ticket? Because if you delete it using the facility, it removes the entry from the database table. Please do change the orange highlighted part to your osticket URL. I have added another feature, it will give you html link, so you can view the ticket by clicking on it. Hello for the long wait, something came up :) But here you got the revised query, had few mistakes here and there, now it will actually show everything, well, at least it should SELECT ost_ticket.number AS "Ticket Number", ost_ticket_cdata.subject AS "Subject", CONCAT(ost_staff.firstname," ", ost_staff.lastname) AS "Agents Name", SUM(ost_thread_entry.time_spent) AS "Time Spent", CONCAT("",ost_ticket.ticket_id) AS "Link" FROM ost_ticket LEFT JOIN ost_staff ON ost_ticket.staff_id=ost_staff.staff_id, ost_thread_entry, ost_thread, ost_ticket_cdata WHERE ost_ticket.ticket_id=ost_thread.object_id AND ost_thread.id=ost_thread_entry.thread_id AND ost_ticket.ticket_id=ost_ticket_cdata.ticket_id AND ost_ticket.created>='' AND ost_ticket.created<='' GROUP BY ost_ticket.ticket_id The bold part controls the date range modifier. It also takes staff who is currently assigned to the ticket, it does not take into account hours spent by other agents.Without few extra VIEWS, complex`y queries, it will be hard to do what you want, e.g., calculate time spent per agent on one ticket. Stuck in some distant place where an Edge network is all your phone has access to? No time tracking.Hello, here is quick SQL query, you could make it better of course :)SELECT ost_ticket.number AS "Ticket Number", CONCAT(ost_staff.firstname," ", ost_staff.lastname) AS "Agents Name", CONCAT(FLOOR(HOUR(TIMEDIFF(ost_ticket.created, ost_ticket.lastupdate)) / 24), ' days ', MOD(HOUR(TIMEDIFF(ost_ticket.created, ost_ticket.lastupdate)), 24), ' hours ', MINUTE(TIMEDIFF(ost_ticket.created, ost_ticket.lastupdate)), ' minutes') AS "Created to Last Update time" FROM ost_ticket, ost_staff where ost_ticket.staff_id=ost_staff.staff_id What does it do, it calculates difference between created time and last update, headers include: | Ticket Number | Agents Name | Created to Last Update time |Please do note it does include time such as weekends, bank holidays, etc, thus take these values at face value, if you have support which works 24/7 then it is good enough. Working in a secure location with no access to the outside world? No time tracking. macOS, iOS, android, Windows, web, there’s something for everyone, except if you don’t have access to the internet. ![]() Timely offers native apps for every device you’re like to put your hands on. A new Dashboard feature (which was released during this review) provides a broad overview of who you worked for, what you worked on, and how much you made in a selected window of time. Timely’s reporting features are pretty good too and improving all the time. You can easily change client information after you’re done. Simple as that and you’re tracking billable time. ![]() New timers are created with a tap or click on Timely’s calendar to create an event, then you start the timer. Memory Tracker runs in the background on your Mac or PC and privately tracks every app you’re using and for how long. You can use it to create billable time, even if you forget to kick off a timer when you’re working for a client. At the top of the magical list is Timely’s Memory Tracker, which is an app that runs in the background on your Mac or PC and privately tracks every app you’re using and for how long. I really like using it and it has some magical features.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |