i am trying to generate a view that shows me all tickets which are open for 1,2,3,4 hours.
At the moment my query is:
flag=true and open.time>date(tod())-'00 02:00:00' and status~="Resolved" and security.id=.....
Somehow open.time>date(tod())-'00 02:00:00' does show Tickets which are open less than 2 hours.
What am i doing wrong here?