Assignee + Approver Filter

[Yael Geffen]

Hi,

I want to be able to see in one list all the tasks each developer is working on, both as an assignee and as an approver. However, when I add both fields to the search, it shows me tasks that the specific developer is the assignee AND the approver, but I want to receive an OR option.

[Y Dang · Accepted solution]

Hi @Yael Geffen

Please press the word "Switch to JQL" next to the "Search" button and type the JQL query as follow: assignee = <username> OR approvers = <username>

Note that <username> is the user you want to find. 

I hope this helps!

Regard, 

Y Dang

[Yael Geffen]

It does, but I also want to see only specific statuses, mainly - I don't want to see "Done" or "Deferred", how do I add it to the query?

[Mohammed Aamer Khan]

Hi @Yael Geffen

For that You can edit Query to:
(assignee = <username> OR approvers = <username>) AND Status Not in (Done,Deffered)

[Yael Geffen]

Doesn't seem to work for me, it still shows me all the statuses I entered in the JQL.

[Y Dang]

@Yael Geffen You should leave a space between 2 statuses like my pics. Hope this helps 

[Y Dang]

@Yael Geffen Or maybe the status's name in your query does not match with the Status's name. You can try by choosing the name in dropdown list when you typing

[Mohammed Aamer Khan]

@Yael Geffen Please use '(' & ')' as I have mentioned above in last comment and shown in below screen shot

[Yael Geffen]

Unfortunately still doesn't work, do I need to close the query in some way? With a semi-colon or something like that?

[Yael Geffen]

@Y Dang , this is after I chose the statuses from the dropdown menu.

@Mohammed Aamer Khan , not sure I understand from your screenshot where to add the & symbol. On your picture, it seems you deleted parts of the user ID.

[Y Dang]

@Yael Geffen Please copy the following query: 

(assignee = 5e82e7ffaff1810c17a6139b OR approvers = 5e82e7ffaff1810c17a6139b) AND status not in (Done, DEFERRED, CANCELED, CANCELLED, DEVTEST)

[Yael Geffen]

Thanks, it worked.