(8.1.5) JQL (Jira Query Language) functions

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.

JQL> project IN projectField...

projectFieldsQuery (PQL query)

This function returns a list of projects based on a Project Query Language (PQL). You can configure a PQL query in the project navigator's advanced mode. Also, if you need a simple query, you can configure it on the Basic Mode and switch to the  Advanced Mode to copy it and then paste it as the argument of the function.

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.

 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.

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

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

projectFieldsFilter(Filter ID) 

The mechanism of this function is the same as the projectFieldsQuery but it uses a previous saved filter to search for projects.

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.

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

project in projectFieldsFilter(111)