What syntax can be used to filter problem lists with resolution time within 3 days and 7 days respec

chengcheng zhang

What syntax can be used to filter problem lists with resolution time within 3 days and 7 days respectively (is the Created time to the Resolved time)

Bill Sheboy

Hi @chengcheng zhang -- Welcome to the Atlassian Community!

You cannot query issues that way with JQL.  It is not a SQL and so does not support such dynamic calculations on fields.

Some possible work-arounds depend on the frequency you need to do this and your desire to spend money/time:

• Need this infrequently: export the issues to a spreadsheet and perform the calculation there
• Need this more often, and can spend money on addons/apps: investigate the Atlassian Marketplace and purchase addons/apps to extend the features of JQL or improve the reporting
• Need this more often, and cannot spend money on addons/apps: there are several other options...
  • add a custom field to track resolution time, use an automation rule to set the field, and then you can search/report on it
  • using whatever existing tools you have, build an application which can call (i.e. pull) the REST API to gather issues and perform the reporting
  • using whatever existing tools you have, set up a webhook to push the data out of Jira as it changes to support your reporting

Kind regards,
Bill