how-to Creating a widget for tickets due to breach in next 2 days

[Joyce]

Hi @Bob Dickinson

 

I have seen a similar post for creating ' about to breach' tickets on widget. I don't seems to be able to comment on it.

 

I want to create a widget with count, and another with list of tickets which are about to breach in the next 2 days and are for specific tier tickets, own by a specific team . I have currently, i have the below query, but i get 0 while there are some tickets which are due to breach in the next 2 days:

 

How can I get the correct value? i think the problem is on the 'h_fixby' date filter

Thanks.

Regards,

Joyce

 

[Dan Munns]

@Joyce try this (with your filters):

h_requesttype = 'incident' AND DATE(h_fixby) BETWEEN DATE (CURDATE()) AND (CURDATE() +2)

 

[Joyce]

1 hour ago, Dan Munns said:

AND DATE(h_fixby) BETWEEN DATE (CURDATE()) AND (CURDATE() +2)

great it works! thanks @Dan Munns

[Guest]

....I was just about to say that! Thanks @Dan Munns 

[Joyce]

Great thank @Dan Munns. It worked

[Dan Munns]

@Bob Dickinson @Joyce No worries. @Victor must be glad I didn't have to bug him about it (for once) 

[Victor]

@Dan Munns ...