Request to remove completed Sprints in the Agile Planning board combo

Andrew Bishop1 · ‎12-23-2019

1) If we navigate to the backlog.

2) Select a story

3) Select the Sprint and see this list which includes Sprints marked complete / Inactive (in the example below the 2019-21 & 22 sprints).

Selection defaults to All no matter what we do. Can we change default filter to only “Active” from “All”?

Suseela Peddise · ‎12-31-2019

You can check the state value from the field dictionary.

Go to table rm_sprint --> open the 'state' field dictionary and check for the values.

As per the OOB, there is an dictionary override on the state field for rm_sprint table. Please have a look at the below screenshot:

If I have answered your question, please mark my response as correct and/or helpful.

Thanks,

Suseela P.

Suseela Peddise · ‎12-23-2019

Hi,

Amend 'state!=3' (filter out the completed sprints) in the reference qual. Please refer the below screenshot.

If I have answered your question, please mark my response as correct and/or helpful.

Thanks,

Suseela P.

Andrew Bishop1 · ‎12-23-2019

I am testing this theory.

Andrew Bishop1 · ‎12-23-2019

It's still displaying "Completed" Sprints in the lookup.

Suseela Peddise · ‎12-24-2019

Hi,

Make sure you have used correct value for completed state.

As per the OOB, complete state value is 3 . So update the reference qual as below to remove the completed sprints from the reference field

javascript:'state!=3^sys_idIN'+ScrumSecurityManager.getStoryDotSprint(current).join(',')

As per the OOB, shows all the sprints

After update, shows only active sprints. Completed sprints aren't showing in the reference lookup:

If I have answered your question, please mark my response as correct and/or helpful.

Thanks,

Suseela P.