How to define a custom filter for backlog items in JIRA sprint

[Fatima AlZarooni]

Hi everyone!!

I am facing an issue in JIRA as I am unable to define how many items I have in my backlog and so I am unable to trace my roadmap and define a dashboard. 

as there is no define filter, I can filter all the items with. I am expecting the number of which I am trying to filter should show me the exact number I have in my backlog.

 

my total backlog number is 188. however, I have some items created in other sprint. so, I'm trying to filter with only number of 188 not the items in my other sprints and not receiving that accurately.

the query I'm trying with is this: 

project = MYPROJECT
 AND statusCategory != Done
 AND (     
         sprint IS EMPTY
      OR (
              sprint NOT IN openSprints()
          AND sprint NOT IN futureSprints()
         )
      )

[Vishal Biyani · Accepted solution]

@Fatima AlZarooni 

When you run the JQL, what do you get

project = MYPROJECT AND statusCategory != Done and sprint is Empty

[Fatima AlZarooni]

Hi @Vishal Biyani   , I get a number which is 226 but not what is showing in my backlog . my backlog is showing =188.

what am I doing wrong?!  or what else from the whole backlog is taking.

[Vishal Biyani]

if you try to exclude Epics from the above query, then does the count match?

project = MYPROJECT AND statusCategory != Done and sprint is Empty and issuetype != Epic

[Fatima AlZarooni]

thanks @Vishal Biyani

it's very near to that but still shows 3 number difference.  like now it is showing 186. 

which in actual number in the backlog its 188.

[Vishal Biyani]

Looks like you have few subtasks. You can filter it out using 

issuetype not in subTaskIssueTypes()

project = MYPROJECT AND statusCategory != Done and sprint is Empty and issuetype != Epic and issuetype not in subTaskIssueTypes()

See if this works.

[Fatima AlZarooni]

Thanks Alot !!! @Vishal Biyani  this worked yes.! 

appreciated it! 

but just out of curiosity why should we exclude subtasks? 

[Vishal Biyani]

Generally, subtasks are related to a story or task. The expectation is one story/task should complete in a sprint (unless there are reasons beyond anyone's control).

You can go through this article related to this topic.

[Fatima AlZarooni]

got it ! Thanks  Again @Vishal Biyani 

[Seifallah Bellassoued]

Hello @Fatima AlZarooni

Your issue is not very clear. Can you clarify it please?

And I belive there is a point witch looks not very clear for you:

• Issues should be removed from backog when they are in the status(') mapped to the last column in your board. It is not based oin status category or resolution.

Best regards,

[Fatima AlZarooni]

Hi, I'M sorry if my question wasn't clear.  

i will try to rephrase, I'm trying to run a report from Jira (Filters) where I can have all the counts of my product backlog. the whole list. and that is what I'm unable to get. 

i don't see any filtrations i can do to get the backlog extracted as report (CSV).