(8.1.12) Operators and keywords
- Leo Díaz Murillo
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 will be suggested by our autocomplete functionality and how they work with different field types.
| Field type | Common operator | Text operator | Numeric operator | Items operator | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| = | != | 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 ) |
|---|
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 ) |
|---|
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.