Unable view all tickets assigned to a particular sprint

[Chethana Hashani]

Hi,

I created a board using the fallowing query,

project in (CallerRecord, Dishadvisor, Follow, Ideadroid, "Merchants - Entrance Management", Otenro, Piyasa, "Rupee Saver", Toyota, General, FootballCaoch, "Dialog PRBT")

Then I created a sprint called "simato 1" base on that board. I assigned 115 tickets in to that sprint. But when I try to view the sprint, it shows only 89 tickets. I can't understand why I am unable to see the rest of the tickets

I attached some screenshots which show "active sprint" view and the list I get when I filter tickets using the sprint name

Please help me on this

[Tarun Sapra · Accepted solution]

Hello @Chethana Hashani

This is happening because the "issue navigator" view also counts "sub-tasks" but the board's  backlog view ignores the sub-task count.  In your issue search view if you type 

Sprint = 161 and issuetype  not in (Sub-task)

Then the result should be 89.

[Chethana Hashani]

Hi Tarun,

I tried using your query and it worked! :)

Thanks a ton!

[Chethana Hashani]

Also, can't I find an option to get all those issues including sub tasks in the board backlog view?

[Chethana Hashani]

Hi Tharun,

I updated my filter a bit as the below in order to modify the board,

project in (CallerRecord, Dishadvisor, Follow, Ideadroid, "Merchants - Entrance Management", Otenro, Piyasa, "Rupee Saver", Toyota, General, FootballCaoch, "Dialog PRBT") AND status != Verified AND (labels not in (fix_verified) OR labels is EMPTY) AND (Sprint is EMPTY OR Sprint not in closedSprints())

Now it shows only 56 tickets in the board's backlog view. I used the same query you provided which is,

Sprint = 161 and issuetype  not in (Sub-task)

and it gives me 90 tickets. Though I changed the filter, I didn't add more or remove any additional ticket in to / from the sprint. Now I am confused about how this happened. Could you please guide me on this. I have attached the relevant screenshots as well

Does jira automatically remove verified tickets and is that the reason for this circumstance?

[Tarun Sapra]

Backlog view doesn't have sub-task. Currently this is an open ticket - https://jira.atlassian.com/browse/JSWSERVER-7992

Please accept/upvote answer if you are satisfied with it so that others are helped as well.

[Tarun Sapra]

Your board query is 

project in (CallerRecord, Dishadvisor, Follow, Ideadroid, "Merchants - Entrance Management", Otenro, Piyasa, "Rupee Saver", Toyota, General, FootballCaoch, "Dialog PRBT") AND status != Verified AND (labels not in (fix_verified) OR labels is EMPTY) AND (Sprint is EMPTY OR Sprint not in closedSprints())

and filter query is 

Sprint = 161 and issuetype  not in (Sub-task)

Both are different so in the filter query you have to add the things mentioned in your board query like 

AND status != Verified AND (labels not in (fix_verified) OR labels is EMPTY)

And this criteria from your board filer

Sprint is EMPTY OR Sprint not in closedSprints())

Can get issues which have different sprint values than 161 thus the inconsistency. Since sprints are set on the backlog view of the board thus don't add the sprint criteria in the Board's JQL filter.

[Chethana Hashani]

Thanks a lot for your guidance Tarun 

[Tarun Sapra]

You are welcome @Chethana Hashani