Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The instructions on this page describe how to define and execute a search in the project navigator using advanced search. You can also define and execute a search using basic search.Image Removed

...

What is advanced search?

An advanced search in the project navigator allows you to use structured and complex queries to search for projects.

...

As an example, we would like to see what Projects are on a "PREPARING" Status in the "Apps Management" Category. 

  1. Go

...

  1. to Projectrak →  

...

  1. Project navigator

  2. Click on the

...

  1.  Show PQL link to switch to advanced Search.

  2. Type any field you would like to filter through, "Status" and then

...

  1. type equals to (=) and finally

...

  1. type "ON TRACK"

  2. To filter through our projects, even more,

...

  1. type "Lead" and then type equals to (=)

...

  1.  and finally type "currentUser()"

  2. Our PQL is completed and we can now click on the

...

  1.  magnifying glass

...

  1.  that will show us our result. 

You can see how easy this can be in the video below. Image Removed

...

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":

...

In general, a query created using busing basic searching will be able to be translated to advanced search (i.e. PQL), and back again.

However, a query created using advanced search may not be able to be translated to Basic Search, particularly if:

  • The query contains

    an 

    an OR

     operator

     operator (Note:

     You

     You can have

    an 

    an IN

     operator

     operator and it will be translated, e.g. project in (A, B))

  • The query contains the same field two or more times

  • The query is too complex to translate to Basic Search

Setting the precedence of operators

You can use parentheses in complex PQL statements to enforce the precedence of operators, for example, if you want to find all development projects where Country is China or Continent is Asia:

...