'JQL filter matching backlog including order

I need a JQL filter that matches what's in the backlog, and have the same order as the backlog.

My product owner and I ordered all the backlog, and I need my filter to reflect that.

My current attempt has about five and a half times as many items as the backlog...900 vs 159 actual items in the backlog

project="Project Name" AND issuetype != Epic AND (Sprint is EMPTY OR Sprint not in (openSprints(), futureSprints())) and status != Closed Order by RANK

The order isn't correct either.

How do I filter items to match what the backlog has, and show the same order?



Solution 1:[1]

Here is the answer that worked for me

project = <your project> AND issuetype in (task, "Task ", Story, Improvement, Improvements, Research, Bug, Incident) AND status not in (Done, CANCELLED, Closed) AND (Sprint in (futureSprints()) OR Sprint is EMPTY) ORDER BY rank

  • Changed the parameters according to your project.

  • Order by rank - gives you the order you see in the backlog

Cheers

Solution 2:[2]

This is because you are using .png files which are not supported by navigation drawer. It only works with .svg or Android Vector Asset.

If you want to use these pictures, you need to convert them to .svg file from here.

How to convert ?

  1. Scroll down and you will something like this -> enter image description here

  2. Click on Choose a file and pick the image you want.

  3. Once you select, you will see this below it -> enter image description here(I have used my image)

  4. Click on the Generate button and wait for a while-> enter image description here

  5. Once you see an image in the side, you know that it has been converted -> enter image description here

  6. Click on the Download SVG button and you will find it in your file explorer.

Once you download them, you can add it to the drawable folder. But make sure that you delete the previous png files.

Tada! Its done! You them in the navigation drawer and you get the icons too!

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1
Solution 2