Xray Tables Filters

Owned by Liliia Ostrovska
Feb 07, 2024
3 min read

SQL Connector for Jira Cloud offers GLOBAL and LOCAL filters:

  • MODIFIED FROM

  • TEST TYPE

  • TESTS

  • TEST EXECUTIONS

  • TEST RUN ASSIGNEES

Global and Local Filters.gif

 

If you apply the MODIFIED FROMfilter, it will be applied to all Xray tables. If the filter is not needed for a specific table, you can deselect it individually for each table.

Modified from.gif

 

There are also JQL and Basic filters available to apply. Unlike the MODIFIED FROM filter, JQL and Basic filters are applied to the Jira issue itself. The MODIFIED FROMfilter is applied to Xray fields.

The JQL and Basic filters are only applied to the following tables:

  • Tests

  • Test Steps

  • Preconditions

  • Test Preconditions

  • Test Set Tests

  • Test Plan Tests

  • Test Plan Executions

  • Test Plan Folders

  • Test Execution Tests

  • Test Execution Environment

  • Test Step Attachment

 

As per linking tables, JQL or Basic filter is applied to the main table only. All linking tables are marked with the link icon .

For example, the Test Preconditions table links the Test issue types (Xray tests) and the Precondition issue types. In this case, only the Test issue types will be filtered by JQL or Basic filter. This means you’ll get all the Test issue types that match the specified filter along with their preconditions.

 

The TEST TYPE filter allows selecting the specific type of tests for export: Manual, Generic, or Cucumber. You can select only one type at once.

 

The TEST filter allows selecting the specific test(s) for export.

The TEST EXECUTIONS filter allows selecting the specific test execution(s) for export.

The TEST RUN ASSIGNEE filter allows selecting the certain test run(s) for export performed by a specific user (assignee).

 

If you need to export test runs for specific tests, simply select them using the Tests filter.

 

If the specific tests you need to export are already grouped within a single test execution, just select that test execution using the Test Executions filter. You can select a few test executions.

When selecting a specific test execution in the Test Executions filter, and then selecting tests in the Tests filter that don't belong to the specified test execution, the exported table will be blank as a result.

 

If you need to export test runs assigned to a specific user, select their name in the Test Run Assignees filter. You can select a few assignees.