Hello whoever you are that's reading this! This is my first post on the forum even though I have been using it for some time now. I figured it was about time I share some info that will hopefully help someone else and save them from struggling all day like I did!
Anywho below you will find the syntax for an advanced search to view all open issues within a particular project that are older than 30 or 60 days (-30d , -60d). This is a very useful feature for seeing all outstanding issues that are lingering in your que or backlog or maybe issues that have been resolved but were never closed by the technician/dev that worked them.
project = YOURPROJECTNAME AND status in ("In Progress", "On Hold", "Waiting for Customer", New, "Assigned - In Queue") AND resolution = Unresolved AND created <= -30d ORDER BY created DESC, priority DESC, updated DESC project = YOURPROJECTNAME AND status in ("In Progress", "On Hold", "Waiting for Customer", New, "Assigned - In Queue") AND resolution = Unresolved AND created <= -60d ORDER BY created DESC, priority DESC, updated DESC This syntax is specifically for the 2 time periods I listed however it can easily be swapped out for any length of time you need. Try entering a different # for days or if you need an even longer period of time try using weeks and days or a specific date range using one of these formats:
- Period format example: '-5d', '4w 2d'
- Date range format: 'yyyy-MM-dd'
For example if you wanted to see all issues created for a particular month you would do this:
created >= 2017-09-01 AND created <= 2017-09-30
Hope all this helps, if you find it useful please go ahead and let me know and I will be sure to continue adding stuff like this in the future :)
