Overdue Fixversions

Question

I would like to send  fixversions list along with due dates to my team..  I mean, Fixversions   that are overdue (Beyond Release Date / Release date is already passed).. by email.

I would like to use Jira Automation using Automation under Space Admin privilege..

Kindly note that, I don't want to use any Other Add-ons.

Bill Sheboy · Answer

Hi @Sridhar Gandla

Would you please provide more context for your question?  That will help the community provide better suggestions.

In your context, please include any automation rules you have already tried and why they may not be working as you expected.

Until we see that information...

* Releases / Versions have built in fields for Name, Start Date, Release Date, Status, etc.
* Work Items (i.e., issues) have built-in fields for Due Date and Fix Versions, where a Work Item may be associated to zero-to-many specific Releases
* JQL is used to search for Work Items, but there are no JQL features to search by other than the names or ids of Releases in the Fix Versions...thus the Release Dates cannot be checked to detect "overdue"

Assuming you are looking at more than one Work Item, that would be a list of Work Items containing a list of Fix Versions: nested lists.  Using an automation Lookup Work Items action with JQL and the flatten function, or list filtering, one could identify any included Fix Versions which are after the current date, {{now}} or some other date, and then use that for an email, message post, etc.

Kind regards,
Bill

Bill Sheboy · Answer

Hi @Mugilan Sukumar

What is the source of the information you posted?

There is no JQL function overdue() in Jira, built-in features.

Kind regards,
Bill

Sridhar Gandla · Answer

Thank you for response !! I might not have asked my question correctly... I am sorry for that,  My requirenent as follows.  If I have 10 Fixversions are unreleased.. only 6 Fixversions are overdue .. I would like to get those fixversion names and their Due date in single email and send it across to the mailing list.

The above will list down the Issues in that fixversion.  My need is to get fixversions list along with due dates.