Refined for Jira includes some JQL functions to facilitate search and filtering. These can be used wherever JQL can be used.
What is JQL
JQL is the Jira Query Language Jira Query Language (JQL) is used by many of the APIs and as configuration options for searching. You can find out more here: https://www.atlassian. com/software/jira/guides/expand-jira/jql
Refined functions
JQL Function: ProjectType
...
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 the given type.
...
a certain type by using the syntax: refinedProjectsOfType(
...
Supported fields
...
Project
...
Supported operators
...
IN , NOT IN
"{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(
...
Supported fields
...
Project
...
Supported operators
...
IN , NOT IN
{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 Refined Site
...
site by using the syntax:refinedSite(
...
Supported fields
...
Project
...
Supported operators
...
"{key}")
Example:
Get Jira project (issues) for all projects placed in the Refined site with key creative‘creative': project in IN refinedSite("creative")
...
RefinedCategory
...
Filter on content placed in a Refined Category
...
category by using the syntax:refinedCategory(
...
Supported fields
...
Project
...
Supported operators
...
IN , NOT IN
"{key}")
Example:
Get Jira project (issues) for all projects placed in the Refined category with key products‘products’: project in IN refinedCategory("products")