How to filter disapprovals using comments

Question

Hello everyone, how are you? I need help with the JQL query to perform a fail filter.
Our disapprovals are inserted through comments and I'm trying to filter comments that contain the word 'disapproval' ('Reprovado' on my language) within a period, but the filter is not being respected because it brings disapprovals from other periods. Could you help me please?

Angelica Machado · Answer

Hi Bill, thank you so much for your explanation.

I believe we'll need to change our worflow.

Bill Sheboy · Answer

Hi @Angelica Machado

I do not believe that is possible with the built-in JQL.

Your date range for the test is using worklog, which is for time keeping.  And the comment dates cannot be queried.

A possible work-around is to investigate the Atlassian Marketplace for addons to JQL which add this capability.

Kind regards,
Bill