You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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.
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,