To learn more about Tempo products, please visit our Help Center. For support, see our Support Portal.

Refining a Folio scope by using a JQL filter

Whenever possible, defining the Folio scope by using a JQL filter gives you the most flexibility to hone in on the relevant issues for your Folio, which will reduce the number of issues the Folio pulls in, and improve performance down the line.

How to create a JQL filter: https://www.atlassian.com/blog/jira-software/jql-the-most-flexible-way-to-search-jira-14

JQL Options & Implications

  • By Project

This is the most commonly used type of filtering to find relevant issues.

  • Find issues that belong to the Project that has the name "ABC Project":
    project = "ABC Project"

  • Find issues that belong to the project that has the key "ABC":
    project = "ABC"

  • Find issues that belong to the project that has the ID "1234":
    project = 1234

  • By date created

If your project has issues since the beginning of time, you can start by limiting it to issues created in the last year, for example.

  • Find all issues created before 12th December 2010:
    created < "2010/12/12"

  • Find all issues created on or before 12th December 2010:
    created <= "2010/12/13"

  • Find all issues created on 12th December 2010 before 2:00pm:
    created > "2010/12/12" and created < "2010/12/12 14:00" 

  • Find issues created less than one day ago:
    created > "-1d"

  • Find issues created in January 2011:
    created > "2011/01/01" and created < "2011/02/01"

  • Find issues created on 15 January 2011:
    created > "2011/01/15" and created < "2011/01/16"

  • By custom field

If you have a custom field that you use to organize all the issues that are relevant to the folio, this might be useful to you.

Note: it is safer to search by custom field ID than by custom field name. It is possible for a custom field to have the same name as a built-in Jira system field; in which case, Jira will search for the system field (not your custom field). It is also possible for your Jira administrator to change the name of a custom field, which could break any saved filters that rely on that name. Custom field IDs, however, are unique and cannot be changed.

  • Find issues where the value of the "Location" custom field is "New York":
    location = "New York"

  • Find issues where the value of the custom field with ID 10003 is "New York":
    cf[10003] = "New York"

  • Find issues where the value of the "Location" custom field is "London" or "Milan" or "Paris":
    cf[10003] in ("London", "Milan", "Paris")

  • Find issues where the "Location" custom field has no value:
    location != empty

  • By Issue Type

If you want to only include certain issue types like Epic and Story, and not include other issue types like Bug and Support, this will solve that use case.

Note: it is safer to search by type ID than type name. It is possible for your Jira administrator to change the name of a type, which could break any saved filter that rely on that name. Type IDs, however, are unique and cannot be changed.

  • Find issues with an issue type of "Bug":
    type = Bug

  • Find issues with an issue type of "Bug" or "Improvement":
    issueType in (Bug,Improvement)

  • Find issues with an issue type ID of 2:
    issueType = 2

  • By Time spent

If you only want to pull in issues that have time logged on them already, this is the filter you need.

You need to be aware that if you are at the beginning of the project, then the Progress bar will not show you the entirety of the work that must be accomplished, but in some cases this may be purposeful.

  • Find issues where the time is logged:

timeSpent is not empty

timeSpent > 0

  • By Team

If you only want to pull in issues that have a specific Tempo Team, this is the filter you need.

See documentation for how to add Team to your issues.

  • Find issues where Team is Dev Team 1:

Team = ”Dev Team 1”

  • By Resolution Date

If you only want to exclude issues that were resolved prior to the start of your Folio, this is the filter you need. You can use this instead of the Date created if you need to make sure that issues that are still in progress are included in the Folio

  • Find issues that have been resolved prior to the start of the Folio.

resolved >= 2020-08-13

  • By Worklog Author

If you only want to include only issues that have been worked on by a certain Team or Jira group like jira-administrators, then you can use this to narrow down the scope of the Folio.

  • Find issues that have been worked on by Jira group “Marketing”.

worklogAuthor in membersOf("marketing")

worklogAuthor in team("Name of the TeamA","Name of the TeamB")

  • By Account

If you only want to include only issues that belong to an open account, then you can use this JQL.

  • Find issues that are associated with an open Account.

Account in accountsByStatus("Open")

If you want to make sure your scope includes multiple criteria, e.g. issues in a certain project, of a certain issue type, and created in 2020, you need to use the operator AND to connect all these statements in your JQL.

project in (“Development”, “Apps”) AND issueType in (Epic,Story) AND (created > "2020/01/01" and created < "2020/12/31")

See JQL documentation for more information: https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-fields/

For more details about Tempo specific JQL: Tempo JQL functions for Timesheets 9.x to 15.x

Looking for labels? They can now be found in the details panel on the floating action bar.

Related content