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

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

Avatar

1 badge earned

Collect

Participate in fun challenges

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

Challenges
Coins

Gift kudos to your peers

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

Recognition
Ribbon

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!

Leaderboard

Creating a scripted field to get number of tickets older than 5 years

Planning to create a scripted field which states no of tickets older than 5 years in tracking project ticket.

any suggestions?

1 answer

1 accepted

0 votes
Answer accepted
Florian Bonniec
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Nov 15, 2023

Hi @rajeswari saravanan 

 

Not sure the script field is the best solution here as it apply at the ticket level.

Why are you not doing a JQL : updated <= -261w (5y is about 261weeks) then display the result into a gadget by project ?

 

Regards

Hi @Florian Bonniec 

Thanks for the reply. And it works.


We have a separate ticket (project for tracking )to track the project existing.So planned to add that scripted field in it.So it will show the details of the project like owner,last issue update in one place.Any suggestions?

Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Nov 15, 2023

I would not try to do this with scripted fields, it sounds like you need a dedicated report.  Your "project for tracking" issue type is not a good approach.

Suggest an answer

Log in or Sign up to answer