Are you in the loop? Keep up with the latest by making sure you're subscribed to Community Announcements. Just click Watch and select Articles.

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!


Jira Structure Sorting on formula with filter

I have a calculated date/time column that I want to sort on.  The parent issue has formula to set it to the max date/time of the children.  I put in a sort into the automation and it sorts properly.  But when I filter on an attribute the results are incorrectly sorted since the automation sort does not rerun using the calculated columns new values



Issue A

Child 1,  10/1/2023

Child 2, 10/2/2023


When the structure comes up A is sorted by the max date of it's children (10/2/2023).  But when I run a transformation filter that removes Child 2 based on an attribute, Issue A's date is changed to 10/1/2023.  The problem is it's now no longer in correct sort order.  I know I can then sort on the column, but that's one more step to explain to my users.  Is there a way to make this work as part of the filter on the attribute or another way.

1 answer

1 vote
Stepan Kholodov _Tempo_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Oct 20, 2023

Hello @larry joseph 

I'm afraid your setup is not clear. For example - if a child 2 with date 10/2/2023 is removed, why shouldn't the parent's date switch to 10/1/2023 since it's the only source of dates left in the structure. We would need to know more about how the structure is built and what you want to see as a result of the filtering to be able to provide any specific recommendations.

Please reach out to us directly at our support portal - we'll take a closer look at your structure and see what can be done to solve this matter.

Best regards,
Stepan Kholodov

Thank you for reply.  The parent date should change to 10/1/2023, but now it's not properly sorted relative to the other records.  Hopefully better example:


Parent issues have formula to set their date to max date of their children


Issue A (date without filter = 10/10/2023, with filter on Attribute = Y is 10/1/2023)

Child 1, 10/1/2023, Attribute = Y

Child 2, 10/10/2023, Attribute = N

Issue B (date without filter = 10/5/2023, with filter on Attribute = Y is 10/4/2023)

Child 1, 10/4/2023, Attribute = Y

Child 2, 10/5/2023, Attribute = N

Issue C (date without filter = 10/3/2023, with filter on Attribute = Y is 10/2/2023)

Child 1, 10/2/2023, Attribute = Y

Child 2, 10/3/2023, Attribute = N


Without the filter they sort, descending, A, B, C.  I have added a sort on the formula in the automation and it works. But if the filter on Attribute = Y is on then they should be sorted B, C, A. But since the sorting is part of the automation, it doesn't re-sort after the filter is applied.  I would like a way to get it to re-sort as part of the filter / when the filter is applied the sorting is maintained properly.  I am sharing this Structure to a large group of users and it needs to be easy to use, so would prefer to not have to tell them to apply filter then re-sort.  I'm sharing this out as a link to the base Structure and have set a default view that has the columns and formulas that are needed.

@Stepan Kholodov _Tempo_   any ideas on how I can achieve this ^^?  thanks

Suggest an answer

Log in or Sign up to answer