Writing a JQL That Will Return Results Within a Specific Date Range

Question

Hello!

So my team at work uses a Jira dashboard/JQL to pull in Jira items created by development that needs documentation. For this, we have them select a Supporting Needs - Documentation check box we created, and then use the following code to pull it onto our dashboard:

project in (product name) AND fixversion in versionMatches(year) AND "Supporting Needs" = Documentation AND ("Supporting Needs Completed" not in (Documentation) OR "Supporting Needs Completed" is EMPTY)

Similarly, when we are finished with the documentation, we select a Supporting Needs Completed - Documentation check box.

What I'm looking to do is to find out how many Jira items were completed within a specific date range using that SNC - Documentation check box. So something like:

project in (product name) AND ("Supporting Needs Completed" = Documentation)

But then also add in that the only results returning should be those where the check box was selected between 1/1/23 and 12/31/23.

Is this possible? I've used date ranges for when the status of a Jira item was changed to done and that works fine, but can't figure out how to do a date range for when a check box was selected.

Thanks!

Yuliia_Borivets__SaaSJet_ · Answer

Hi @Jenna Frenak

Status is one of the six fields that support past searches in JQL, but custom fields like "Supporting Needs" don't allow past searches.

I guess Issue History for Jira app can help to review past updates for a custom field within a specific date range. My team developed it to track any changes made to all standard and custom fields. You can add the Supporting Needs field as a separate column and see if it works for you.

Joseph Chung Yin · Answer

@Jenna Frenak -

Unfortunately, when a field (i.e. your checked boxes field) is updated by default it will just update the issue's "Updated" date.  There is no date/time tracking out of the box on field changes unless one access each issue's history.

One possible option that you may want to consider is creating a date/time custom field for your project, so if the checkboxes custom field changes, one can update the "date/time" custom field with the time that the change is made.  This can be achieve using Automation for Jira automation rule.

Afterward, you can use the new date/time field in your reporting need.

Hope this makes sense.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Technology Applications Team

Viasat Inc.