Refined JQL functions

Owned by Johannes Laatu (Deactivated)
Last updated: May 25, 2023 by Madzy Soetman
1 min read

Jira Query Language (JQL) is used by many APIs and as configuration options for searching. Refined for Jira offers some additional JQL functions to facilitate search and filtering.

  • Supported field: project

  • Supported operators: IN, NOT IN

ProjectType

Perform searches based on projects of a certain type by using the syntax:
refinedProjectsOfType("{type}")

Examples:

  • Find issues in projects of type Service Desk:
    project IN refinedProjectsOfType("service_desk")

  • Find issues in projects of type Software aka Jira Agile:
    project IN refinedProjectsOfType("software")

  • Find issues in projects of type Business aka Jira Core:
    project IN refinedProjectsOfType("business")

PortalProject

Filter on Jira projects with underlying Service portal IDs by using the syntax:
refinedPortal({portal ID})

Example:
Get Jira project (issues) for project corresponding to portal with ID 43:
project IN refinedPortal(43)

RefinedSite

Filter on content placed in a site by using the syntax:
refinedSite("{key}")

Example:
Get Jira project (issues) for all projects placed in the Refined site with key ‘creative':
project IN refinedSite("creative")

RefinedCategory

Filter on content placed in a category by using the syntax:
refinedCategory("{key}")

Example:
Get Jira project (issues) for all projects placed in the Refined category with key ‘products’:
project IN refinedCategory("products")