How to do a selection

[Thomas N.]

Hi,

how can I search for all my tasks where I am assignee or watcher and which are closed/done in field status?

I want to use this filter on my dashboard.

[Shalini Pradhan · Accepted solution]

Hello @Thomas N_ ,

Good day! Welcome to Atlassian community :)

You can use the following JQL query:

(status in (Done) AND (assignee = currentUser() OR watcher = currentUser()))

Thank you!

[Thomas N.]

It doesn't work, also not in this way:

status is Done AND assignee = currentUser() OR watcher = currentUser()

[Thomas N.]

status = Done AND assignee = currentUser() OR watcher = currentUser()

This should be working!

[Thomas N.]

But I still get open tasks with this query.

[Dick]

Dear @Thomas N_ 

The brackets in @Shalini Pradhan 's answer are crucial in finding the correct Jira work items. Please verify her solution by copying it into the filter you're using. 

Kind regards,
Dick

[Thomas N.]

Thank you so far!

I still verified in that way:

status = Done AND assignee = currentUser() OR watcher = currentUser()

But I still get my open tasks.

[Shalini Pradhan]

Hello @Thomas N_ ,

Good day! Please make sure to use all the brackets mentioned in the filter query.

Thankyou!

[Dick]

Dear @Thomas N_ 

Please note the differences:

Correct is:    (status in (Done) AND (assignee = currentUser() OR watcher = currentUser()))

FALSE is:       status = Done AND assignee = currentUser() OR watcher = currentUser()

[Thomas N.]

I don't find any tasks with this query and all mentioned brackets but I am sure I have.

[Dick]

That would mean that there are no tickets that pass your prerequisites. 
Try watching a ticket, put it in status done and run the query again, you should find that ticket. 

Kind regards,
Dick

[Dick]

The brackets in Shalini's solution influence the order in which the conditions are being processed. 



Your query is processed like this:   
Select these tickets:  Tickets that are both done and mine, and include all tickets that I watch. This results in area B, E, together with D, E, F, G.

So it spans: B, D, E, F, G.

Shalini's query is processed like this:
Selected tickets should be in A, B, D, E,   AND  inside B, C, E, F, D, G.

So this would span: B, D, E. 

[Thomas N.]

Thank you!

I've got it!

[Thomas N.]

Additional question:

How to build quere to get more status?

(status in (Done) AND (assignee = currentUser() OR watcher = currentUser()))

For example status "Planned" should be added in above query.

[Dick]

Hi @Thomas N_ 

You can use 
(status in (Done, Planned, "Other Status") AND (assignee = currentUser() OR watcher = currentUser()))

Kind regards,
Dick

Oh, and it's accustomed here to mark an answer as "answered", which makes it easier for people with similar questions to find this answer. Thank you in advance...