JQL to find issues that Description field was changed from IS EMPTY to IS NOT EMPTY for timeframe

Question

Good Afternoon Community,

Use Case: JQL to provide issues where the Description field was updated from IS EMPTY to IS NOT EMPTY between the timeframe of 11-12-2021 through today.

I'm on Jira Cloud Premium, and have ScriptRunner for Jira Cloud to leverage as well, but have had no luck writing the JQL correctly using the syntax CHANGED or WAS (in SR).

I know the information is captured in the history log, I just don't know how to manipulate the JQL to provide the results I need.

Any assistance is greatly appreciated.

Christine Corona · Answer

Is that true even with ScriptRunner for Jira Cloud? I read WAS wasn't available OOTB for description field but was hoping it may be fore SR.

Yuliia_Borivets__SaaSJet_ · Answer

Hi @Christine Corona

There is a way to find changed descriptions without JQL, if you're comfortable with Marketplace solutions. I'd like to propose an Issue History add-on developed by my team. Here you can see all changes to the required issue list. Date range filtering is available. If the description was added it will be highlighted with green (like on the screen below).

Let me know if it helps or if you have any questions.

Regards,

Yulia

Sandesh Shetty_fb9ccd · Answer

@Christine Corona

WAS operator can be used only with Assignee, Fix Version, Priority, Reporter, Resolution, and Status fields. It can't be used with description field.

Please find the doc. link for description field supported operators: https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-fields/#Advancedsearchingfieldsreference-DescriptionDescription