Query Editor Help / Example Needed
Hi
Once a call is created on SupportCentre Plus, any work on the call whether it be engineer notes, dial-in details, etc gets placed in the 'Time Entry' section. Even if an email conversation is taking place, the fact that an email has been sent/received is also noted here (after all, some emails can take 10+ mins to compile so it is important to log).
I wish to be able to get a report on any call which hasn't had a new 'Time Entry' for 'X' amount of time (completely arbitratry - I'd create one for an hour and one for a number of days I expect) - this way we can see at a glance which calls are being neglected.
The 'Last Updated' field doesn't help as a Time Entry addition doesn't update this. I also cannot find a way of doing this with a standard report.
Can I do what I want with the Query Editor? If so, could someone possibly post an example?
Many thanks in advance..
Cheers, James
Once a call is created on SupportCentre Plus, any work on the call whether it be engineer notes, dial-in details, etc gets placed in the 'Time Entry' section. Even if an email conversation is taking place, the fact that an email has been sent/received is also noted here (after all, some emails can take 10+ mins to compile so it is important to log).
I wish to be able to get a report on any call which hasn't had a new 'Time Entry' for 'X' amount of time (completely arbitratry - I'd create one for an hour and one for a number of days I expect) - this way we can see at a glance which calls are being neglected.
The 'Last Updated' field doesn't help as a Time Entry addition doesn't update this. I also cannot find a way of doing this with a standard report.
Can I do what I want with the Query Editor? If so, could someone possibly post an example?
Many thanks in advance..
Cheers, James