This page describes functions used for advanced searching within Jira. A function in JQL, which stands for Jira Query Language (not to be confused with Java Query Language), appears as a word followed by parentheses, which may contain one or more explicit values or Jira fields.
 |
The functions described below are only applicable if Zephyr Scale is installed. |
How to use advanced searchHow to use advanced search
-
Select Issues > Search for Issues from the Jira main menu.
Click the image to enlarge it.
-
On the Search screen, click Advanced.
Click the image to enlarge it.
-
Fill in your desired JQL search using a JQL function, then click Search.
The issues matching the search criteria will appear in the list.
Available JQL functions
hasTestCoverage()
Search for issues that are covered by test cases.
| Syntax | hasTestCoverage() |
| Supported fields | Issue |
| Supported operators | IN, NOT IN |
| Examples | project = MGS and issue in hasTestCoverage() |
coveredBy()
Search for issues that are covered by test cases that have a specified testCaseKey.
| Syntax | coveredBy([testCaseKey1], [testCaseKey2], [testCaseKeyN]) |
| Supported fields | Issue |
| Supported operators | IN, NOT IN |
| Examples | project = MGS and issue in coveredBy("MGS-T1") |
coveredByTestCasesHavingField()
Search for issues that are covered by test cases that match the specified fields and values. Custom fields are supported.
| Syntax | coveredByTestCasesHavingField([field], [value1], [value2], [valueN]) |
| Supported fields | Issue |
| Supported operators | IN, NOT IN |
| Examples |
project = MGS and issue in coveredByTestCasesHavingField("status", "Draft") |
hasTestResult()
Search for issues covered by test cases that are linked with a test result.
| Syntax | hasTestResult() |
| Supported fields | Issue |
| Supported operators | IN, NOT IN |
| Examples | project = MGS and issue in hasTestResult() |
hasAllLastTestResults()
Search for issues covered by test cases that match the specified last test result statuses.
| Syntax | hasAllLastTestResults([testResultStatus1], [testResultStatusN]) |
| Supported fields | Issue |
| Supported operators | IN, NOT IN |
| Examples | project = MGS and issue in hasAllLastTestResults("Pass") |
hasAnyLastTestResults()
Search for issues covered by test cases that match any of the specified last test-result statuses.
| Syntax | hasAnyLastTestResults([testResultStatus1], [testResultStatusN]) |
| Supported fields | Issue |
| Supported operators | IN, NOT IN |
| Examples | project = MGS and issue in hasAnyLastTestResults("Pass") |
impactsTestResult()
Search for issues that impact test results.
| Syntax | impactsTestResult() |
| Supported fields | Issue |
| Supported operators | IN, NOT IN |
| Examples | project = MGS AND issue in impactsTestResult() |
hasLinkedTestCycle()
Search for issues that are linked with a test cycle.
| Syntax | hasLinkedTestCycle() |
| Supported fields | Issue |
| Supported operators | IN, NOT IN |
| Examples | project = MGS and issue in hasLinkedTestCycle() |
hasAllLinkedTestCyclesWithAllLastTestResults()
Search for issues that are linked with a test cycle with test cases that match the specified last test-result statuses.
| Syntax | hasAllLinkedTestCyclesWithAllLastTestResults() |
| Supported fields | Issue |
| Supported operators | IN, NOT IN |
| Examples | project = MGS and issue in hasAllLinkedTestCyclesWithAllLastTestResults("Pass") |
hasAnyLinkedTestCycleWithAnyLastTestResult()
Search for issues that are linked with a test cycle that has test cases that match any of the specified last test-result statuses.
| Syntax | hasAnyLinkedTestCycleWithAnyLastTestResult([testResultStatus1], [testResultStatusN]) |
| Supported fields | Issue |
| Supported operators | IN, NOT IN |
| Examples | project = MGS and issue in hasAnyLinkedTestCycleWithAnyLastTestResult("Pass") |