Kanban not showing issues created over a week ago

Question

Hi there, I have the following query on my Kanban board:

project = III AND assignee in (membersOf("COMPANY_Team")) AND status != Done OR project = III AND assignee in (membersOf("COMPANY_Team")) AND resolution = unresolved AND resolutiondate < 7d OR project = III AND assignee in (membersOf("COMPANY Team")) AND resolved >= endOfDay(-7d) AND status = done ORDER BY status ASC, created DESC

However, this query results in issues not being visible on the board if they were created over 7 days ago. What should I add/remove in order to fix this?

Francesc_Arbó_fiu740 · Answer

To make sure if this query is hiding your issues you can try to use it in Search for issues navigator.

First of all search for all issues and search for these issues created more than 7 days ago. If you find them, try to filter step by step until you find which is the operator that hides your issues.

If you don't find them from the begining, maybe you don't have access to see them (project permissions, security level...)

Former user · Answer

Hi there,

Thank you for your timely response. This is the correct query. How would I know if it's just hiding the issues? Also, could this be fixed if I just included a creation date in the query? I'm sure that the issues were not created and resolved in the same day.

Francesc_Arbó_fiu740 · Answer

Hi @Michaiah_Gartner,

this is a complex query but there anywhere that mention the creation date. You mention the resolution field, status, project, groupmember and resolution date. Are you sure this is the query? If so, are you sure it's only hiding issues created more than 7 days? Are these issues created and resolved in the same day?