Missed Team ’24? Catch up on announcements here.

×
Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Products
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

How to create JQL Query

Natalie Kwong
Natalie Kwong
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!
Get involved
January 15, 2019

How to create a query to sort for adding all tickets I am currently on watch list as well as displaying tickets that are Unresolved under resolution column?
Please help, thank you

Answer
Watch
Like Be the first to like this
294 views

3 answers

3 accepted

1 vote
Answer accepted
Ollie Guan
Ollie Guan
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Become a leader
January 15, 2019

Hi @Natalie Kwong,

watcher = currentuser() AND resolution is EMPTY ORDER BY created DESC

Reply
0 votes
Answer accepted
Marc Minten _EVS_
Marc Minten _EVS_
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.
Get recognized
January 16, 2019

...I guess the "...as well as displaying tickets... should be translated in an OR, NOT and AND ! :

watcher =  currentUser() OR resolution  = Unresolved
Reply
0 votes
Answer accepted
Yogesh Mude
Yogesh Mude
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.
Get recognized
January 15, 2019

Hi @Natalie Kwong

Welcome to the community.

Please use the below query and find the article using which you can write your own JQL queries.

watcher =  currentUser() and resolution  = Unresolved

https://confluence.atlassian.com/jirasoftwarecloud/advanced-searching-functions-reference-764478342.html

Reply

Suggest an answer

Log in or Sign up to answer
Jira
Jira
TAGS
AUG Leaders

Atlassian Community Events

    See all events