How can we add more filter on the Agile Board "Backlog" tab?

Prabhh
Kilo Guru

Hello,

We have a requirement to add a filter "Blocked stories" similar to "No story points" that shows the count of Blocked stories and on click it displays the list of those blocked stories on the Agile Board Backlog tab:

find_real_file.png Can anyone please suggest how can we achieve it?

Thank you in advance,

- Prabhh

1 ACCEPTED SOLUTION

Chris Everding
ServiceNow Employee
ServiceNow Employee

Hi Prabhh,

You can do this by adding some additional code to the BacklogMetaDataService script include. The getMetrics function is what you're looking for. Simply create a new query for the filter you're after -

var blockedStoriesQuery = 'blocked=true';

Then build the metric

name: gs.getMessage('Blocked'),
        query: blockedStoriesQuery,
        count: this.getMetricCount(this.buildMetricQuery(backlogId, backlogQuery, '^' + blockedStoriesQuery))

Basically just clone one of the existing metrics and make the changes required. The ui macro will then just iterate through the array of metrics, no UI work required.

Take care with the above, and ensure the benefits of configuration will compensate for the additional care required when performing future upgrades. 

Thanks,

Chris

View solution in original post

4 REPLIES 4

Chris Everding
ServiceNow Employee
ServiceNow Employee

Hi Prabhh,

You can do this by adding some additional code to the BacklogMetaDataService script include. The getMetrics function is what you're looking for. Simply create a new query for the filter you're after -

var blockedStoriesQuery = 'blocked=true';

Then build the metric

name: gs.getMessage('Blocked'),
        query: blockedStoriesQuery,
        count: this.getMetricCount(this.buildMetricQuery(backlogId, backlogQuery, '^' + blockedStoriesQuery))

Basically just clone one of the existing metrics and make the changes required. The ui macro will then just iterate through the array of metrics, no UI work required.

Take care with the above, and ensure the benefits of configuration will compensate for the additional care required when performing future upgrades. 

Thanks,

Chris

Thank you Chris. It worked fine!

 

-Prabhh

We have several groups that utilize this agile board, backlog specifically. If we take away a tile or add a tile, will it take it away/give it to all groups or is there a way to specify for which groups the tiles should show up?

Hi @Chris Everding  , I have a similar requirement here to add a filter for related list on story table.

Basically I want to add a filter on story table to show only stories with Active scrum tasks.

Please guide how shall I proceed with my requirement.

If I do as you suggested above, how will I ensure that this change is applicable to only my specific filter via Personal backlog.

We have like 10 filters defined on personal backlog table, and this related list filter condition is needed only in 1 filter. We are on Utah and can't see a possbility to add related list conditions neither via filters available in personal backog nor via filters on table directly.

 

Thanks,

Vivek