Versions Compared

Key

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

Projectrak includes JQL functions to search issues by the Advanced Searching feature

These are project functions, so they must start with "project" and return a list of projects, so they must use the "IN" or "NOT IN" operators.

Code Block
JQL> project IN projectField...

...

It is important to notice that the PQL will have double quotation marks in it, so you are going to need to change them into single quotations marks. Please, be careful when doing this. 

Example: You need to find all issues which their project is type "Business" and their lead is "User 1"

Use the "View issues" feature to create a search based on a project search.
Image Removed
(warning) Please notice that you need to change double quotation marks for single quotation marks. The ORDER Clause is not important in the issue navigator, you can remove it.

Code Block
original PQL> lead = "user1" AND type = "business"

replaced PQL> lead = 'user1' AND type = 'business'

...

We will use the same example: You need to find all issues which their project is type "Business" and their lead is "User 1"

1. Get the filter id

Get the filter ID from the page's URL, if you click on the filter in a variable called "filterId" or if you.
Image Removed

...


2. Go to the issue navigator and type the query.

Code Block
project in projectFieldsFilter(111)

Image Removed

...