1 Reply Latest reply on May 9, 2017 5:55 PM by kellytice

    Report for Tickets Older than 30 Days

    m_k

      Hi all. I need help creating a report that shows all the tickets that have been open for 30 days or longer. I can't seem to figure this out. Any ideas?

       

      Thanks

        • Re: Report for Tickets Older than 30 Days
          kellytice

          I don't think you can do that with a report since it doesn't look like Reports have a filter on "date opened".

           

          You should, however, be able to craft a query to pull that info.   You could give your query a name and save it, then run it whenever you'd like.

           

          Something like this:

           

          In this case i went to Tickets -> Search Tickets -> Advanced Search and chose these fields (as an example):

                    Date     Opened     prior to     1     Month     ago

                    Status     is     Open

           

          whd search for tickets open longer than 30 days.png

           

          and this is what i was meaning about if you save the query with a name, you can later choose it and run it ad hoc from a 'regular' view like My Tickets or Group Tickets:

          whd search for tickets open longer than 30 days 2.png

          ...then you would just clear that query field to go back to the normal view.