How to extract the data with the recentmost date
1 answer
Hello Anibrata,
Unfortunately, JIRA JQL does not have the functionality to return only the issue which is the most recent of a determined date, however, you can use the command ORDER BY to group the results by users and order it by the date field.
E.g:
ORDER BY name ASC, date DESC
Also, I checked that this functionality can be implemented by using the plugin Automation for JIRA, however, it will require a big amount of work depending on how many users do you have on your site. Anyway, here are the steps:
1 - Create a text custom field (In my rule, I configured the field with the name Workaround)
2 - Create a rule that will trigger everytime a user change the date field (In my rule, I configured the field with the name Due Date) AND the field name is a specific one
P.S: you will need to create an automation rule for each name you have on your site.
3 - Add a component to the rule that will add any value to the field Workaround for that specific issue
4 - Add a Branch rule that will clear the value of the field Workaround for all the other issues where the name is the same that the trigger issue.
Performing the steps above, you will be able to return only the issue which is the most recent of a determined date with this simple JQL query:
workaround = thevalueyouset
P.S: the rule might not work properly if the value of the date field be configured manually since the user can configure a date before the other issues edited, so I would recommend you to automatically configure the date field (by post function) with the last date.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.