Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Custom issue search in Structure column

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?

Bildschirm­foto 2022-12-16 um 12.55.17.png


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


Thank you!



1 answer

1 accepted

3 votes
Answer accepted

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,


Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events