Nested JQL Statements for Filters?

Martin Fehrenbach August 27, 2014

Is there any way to achieve the following:

I want to build a filter that shows all issues which have the same value in a certain field than the issues I am currently watching.

In SQL it would be something like this:

Select * from Table
where attribute in (select attribute from Table where watcher = CurrentUser)

Any ideas?

2 answers

1 accepted

0 votes
Answer accepted
Jaime S
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
August 28, 2014

Hi, Martin.

There is an improvement request for that:

https://jira.atlassian.com/browse/JRA-21936?jql=text%20~%20%22JQL%20nested%22

If you read the comments, you will see that there some stuff that you can already do.

I hope it was helpful.

0 votes
Diego Zarpelon
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
August 28, 2014

If I understood your qustion you can use this:

watcher=currentuser() and customfieldname=value

Hope this helps

Suggest an answer

Log in or Sign up to answer