Due date searching

RT Users
#1

Hello All,

Instead of answering a question I’m going to ask one :wink:

I searched my archive of rt-users but couldn’t find what I was looking
for so here it comes.

I have started using RT-Extension-SLA and have ofcourse lots of tickets
where the due date is not set. The problem is I wanted to create a
dashboard that shows all over due tickets but the simple search
DUE<today shows not only my overdue tickets but also all tickets with a
due date which is not set.
Q: is there a way to filter these out?

Thanks in advance,

Joop

#2

Hello All,

Instead of answering a question I’m going to ask one :wink:

I searched my archive of rt-users but couldn’t find what I was looking
for so here it comes.

I have started using RT-Extension-SLA and have ofcourse lots of tickets
where the due date is not set. The problem is I wanted to create a
dashboard that shows all over due tickets but the simple search
DUE<today shows not only my overdue tickets but also all tickets with a
due date which is not set.
Q: is there a way to filter these out?

Try “and Due > ‘1970-01-01 00:00:00’”

-kevin

#3

Kevin Falcone wrote:> On Thu, Oct 06, 2011 at 09:38:46AM +0200, Joop wrote:

Hello All,

Instead of answering a question I’m going to ask one :wink:

I searched my archive of rt-users but couldn’t find what I was looking
for so here it comes.

I have started using RT-Extension-SLA and have ofcourse lots of tickets
where the due date is not set. The problem is I wanted to create a
dashboard that shows all over due tickets but the simple search
DUE<today shows not only my overdue tickets but also all tickets with a
due date which is not set.
Q: is there a way to filter these out?

Try “and Due > ‘1970-01-01 00:00:00’”

Thanks that works a treat.

Regards,

Joop