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

[rajeswari saravanan]

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

any suggestions?

[Florian Bonniec · Accepted solution]

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

[rajeswari saravanan]

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-]

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.