List / Reporting filter criteria show incorrect Choices for condition 'State' against the 'Release [rm_release]' table - Known Error

List / Reporting filter criteria show incorrect Choices for condition 'State' against the 'Release [rm_release]' table Description List filtering criteria show incorrect Choices list for the condition 'State' when reporting against the 'Release [rm_release]' table.

Steps to Reproduce

1 - Login as administrator.

2 - Install the plugins: SDLC - Scrum SDLC - Scrum Process Pack

3 - Go to Report > Create New: Type: List Table: Release [rm_release]

4 - Add the filter condition: Task Type is Release State is (note 11 states are listed, including 2 drafts)

Observe the results do not only limit to the expected 9 state choices for rm_release.

5 - Open a Release list rm_release.list and filter by State.

Observe the State will show 2 drafts and 11 total choices rather than the expected 9.

Workaround After carefully considering the severity and frequency of the issue, and the cost and risk of attempting a fix, it has been decided to not address this issue in any current or near future releases. We do not make these decisions lightly, and we apologize for any inconvenience.

The workaround is to update the value of the ' Draft ' Choice for rm_release to ' -6 ', same as the child tables. After that, update all the existing rm_release records in Draft State to the new value '-6', possibly with a fix script in case of a high number of records.