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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.