JQL (Jira Query Language) is the most powerful and flexible way to search for your issues in Jira. 

Xray adds a lot of functions and new custom fields that can help you search and find the information you need. 

How to use Xray JQL functions & Custom fields?

You can use them to: 

  • Search for issues, using JIRA Search 
  • Customized your reports, by using advanced features
  • Create filters than can be displayed into dashboards
  • Create filters that can be used to configure gadgets



Xray JQL functions to remember


JQL FunctionParametersPurposeExample
requirementTestsP1 - Requirement Issue Key/Filter of Requirement IssuesReturns a list of Test issues associated with the input Requirement issue key or saved filter with Requirements.
(1)
issuetype = 'Test' 
   and key in requirementTests('DEMO-10')
(2)
issuetype = 'Test' 
   and key in requirementTests('Requirements saved filter')
testsWithoutTestExecutionNoneReturns a list of Tests that are not associated with a Test Execution to be executed
(1)
issuetype = Test and issue in testsWithoutTestExecution()
testTestExecutions 

P1 - Test Issue Key/Id or Filter Name/Id

P2 - Test Run Status list separated by "|"(pipe) (Optional)

Returns a list of test executions associated with the input Test Issues from P1 optionally filtered by the current Test status in each Test Execution issue.

Parameter P1 can either be a single Test issue key or Id or a saved filter name or id containing multiple Test issues.

Possible Test Run Status values are: PASS, FAIL, EXECUTING, ABORTED, TODO and all custom statuses.

(1)
issuetype = 'Test Execution' 
   and issue in testTestExecutions('DEMO-9')

(2)

issuetype = 'Test Execution' 
   and issue in testTestExecutions('DEMO-9', 
                                   'PASS')

(3)

issuetype = 'Test Execution' 
   and issue in testTestExecutions(
                      'Saved Test Filter', 
                      'PASS')

There are a lot of JQL functions that you can explore and add to your searches or filters. Please check the full list at:

https://docs.getxray.app/display/XRAY/Enhanced+querying+with+JQL