How write JQL filter which showing closed tasks after a specific hh:mm

[Александр Киселев]

How can I write jql filter which showing closed tasks after a specific hh:mm (time without date)
Used everywere date or date + time

I want to see which tasks are completed outside business time

[Alex Koxaras -Relational- · Accepted solution]

Hi @Александр Киселев and welcome to the community,

To my knowledge you can't do that using plain JQL. Scriptrunner would be my choice to achieve this, but there could be a high chance of identifying these issues using the JQL of Jira automation and by using smart values.

[Александр Киселев]

@Alex Koxaras -Relational- Hi, thanks. Do you have an example?

[Alex Koxaras -Relational-]

For the scriptrunner, no I don't have something ready to provide. But you can check on the adaptavist library for anything related. For the smart values you can always check the date and time section. Especially the date format {{[date].[dateformat]}}, can provide info only about time, e.g. mediumTime, longTime or fullTime.

[Riley Venable]

Use the following format: "yyyy/MM/dd HH:mm" or "yyyy-MM-dd HH:mm" and specify the date and time you want to filter for. Be sure to use quote-marks ("); if you omit the quote-marks, the number you supply will be interpreted as milliseconds after epoch (1970-1-1).

[Александр Киселев]

Thanks for your reply, but unfortunately you answered on not my question.