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

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
You cannot use relative dates in the helpdesk filters. You can vote for this here: http://kace.uservoice.com/forums/82699-k1000/suggestions/2146287
Answered 09/06/2011 by: GillySpy
Seventh Degree Black Belt

Please log in to comment
0
Thanks Gilly.. I went there to do that and found someone else already had!
Answered 09/06/2011 by: Acedashdog
Purple Belt

Please log in to comment
0
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?
Answered 11/14/2011 by: Acedashdog
Purple Belt

Please log in to comment
Answer this question or Comment on this question for clarity