Forums

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

JQL will miss some ticket

mis-it
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 1, 2025

hello

i set my JQL  is 「status = DEPLOYMENT AND assignee = currentUser() ORDER BY status ASC」, and show 12 ticket in jira , i set same rule to send my gmail ,  ticket number is 16 ,  16 is correct , same JQL rule , but jira will miss some ticket ,how can i  adjustment ? thanks

 

gmail list

gmail.png

 

jira list

jira.png

2 answers

1 vote
David Nickell
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 6, 2025

Ugh ... I think I see what is happening.  Your screenshot shows your GMAIL filter which fiilters JIRA tickets based on summary.  Well -- those could come from many different points in your system.   The issue navigator, on the other hand, is showing you real time results.

 

I think you would benefit from using a filter subscription.  This would allow you to create a filter and send an email to all the assignees with a list of tickets they need to look at.  A key factor -- name the filter soimething meaningful so it stands out in their inbox :-) 

 

How to - Filter Subscriptions

Create the filter with a name that will is meanigful:

filter1.png

 Go to the filter detail,  Select subscriptions

 filter2.png

 Create a subscription and schedule  it to run at whatever frequency you prefer

 filter3a.png

 

While waiting for the official execution time, you can go to the subscription manager and run the process manually to ensure the results

 filter3.png

 When it runs, the subscribers will receive and meaningful email with their items

 

filter4.png

 

 

1 vote
Mohanraj Thangamuthu
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
October 1, 2025

Hello, Good day. Could you review both the results and identify the missing 4 work items in JQL. Please compare with one of the returning work item. Thanks

David Nickell
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 2, 2025

That is a great/logic debugging question to ask -- at a glance, the POPF (3) and PHS tickets (1) are mssing in the JQL Version...

I am not sure how the user gets it emailed to GMAIL but something is impacting tickets in two projects.  

mis-it
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 6, 2025

i try JQL   

(1)status = DEPLOYMENT

(2)assignee = currentUser()

can not get lost ticket ,i not sure ticket something wrong  

if ticket has modify, i sent all to mail , and use gmail filter , assign to me , it's correctgmial filter.pngct

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events