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."

[Bob Moore]

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'.

[Bob Moore]

"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.

[Bob Moore]

In this case, you could maybe do something like:

status changed during ("2018-01-01", "2018-02-01") and status = "Backlog"

[Paul Lamoureux]

Unfortunately your recommendation does not work. I tried another search string that seems valid however once again it does not like the status "Backlog", even though we have many issues that show a status of backlog.

project = OESUPPORT AND status was in "Backlog" during ("2018-01-01", "2018-02-01")

Error message: Operator 'was in' does not support the non-list value '"Backlog"' for field 'status'. 

[Bob Moore]

When you create the issue, is the first status, 'Backlog'? If so, no status would be considered changed and that's why you wouldn't see any issues. This could be tricky unless you have an intermediary status. 

[Bob Moore]

You could potentially create a query like the following if the 'Backlog' status is mapped to the 'To Do' Status Category.

Project = OESUPPORT and statusCategory = "To Do" and created >= 2018-01-01 and created <=2018-02-01

[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.