Ticket Custom Views with relative dates
I need to be able to filter tickets to those with a Due Date less than Today (ie overdue) and a Modified Date 2 weeks or more before Today. I can’t work out how to code a Custom View to do this; I've tried TODAY or NOW in the field as a guess but no soap.
0 Comments
[ + ] Show comments
Answers (3)
Please log in to answer
Posted by:
GillySpy
12 years ago
You cannot use relative dates in the helpdesk filters. You can vote for this here: http://kace.uservoice.com/forums/82699-k1000/suggestions/2146287
Posted by:
Acedashdog
12 years ago
Thanks Gilly.. I went there to do that and found someone else already had!
Posted by:
Acedashdog
12 years ago
Urmmm
Not quite the same question but ... is it possible to filter tickets for ones shown as Overdue?
It's displayed in the list but I can't find a way of filtering for it.
Alternatively, I see in some ticket rules's there a calculation that does something like this
if((datediff(DUE_DATE, now()) = 0), 2, if((datediff(DUE_DATE, now())<0), 1, 3)) as SORT_OVERDUE_STATUS
Can this be modified to update a custom field with a flag for Overdue yes or no? That would solve the problem, as I could Custom View on that and sort by modified, and there would be my tickets for possible close no response processing. Or can I filter directly on the SORT_OVERDUE_STATUS field, whereever that comes from?
Not quite the same question but ... is it possible to filter tickets for ones shown as Overdue?
It's displayed in the list but I can't find a way of filtering for it.
Alternatively, I see in some ticket rules's there a calculation that does something like this
if((datediff(DUE_DATE, now()) = 0), 2, if((datediff(DUE_DATE, now())<0), 1, 3)) as SORT_OVERDUE_STATUS
Can this be modified to update a custom field with a flag for Overdue yes or no? That would solve the problem, as I could Custom View on that and sort by modified, and there would be my tickets for possible close no response processing. Or can I filter directly on the SORT_OVERDUE_STATUS field, whereever that comes from?
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.