Get data into filter based on data from another filter

Question

I am building a filter where i want the row to appear if the WorkItemId appears in a column on another filter

e.g. 
Filter v1 (WorkType, WorkItemID, Parent)

Filter v2 (WorkItemID, StartDate) - where WorkITemID = Filter V1.Parent

So in Filter V2 we pull back the data where the workitemid is in the parent column of Filter v1

Is this possible?

Trudy P Claspill · Answer

Hello @Andy Christley

Were you able to solve your need?

Do you have additional questions about this topic?

Trudy P Claspill · Answer

Hello @Andy Christley

Welcome to the Atlassian community.

Essentially you are asking about nesting filters - Filter v2 uses the result of Filter v1 as criteria for selecting issues. That is not supported natively.

There are third party apps that extend JQL capabilities. Enhanced Search from Adaptavist is one. You can find others in the marketplace. Here's a search that includes some of them:

https://marketplace.atlassian.com/search?query=jql%20search

Are you open to, or do you already have, such a third party app?

If so, we can help you understand how to construct an appropriate filter based on a specific app.

Marc -Devoteam- · Answer

Hi @Andy Christley

This is not possible.

JQL finds issues and this clause can be stored as a filter, you can use the filter in another JQL, but not in a column, columns show the value of the field in the found issue

Example: project = xxx and filter = <name-of-a-filter>

Then you can use the JQL of another filter in another filter.