Custom issue search in Structure column

[Adalbert Rohr]

Hi everyone,

is it possible to make a custom jql request in a cell (e.g. with formulas) that uses a value of the respective row as a variable?

I added a screen shot to better describe what I mean.

Thank you!

Berti

[Phil Heijkoop · Accepted solution]

Hi Adalbert,

That's an excellent question. Sadly, running a JQL inside a formula with a variable from that is row-dependent can't be done. However, we may be able to achieve what you're hoping to accomplish with a slight variation. 

We have a really neat column called the Query Match column. This allows you to see if each row matches a given query (you can select JQL as one of the query types). So in your example, we could create a Query Match column that takes the JQL "project=XYZ AND issuetype=Defect" (this specific JQL can be recreated in Expr), you can use that as a conditional value in your formulas. 

However, it looks like what you're trying to do is populate the column with a list, or a link to the results of that JQL's results, am I right? That's not possible, unless there is some direct link to the issue in that row (for example you can filter by the JQL query all the issues that are blocking a given issue, and show that list). 

Hope that helps,

Phil