Please help me to create JQL for checking all tickets that has commented during specified dates, hou

[Vache Manukyan]

Please help me to create JQL for checking all tickets that has commented during specified dates and hours.

[Ollie Guan]

Hi @Vache Manukyan,

If you have the following plugins installed

https://marketplace.atlassian.com/apps/6820/scriptrunner-for-jira?hosting=server&tab=overview

you can use the following JQL queries:

issueFunction in commented("before 2018/08/01") and issueFunction in commented("after 2018/07/25")

[Vache Manukyan]

Thank you so much, and what about hours?

[Alexey Matveev]

Hello,

You can not do it out of the box. You would need a plugin for it. There are couple of plugins available like ScriptRunner, JQL Search Extensions and other.

For example, if you have the JQL Search Extentions plugin, you could use the commentedOnDate function:

issue in commentedOnDate("2018-05-26")

You can find more info here:

https://jqlsearchextensions.atlassian.net/wiki/spaces/SEARCH/pages/30497099/JQL+Reference+Server#JQLReference(Server)-CommentedOnDate

[Vache Manukyan]

Thank you so much, and what about hours?