Document toolboxDocument toolbox

Operators and keywords

Owned by Leo Díaz Murillo
Last updated: Mar 15, 2023
2 min read

Operators suggested by field type

An operator in PQL is one or more symbols or words that compare the value of a field on its left with one or more values on its right so that only true results are retrieved by the clause.  And a Projectrak field is a field that has already been defined in Projectrak. You can search for projects by a Projectrak field value which can be one of six different types, each with supported operators. 

Here, you can find a list of the operators that you can use in advanced serch: 



Common operator

Text operator

Numeric operator

Items operator

Field type

=

!=

IS

IS NOT

~

!~

>

>=

<

<=

IN

NOT IN

Function text





















Text (Single and Multiple line)

















Project Description

















Project URL

















Project key













Project name













Date









Number









Duration









Status













Priority













List (Single and Multiple choices)













User (Single and Multiple choices)













Group (Single and Multiple choices)













Project (Single and Multiple choices)













Project category













Project type

















Project lead

















Keywords suggested by autocomplete

A keyword in PQL is a word or phrase that does (or is) any of the following:

  • Joins two or more clauses together to form a complex PQL query

  • Alters the logic of one or more clauses

  • Alters the logic of operators

  • Has an explicit definition in a PQL query

  • Performs a specific function that alters the results of a PQL query

Keep in mind Projectrak's reserved words

A reserved word is a word that cannot be used as a value in our PQLs, such as the name of a system field or an operator. These words are "reserved from use". These might show errors in your PQL when you choose to filter through them. 

To avoid these errors, and in case you have a value that is the same as a reserved word, you can write that value between double quotation marks.

Here is a list of Projectrak' reserved words:

System Fields:
key, lead, type, category, description, name, assignee, url
pf[x] ('x' being a number)

Connectors:
and, or, order, by, asc, desc.

Operators:
not in, in, is, is not, =, !=, >=, <=, >, <, ~, !~.

Other characters to keep in mind:
Parenthesis "(", ")", and comas ",". 

List of keywords

AND

Used to combine multiple clauses, allowing you to refine your search.

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

Example

Find all projects where the value of Category is marketing and IT Systems:

category = marketing AND ( Country ~ Spain OR Continent ~ Europe )

category = marketing AND ( Country ~ Spain OR Continent ~ Europe )

OR

Used to combine multiple clauses, allowing you to expand your search.

Notes: 

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

  • Also see IN, which can be a more convenient way to search for multiple values of a field.

Examples

Find all projects where the value of Category is marketing or IT Systems:

category = business OR ( Country ~ Italy OR Continent ~ Europe )

category = business OR ( Country ~ Italy OR Continent ~ Europe )

EMPTY

This keyword is used to be able to show the Project fields that have empty values. 

Notes:

  • You can only use this keyword with the IS or IS NOT operator. 

Example

Find all the projects where "Project Status" is empty and use Bulk Operations in order to populate those empty fields with the status that starts the project's process.