/bundles/itninjaweb/img/Breadcrumb_cap_w.png
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   [ - ] Hide 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.
Answer this question or Comment on this question for clarity

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