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]

@Fatima AlZarooni 

When you run the JQL, what do you get

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

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