problems with a filter to limit some items

[Sven Cipido]

Hi,

So I'm trying to solve a problem from the previous Scrum Master which is still open in my team.

So we have a kanban board that shows all the tickets with the label kanban in their correct state.
In the OnHold column it shows of course all the items that are onHold.

For some reason, I'm not going into detail about that. The team wants only the items that aren't older then 30 days onHold in this column. They have a separate bord specific for the older items that is checked every friday.

So we have this filter:
project = "Our Project" and (labels in (kanban) or (labels in (kanban) and status changed to ("on hold") before startOfDay(-30d)))

But it still showing all the onHold items.

Can't find what is wrong.

[Sven Cipido · Accepted solution]

Found the solution, maybe there is a better one but this works for me :-)

project = "our project" and labels in (kanban) and status != "On Hold" or (project = "our project" and labels in (kanban) and status changed to ("on hold") after startOfDay(-30d))

[Payne]

Hi Sven,

To get the ones changed to On Hold within the last 30 days, you want to use after, rather than before:

changed to ("on hold") after startOfDay(-30d)

Perhaps that is your problem?

Regards,
Payne

[Sven Cipido]

Hi Payne,

Thanks for your answer. It doesn't solve the problem. 

What I want is all items in all other statuses and for the on hold only the ones that are between now and 30 days in onhold.

Regards
Sven