Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

JQL filtering not working properly

Alexander Gheorghiu
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 5, 2018

I have the following JQL for my agile board quick search

status IN ( BACKLOG, "IN PROGRESS", "UNDER REVIEW", REJECTED, APPROVED, DONE)

but is not working - a lot of tickets are not present and those are all the statuses my project has so basically should display all the tickets (similar to no quick filter selected)

3 answers

0 votes
mini
Contributor
November 4, 2021

I've got the same issue, for one of my projects,
the following filter is not working 

Status was in ("To Do","Ready For Dev","In Progress","Done") on ("2021-10-24 00:00") 

This is the list of statuses available, and tickets have been in this status on the given date (confirm by ticket history).

 

This filter is perfectly working for all other project we have !!

This one, was created as "private" and using "Team Managed" Template

Urgent Help Needed .....

Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 4, 2021

If the project is "private", the first debugging question is "can the user trying the filter see the issues in the project at all?"

mini
Contributor
November 4, 2021

this was indeed the frst step, then the project have been updated to "limited" and we have been granted as admin on it ... nothing changed.... 

0 votes
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 5, 2018

One thing you might check - run and save a filter for "project = xyz".  Go to a dashboard and add a filter statistics gadget.  Include resolved issues, select your filter and choose "status" for the statistic.

This will confirm your list of status is complete, and give you a way to check the number of issues is correct.

0 votes
Pete Singleton
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 5, 2018

Have you checked the board's main Filter Query?

Alison Hunt
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 6, 2019

Hi, 

I have the same type of problem..  A filter as follows: project = 'project' OR project = 'project' AND resolution != incomplete ORDER BY Rank ASC    and regardless all the issues with resolution as incomplete display in the Kanban backlog.     I tried this filter because and Epic Link != 'xxx'  will NOT work,  status != 'xxx' Does not work, and Labels != 'xxxx'  does NOT work.    Why not?    We continue to see items with icebox or archived status even though I added filters to block them.  We continue to see items linked to the Epic we specifically filter OUT.   what might we be doing wrong?   I am well versed in this filter language.. 

Like Victoria Crosby likes this

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events