Kanban Board Filter Query

[Rama Krishna Ravipati]

I have set my Kanban Board to show "Accepted" items for 2 weeks. After 2 Weeks if i edit any of the accepted items (Apart from "Status" Change), the issue items reappear again on my kanban board. Would you please help us with the filter i can use not to show the Accepted items if there is no change in the Status. (Even though i might have edited the other fields for the accepted items, i don't want to show the Accepted items on my Kanban board"

your help is really appreciated.

[Jack Brickey · Accepted solution]

@Rama Krishna Ravipati & @Valerie Knapp ,

the issue boils down to how the "Hide completed issues older than" filter actually works. It leverages the "updated date" so when an issue that naturally ages of the board is later updated then it will reappear on the board in the clock start over. At least this has been my experience and understanding and there are a number of posts discussing this. Most of which I've noted are centers around server but I think the same applies in Cloud as well.

So how do we work around this?

We can disable that filter and work the desired filtering into our main filter query. Try the following:

1. change "Hide completed issues older than"  to "nevermind, show all"
2. edit your filter query to be -  project = OGA AND component in ("Implementation/Partnership Services") AND issuetype in (story, Task, Defect, Spike, Enabler) AND (status != accepted or (status = accepted and status changed to accepted before startofday(-14)))

Also, if you have any other statuses in your last column, e.g. Done then you likely want to include that status in with the "accepted" status. Please let me know if this works or if you need any further assistance.

[Rama Krishna Ravipati]

This didn't work either. 

[Jack Brickey]

hi @Rama Krishna Ravipati , oops...I see an error try this...

project = OGA AND component in ("Implementation/Partnership Services") AND issuetype in (story, Task, Defect, Spike, Enabler) AND (status != accepted or (status = accepted and status changed to accepted after startofday(-14)))

[Rama Krishna Ravipati]

Hi Jack, Thank you for the update. I did try the above query and this makes all my accepted items to disappear. I still want the Accepted items show on my board which are less than 2 weeks old.

[Jack Brickey]

Well that's no good. Unfortunately I can adequately test on my side before I share it. 

The last bit in the filter (and status changed to accepted after startofday(-14)) should keep any issues moved to accepted after 14d ago ~Sept15.

Can look at the History of one of the accepted issues you expect to remain and check when it moved to Accepted status.

Also, as a means of testing you can create a test issue and move to Accepted status. This issue should certainly remain for two weeks (14d).

[Rama Krishna Ravipati]

Hi Jack, if i add the filter to my query, it does only show the accepted items wich are accepted in the last 2 weeks, but it also hides all other story items. It is just showing the recent 2 week Accepted items only.

[Jack Brickey]

Please copy the filter you have and past it here. Also please paste n the JQL search for issues and assess results

[Rama Krishna Ravipati]

This is the board filter i have - 

project = OGA AND component in ("Implementation/Partnership Services") AND issuetype in (story, Task, Defect, Spike, Enabler) and sub filter

This is the query when searching for older issues - 

project = OGA AND component in ("Implementation/Partnership Services") AND issuetype in (story, Task, Defect, Spike, Enabler) AND (fixVersion in unreleasedVersions() OR fixVersion is EMPTY) AND status in ("5", "10308") AND NOT (updated >= -2w OR statusCategory != Done)

[Jack Brickey]

I'm confused. Did you replace your board filter with what I proposed? That was my recommendation. If not please try it. Leave subfilter alone and be sure to choose the "nevermind" option in the hide completed drop-down.

[Rama Krishna Ravipati]

Hi Jack, Yes i tried the filter that you gave it, what it did is, it is showing only the accepted items that are less than 2 weeks old and also not showing any other stories in my board.

[Jack Brickey]

ok, I want to make sure we are indeed on the same page here so please do the following:

1. click into the search bar at the top menu bar and select View all issues
2. If you are not in the advanced search mode please click on advanced search
3. Copy and paste the following into the JQL search - project = OGA AND component in ("Implementation/Partnership Services") AND issuetype in (story, Task, Defect, Spike, Enabler) AND (status != accepted or (status = accepted and status changed to accepted after startofday(-14)))
4. What are the results? Are you seeing only issues in the Accepted status or other statuses as well?

If you only see accepted:

• replace the query with - project = OGA AND component in ("Implementation/Partnership Services") AND issuetype in (story, Task, Defect, Spike, Enabler)
• what do you now see?

If you see statuses other than Accepted:

• Go back to your board and select Board settings and in the General tab click on edit filter query link
• replace the query with this filter - project = OGA AND component in ("Implementation/Partnership Services") AND issuetype in (story, Task, Defect, Spike, Enabler) AND (status != accepted or (status = accepted and status changed to accepted after startofday(-14)))
• You should see the same list issues as previously. Click Save to update your board's filter.
• Go back to the General tab for your board and ensure the sub-filter remains -fixVersion in unreleasedVersions0 OR fixVersion is EMPTY
• Also ensure that the "hide completed" has the "never mind" option selected.
• Go back to your board and observe the results. What you should see is the same list of issues that you saw in the previous JQL query search.

let me know...

[Rama Krishna Ravipati]

Hi Jack,

i did try the filter

project = OGA AND component in ("Implementation/Partnership Services") AND issuetype in (story, Task, Defect, Spike, Enabler) AND (status != accepted or (status = accepted and status changed to accepted after startofday(-14)))

and now the board items shows other status items as well as the accepted status which are less than 14 days old.

Thank you for your help. Really appreciate it

[Jack Brickey]

Please consider accepting the answer.

[Rama Krishna Ravipati]

Hi Jack, i just clicked on "Accept answer"

[Valerie Knapp]

Hi @Rama Krishna Ravipati , welcome to the community and thanks for your question. 

Please can you share the filter query for your Kanban board?

What you see in the Kanban board is the combination of the filter and the settings here in the board -

Please check the Kanban board sub-filter and the Hide completed issues settings, try clearing them and compare the results.

If you need more help, let us know.

Cheers

[Rama Krishna Ravipati]

Here is my filter query - project = OGA AND component in ("Implementation/Partnership Services") AND issuetype in (story, Task, Defect, Spike, Enabler)

The sub-filter shows me the same as you have pasted in your reply. This works until i don't make any changes to the Stories that are already accepted. The stories shows on my board for 2 weeks and they are gone from the board. For any of the stories that are older than 2 weeks and if i make any edits to the Accepted stories (example due date or description or anything, i m not changing the status from Accepted to any other status. In this scenarios, the Stories appear again on the board. They will stay for 2 weeks and then disappear. If there is anything i can add to the query to not show show the accepted items if there is no change in the status

[Valerie Knapp]

Hi @Ram

[Rama Krishna Ravipati]

Hi @[deleted]

[Valerie Knapp]

Lol, sorry, I was trying to write a better reply and I hit enter too fast. Basically, I followed this link here - 

Which shows you the JQL for that column in the board, what shows in the Done.

project = SKP AND (fixVersion in unreleasedVersions() OR fixVersion is EMPTY) AND status = "10002" AND NOT (updated >= -2w OR statusCategory != Done) ORDER BY Rank ASC

I was going to say you can just remove the 'updated' part, and paste that into the filter query for the board, but this query is specific to the column.

[Rama Krishna Ravipati]

Thank You Val for your input. Here is the query i have currently

project = OGA AND component in ("Implementation/Partnership Services") AND issuetype in (story, Task, Defect, Spike, Enabler) AND (fixVersion in unreleasedVersions() OR fixVersion is EMPTY) AND status in ("5", "10313", "10308", "11001") AND NOT (updated >= -2w OR statusCategory != Done)

Please let me know what to modify in here

[Rama Krishna Ravipati]

For me i have "Accepted" Status included in my Done Column. If i add another column just to include "Accepted" Stories, here is how the filter looks like - 

project = OGA AND component in ("Implementation/Partnership Services") AND issuetype in (story, Task, Defect, Spike, Enabler) AND (fixVersion in unreleasedVersions() OR fixVersion is EMPTY) AND status = "10308" AND NOT (updated >= -2w OR statusCategory != Done)

[Valerie Knapp]

Hi @Rama Krishna Ravipati , thanks for your patience.

Sorry, what is the expected behaviour? You want, if something is done, after 2 weeks, not to see it anymore? If this is the case, this a default behaviour in Jira Work Management. 

Workflows and statuses for the board | Jira Work Management Cloud | Atlassian Support

Would that be a possibility? I am not seeing how to do this in the Jira Software project, sorry.

[Rama Krishna Ravipati]

I have the setting to hide the Stories that are Accepted and are 2 weeks old. That means once i accepted the story, it shows on the board for 2 weeks and then disappears. Yes this is the default behaviour.

In my case, for any old accepted stories, if i edit them, lets say i have added Target Start Date or End date or due date for the story that is already accepted, it now shows on the board. For me i don't want those accepted stories to show on the board, as i didn't change the status of those stories.