Search: create a filtered representation of the backlog

Phil W

We use backlogs with rankings, and this works fine. However, we wanted to define a filtered list of issues from the backlog, shown in rank order (and without the ability to be dragged and dropped to re-order; it is intended to be a read-only view). This takes a few steps to achieve.

1. Define a search that includes the (not human readable) rank, to allow sorting, and the sprint, to select items from a given sprint (you have to select one of the sprints at this stage).
2. Clicking the Rank column of (not-human-readable) values ordered the list appropriately, but of course we are looking at a specific sprint, not the backlog.
3. Switching to "advanced search", the sprint number can be replaced by null to select the backlog.
4. Remove the rank and sprint columns from the search definition and you are done.

After modification the generated advanced search for this is of the form (for example):

project = SUP AND status in (Open, Reopened, "Waiting for Support") AND Sprint = null ORDER BY cf[10011] ASC

Even though the rank values are not human readable, sorting does actually appear to work.

Andy Heinzer

Hi Phil,

Thanks for posting your question and the solution you came up with to achieve this.  I think this will help other users that want a similar display.

In the future, please try to break this up so that your question/problem is in the initial post, and the answer is a separate response to that post.  This way it can be accepted as an answer on this post.  It can also receive up votes this way. 

When at least one answer is accepted on a question in Community, the search results on sites like google will tend to preface the title with the word "Solved:".  This can help searchers even more to understand that this thread has an accepted solution.

Thanks again,

Andy