How can I filter Sprints in or out of a query?

[George Carvill]

Following up on SEN-2411680:

I have read the various Issues. But I can't seem to figure out how to filter things, right now, today.

In the attached screen shot you can see some of the results of a query. Several Issues are in more than one Sprint as a result of not getting finished and pushed to the next sprint.

I want this query to filter OUT any Issue that has "Sprint 22" in the 'Sprint' column.

I recognize that the sprintId does not equal the sprint name. And I can find the sprintId value: it is "23" for "Sprint 22." But I can't figure out how to write the query. The field 'sprint Id' is not recognized by the query.

[Pete Woolley · Accepted solution]

You should be able to input query as follows:

"sprint != 23"

That should filter out anything with sprintID as 23 i.e. "Sprint 22" in your case.