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
Within Structure.gantt, there is a column named "Gantt Start Date" that can't be accessed via JQL. Inside my structure, I would like to filter based on "gantt start date" to find all tasks that need to be started before a certain date. I know that you can't search for "gantt start date" in JQL, but is there any other way (perhaps using column formulas) to filter out things based on either of the "Gantt Start/End Date" columns? Is there a workaround to achieve this inside the Structure itself?
The effect that I'm trying to achieve is below:
resolution = unresolved and gantt_start_date < '2020-05-01'
At the moment, JQL cannot pick up various calculated attributes, but we have plans to introduce such functions. Without those, there are not many options left, but perhaps you can use Wiki Markup to highlight the required issues. It is not as effective as hiding the rows, but may help in your task.
There is a problem here, that infinite loop is possible in this scenario, so sorting and grouping have been disabled until the problem can be resolved. There is a trick, but it can trigger the same loop, so I am not sure it is wise to reveal it at the moment publicly. You can theoretically stumble upon it though, so I am just warning that it may make this particular structure in question inoperable until Gantt is disabled and workaround removed.
Sorry for the inconvenience.
Starting from Structure.Gantt 2.4 it should be possible to sort gantt dates by clicking the header of the corresponding column. Please, give it a try.