Page Comparison

Table of Contents

maxLevel	1
style	none

...

The folder path for the selected testcase in the Test Repository, Test Execution page and requirement in the Requirements page displays in search view.

...

You can search on custom fields in Advanced mode, provided that the fields have been marked as Searchable when creating custom fields for both testcases and requirements. It is important to note that search terms cannot have spaces in them nor can custom fields use the name of a reserved field or be a duplicate of an existing field.

ZQL Reference

ZQL is a simple structured query language that allows you to string together the right fields to search on with values, using the appropriate operators and keywords. The search box allows auto-completion making it really easy to construct a query. You can place the cursor in the search box and press the space bar on your keyboard to view a list of fields, operators, keywords and values.
For example, if you are looking for all the failed tests in the Sample Project, you can enter the following query:

...

Below is a list of fields and operators you can use in ZQL queries:

Requirements		Test Cases		Test Executions
Field	Operators	Field	Operators	Field	Operators
altId	is is not !~ ~	testcaseId	in = !=	testcaseId	in = !=
creator	in = !=	estimatedTime	is is not = !=	notes	is is not ~ !~
details	is is not !~ ~	creator	in = !=	release	in = !=
release	in = !=	release	in = !=	project	in = !=
project	in = !=	project	in = !=	cycle	in = !=
id	is is not !~ ~	priority	is is not in = !=	tag	is is not in = !=
name	~ !~	altId	is is not !~ ~	executedBy	is is not in = !=
url	is is not !~ ~	version	in = !=	estimatedTime	is is not = !=
priority	is is not in = !=	versionId	in = !=	actualtime	is is not = !=
CustomField - Text	is is not !~ ~	automated	= !=	creator	in = !=
CustomField - LongText	is is not !~ ~	folder	in = !=	priority	is is not in = !=
CustomField - checkbox	in = !=	contents	!~ ~	altId	is is not ~ !~
CustomField - Picklist	is is not in = !=	name	!~ ~	version	in = !=
CustomField - Number	in = !=	comment	is is not !~ ~	versionId	in = !=
		tag	is is not in = !=	automated	= !=
		CustomField - Text	is is not !~ ~	folder	in = !=
		CustomField - LongText	is is not !~ ~	contents	!~ ~
		CustomField - checkbox	in = !=	name	!~ ~
		CustomField - Picklist	is is not in = !=	comment	is is not !~ ~
		CustomField - Number	in = !=	assignee	in = !=
				cyclephase	in = !=
				scheduleid	in = !=
				status	in = !=
				CustomField - Text	is is not !~ ~
				CustomField - LongText	is is not !~ ~
				CustomField - checkbox	in = !=
				CustomField - Picklist	is is not in = !=
				CustomField - Number	in = !=

List of Keywords

A keyword is used for advanced searching. A keyword in ZQL is a word or phrase:

joins two or more clauses together to form a complex ZQL query
alters the logic of one or more clauses
alters the logic of operators
has an explicit definition in a ZQL query
performs a specific function that alters the results of a ZQL query

Operators

Description

Example

AND

This is used to combine multiple clauses, that allows you to refine your search.

You can use parentheses to control the order in which clauses are executed.

project = "Sample Project" and priority is "empty"

OR

This is used to combine multiple clauses, that allows you to expand your search.

You can use parentheses to control the order in which clauses are executed.

project = "Sample Project" or project = "Project A(Version)"

NOT

This is used to negate individual clauses or a complex ZQL query (with more than one clause) using parentheses, thus allowing you to refine your search.

project = "Sample Project" not priority = "P3"

List of ZQL Operators

This section describes information about operators that are used for advanced searching.

The following is the list of ZQL Operators:

Operators	Description	Example
is	Searches for issues where the specified field has no value. Can be used with EMPTY fields only.	priority is "empty"
is not	Searches for issues where the specified field is not EMPTY. Not all fields are compatible with this operator; check the individual field reference.	priority is not "empty"
in	Searches for issues where the value of the specified field is one of multiple specified values. The values are specified as a comma-delimited list, surrounded by parentheses.	project in ( "Sample Project", "Project A(Version)")
not in	Searches for issues where the field value is not one of the specified values. The "NOT IN" operator will not match empty fields.	project not in ( "Sample Project", "Project A(Version)")
!~	Searches for issues where the field value is not a "fuzzy" match for the specified value in text fields. Can be used with text fields only.	name !~ "Test"
~	Searches for issues where the field value matches the specified value in text fields. Can be used with text fields only.	name ~ "Test"
=	Searches for issues where the value of the specified field exactly matches the specified value. Cannot be used with text fields.	project = "Sample Project"
!=	Searches for issues where the specified field value does not match the given value. Cannot be used with text fields.	project != "Sample Project"
is empty	Searches for items where the specified field does NOT have a value.	project = "Sample Project" and priority is "empty"
is not empty	Searches for items where the specified field has a value.	project = "Sample Project" and priority is "not empty"

Versions Compared

Old Version 12

New Version 13

Key

ZQL Reference

Requirements

Test Cases

Test Executions

List of Keywords

List of ZQL Operators