Jira agile board columns incorrectly saying statuses not available in any workflow used by board

Liam O'Gara July 5, 2018

I have a basic filter for an agile board that is essential the following... "project = project AND (issuetype = Epic OR CustomField = value) ORDER BY Rank ASC"

This filter pulls in 5 different issue types. I mapped all the statuses to columns and the Columns configuration screen displayed no errors.

I then added a new Status to a workflow that is shared by three of the issue types.  I confirmed the new workflow is correct and the three issue types have no problems.

However, now the Columns configuration screen shows the exclamation mark warning icon on most of the statuses with the text that "This status is not available in any of the workflows used by this board". This error is shown on statuses where the issue count is greater than 0 (in addition to statuses where the issue count is actually 0). I have confirmed that all statuses shown on the Columns configuration are in fact used by workflows used by the board.

Below is a screen show of the Columns configuration screen.

Agile Columns Errors.pngTo test things, I changed the board filter to only filter for issues in the project and not filter by a custom field and then the errors on the Column configuration screen go away.

I used a custom field in the board filter on another board and don't experience this problem.  However, the filter for that board does not have a nested condition like the one I am using on this board that is experiencing the status problem.

So I did another test where I changed the board filter to the following and now I no longer see the warnings: "project = project AND CustomField = value ORDER BY Rank ASC"

All that said, the backlog does show all the issues I expect even though the Columns configuration screen says there are status problems.

Not sure if there is a bug with statuses when using a nested condition on issue types and custom fields.

2 answers

4 votes
Liam O'Gara July 5, 2018

After testing a bit more I believe this is a bug on the Column management screen and it incorrectly parses the board filter and sees the part of the nested condition where it filters to issue types = EPIC and therefore filters to only statuses that Epics uses (which is the simplified workflow).

Rowan_van_Rooij May 7, 2019

Thanks! I have had the same issue. I couldn't add a status to a column due to this filter with Epic. 

I removed the epic in the filter and now it's working correctly and I can add the status. Still running on a bit of an old JIRA v7.9.2

That might solved the issue.

 

Thanks for this message! really helped me to solve the issue!

0 votes
Alex Dopp April 23, 2021

Different year, same issue.

I understand there is a bug logged here: https://jira.atlassian.com/browse/JSWSERVER-11623

You know the drill ... add your votes ...

In the meantime the workaround with changing the filter query seems to work. I just appended this to mine (as advised by support):

... AND issuetype in (standardIssueTypes(),subTaskIssueTypes()) ...

 Worked for me.

Alex Dopp April 26, 2021

The respective bug for cloud is logged here: https://jira.atlassian.com/browse/JSWCLOUD-21486

Like Labani Roy likes this
Danny Who August 9, 2022

Thanks, I also have a nested JQL in the basic board filter.

project = VP AND (Epos-Verknüpfung in (VP-3328, VP-4988, VP-5085) OR issue in issuessubtasks("Epos-Verknüpfung in ('VP-3328', 'VP-4988', 'VP-4992', 'VP-5085')")) ORDER BY Rang

 

I'll try to restructure the JQL to make it work

Suggest an answer

Log in or Sign up to answer