Jira filtering

[Ofer Ohana]

I'm trying to create new filter with the conditions below but for same reason the function openSprints() is not working , 

the reason im using openSprints() since i want to filter active sprint.

project = XT AND issuetype = Story AND Sprint in openSprints() ORDER BY updated DESC

Log into use GingerLimited modebelow, but for the same reason the function openSprints ()×

[Ofer Ohana]

Hi 

You are right, it is the right way to filter items from current sprint.

But if fount that the problem is I can't use Sprint in openSprints ()  in the middle of statements like this.

project = XT AND issuetype = Story AND Sprint in openSprints() ORDER BY updated DESC

The function needs to be at the begging of statement 

sprint in openSprints() AND project = ATEAM AND issuetype = Story ORDER BY updated DESC

<iframe></iframe>

[Petter Gonçalves]

Hello Ofer,

Actually, both queries provided have come up with the same results for me, as you can see in the screenshots below. I only changed the project to TS to be an existing one in my instance:

In fact, both queries are correct and it's expected that both return the same results for you.

That been said, could you please give us a screenshot of what issues both queries are returning to you?

Also, can you please explain to us what are you expecting both queries above to return? I think that maybe I can be misunderstanding your question.

We will be waiting for your answer.

[Petter Gonçalves]

Hello Ofer,

Welcome to Atlassian Community.

The query you are using should return all Stories of project XT that are currently added to your Active Sprint.

In other words, it will only return issues that are added to an "In progress" Sprint that was already started, but not completed.

That been said, can you please give us a practical example of issues that it should be returning and it is not? 

With the information above, please send a screenshot of your Active Sprints view displaying the issue that is not been returned:

We will be waiting for your answer.