How to filter disapprovals using comments

[Angelica Machado]

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?

[Bill Sheboy]

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

[Angelica Machado]

Hi Bill, thank you so much for your explanation.

I believe we'll need to change our worflow.