For support issues please visit https://jira.deiser.com/support
What's next? Check our backlog and vote the ideas here: https://trello.com/b/kxrEGuIW/profields-public-backlog
For support issues please visit https://jira.deiser.com/support
What's next? Check our backlog and vote the ideas here: https://trello.com/b/kxrEGuIW/profields-public-backlog
The instructions on this page describe how to define and execute a search in the Project Navigator using the advanced search. You can also define and execute a search using the Basic searching.
An advanced search in the Project Navigator allows you to use structured queries to search for projects. Your search results will be displayed in the Project Navigator, where you can export them to MS Excel. You can also save your advanced searches as Profields filters if you wish.
When you perform an advanced search, you are using our Profields Query Language (PQL).
A simple query in PQL consists of a field, followed by an operator, followed by one or more values. For example, the following simple query will find all projects whose Technology ( id=23 ) is "Java":
profield[23] = "Java" |
---|
(This example uses the Profield's project field "Technology" which id is "23", the EQUALS operator, and the value "Java"
.)
Be aware that it is not possible to compare two fields.
In general, a query created using 'Basic Searching' will be able to be translated to 'Advanced Searching' (i.e. PQL), and back again.
However, a query created using 'Advanced Searching' may not be able to be translated to 'Basic Searching', particularly if:
project in (A, B)
)You can use parentheses in complex PQL statements to enforce the precedence of operators.
For example, if you want to find all development projects which Country ( id=27 ) is China or Continent ( id=590 ) is Asia:
category = development AND ( profield[27] ~ China OR profield[590] ~ Asia ) |
---|
Note that if you do not use parentheses, the statement will be evaluated left-to-right.
You can also use parentheses to group clauses.
A keyword in PQL is a word or phrase that does (or is) any of the following:
Note that you can use parentheses to control the order in which clauses are executed.
Find all projects which category are marketing and IT Systems:
category = marketing and "IT Systems" |
---|
Used to combine multiple clauses, allowing you to expand your search.
Note that you can use parentheses to control the order in which clauses are executed.
(Note: also see IN, which can be a more convenient way to search for multiple values of a field.)
Find all projects which category are marketing or IT Systems::
category = marketing or "IT Systems" |
---|
A field in PQL is a word that represents a Profields field (a field that has already been defined in Profields) and also especified project fields. In a clause, a field is followed by an operator, which in turn is followed by one or more values. The operator compares the value of the field with one or more values on the right, such that only true results are retrieved by the clause.
Note: these fields does not support auto-complete.
A Profields Field is a field that has already been defined in Profields. You can search projects by a Profields field value and can be six different types and each of them have their supported operators.
Text
= | != | ~ | !~ | > | >= | < | <= | IN | NOT IN |
---|---|---|---|---|---|---|---|---|---|
User
= | != | ~ | !~ | > | >= | < | <= | IN | NOT IN |
---|---|---|---|---|---|---|---|---|---|
List
= | != | ~ | !~ | > | >= | < | <= | IN | NOT IN |
---|---|---|---|---|---|---|---|---|---|
Datetime
= | != | ~ | !~ | > | >= | < | <= | IN | NOT IN |
---|---|---|---|---|---|---|---|---|---|
Original Estimate
= | != | ~ | !~ | > | >= | < | <= | IN | NOT IN |
---|---|---|---|---|---|---|---|---|---|
Float
= | != | ~ | !~ | > | >= | < | <= | IN | NOT IN |
---|---|---|---|---|---|---|---|---|---|
This is a field that allows you to search project by its Key.
key = projectKEY |
---|
= | != | ~ | !~ | > | >= | < | <= | IN | NOT IN |
---|---|---|---|---|---|---|---|---|---|
This is a field that allows you to search project by Category ID and Category NAME
category = categoryID |
---|
category = categoryNAME |
---|
= | != | ~ | !~ | > | >= | < | <= | IN | NOT IN |
---|---|---|---|---|---|---|---|---|---|
The 'Available Fields' button in Advanced Searching enables you to use Profields fields in a clause without knowing their 'id'.
To use Available Fields button in advanced searching:
An operator in PQL is one or more symbols or words which compares the value of a field on its left with one or more values on its right, such that only true results are retrieved by the clause.
List of Operators:
The "=
" operator is used to search for projects where the value of the specified field exactly matches the specified value. (Note: cannot be used with text fields; see the CONTAINS operator instead.)
To find projects where the value of a specified field exactly matches multiple values, use multiple "=
" statements with the AND operator.
Find all projects which "Category" is equals to "marketing":
category = marketing |
---|
Find all projects which "Category" is equals to "IT Systems":
category = "IT Systems" |
---|
The "!=
" operator is used to search for projects where the value of the specified field does not match the specified value.
Find all projects which "Category" is not equals to "marketing":
category != marketing |
---|
Find all projects which "Category" is not equals to "IT Systems":
category != "IT Systems" |
---|
The ">
" operator is used to search for projects where the value of the specified field is greater than the specified value.
To see a field's supported operators, check the individual field reference.
Find all projects which Budget ( id=345 ) greater than 100k:
profield[345] > 100000 |
---|
Find all overdue projects which End date ( id=298 ) greater than 2014/06/30:
profield[298] > 2014/06/30 |
---|
The ">=
" operator is used to search for projects where the value of the specified field is greater than or equal to the specified value.
To see a field's supported operators, check the individual field reference.
Find all projects which Budget ( id=345 ) greater than or equals to 100k:
profield[345] >= 100000 |
---|
Find all overdue projects which End date ( id=298 ) greater than or equals to 2014/06/30:
profield[298] >= 2014/06/30 |
---|
The "<
" operator is used to search for projects where the value of the specified field is less than the specified value.
To see a field's supported operators, check the individual field reference.
Find all projects which Budget ( id=345 ) less than 100k:
profield[345] < 100000 |
---|
Find all overdue projects which End date ( id=298 ) less than 2014/06/30:
profield[298] < 2014/06/30 |
---|
The "<=
" operator is used to search for projects where the value of the specified field is less than or equal to than the specified value.
To see a field's supported operators, check the individual field reference.
Find all projects which Budget ( id=345 ) less than or equals to 100k:
profield[345] <= 100000 |
---|
Find all overdue projects which End date ( id=298 ) less than or equals to 2014/06/30:
profield[298] <= 2014/06/30 |
---|
The "IN
" operator is used to search for projects 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.
Find all projects which categories are marketing or IT Systems:
category in (marketing, "IT Systems") |
---|
The "NOT IN
" operator is used to search for projects where the value of the specified field is not one of multiple specified values. The values are specified as a comma-delimited list, surrounded by parentheses.
Find all projects which categories are not marketing nor IT Systems:
category not in (marketing, "IT Systems") |
---|
The "~
" operator is used to search for projects where the value of the specified field matches the specified value.
The "%" sign is used to define wildcards (missing letters) both before and after the pattern.
Find all projects where the Customer ( id=944 ) is "DEISER":
profield[944] ~ "DEISER" |
---|
Find all projects where the Customer ( id=944 ) starts with "DEISER":
profield[944] ~ "DEISER%" |
---|
Find all projects where the Customer ( id=944 ) ends with "DEISER":
profield[944] ~ "%DEISER" |
---|
Find all projects where the Customer ( id=944 ) contains "DEISER":
profield[944] ~ "%DEISER%" |
---|