nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to search by status within a date range?

Paul Lamoureux

I am trying to figure out how to search issues with a status of "Backlog" within a date range. I've tried a number of different searches and they do not like searching by the status "Backlog". Below is one of my attempts that didn't work. I have been able to search by CHANGED TO "Backlog" or CHANGED FROM "Backlog", but that doesn't get me what I'm looking for. Any ideas?

project = OESUPPORT AND backlogDate >= "2018-01-01 00:00" and backlogDate <= "2018-01-31 00:00"

Error: "Field 'backlogDate' does not exist or you do not have permission to view it."

Accepted answers

All comments

Alexey Matveev

Could you give more details on what you want to find?

Paul Lamoureux

I would like to find all issues with a status of "Backlog" within a date range.

Steven Meadows (e-Core)

Hi Paul. You can specify the date range after the change from as follows:

during("2017-11-08", "2017-11-12")

e.g

project = "Project Name" AND status changed from "Initial Status" to ("Backlog") during("1st date", "2nd date")

Paul Lamoureux

I tried your recommendation but it did not like "Initial Status".

project = OESUPPORT AND status changed from "Initial Status" to ("Backlog") DURING ("2018-01-01", "2018-02-01")

Error message: The value 'Initial Status' does not exist for the field 'status'.

Steven Meadows (e-Core)

"Initial Status" is just a placeholder for whatever your status is before Backlog.

Paul Lamoureux

Understood, however what if the initial status is defaulted to "Backlog"? In this situation there could be no change in Status, which would make the "changed from" function invalid.