(8.5.0) PQL functions
- Leo Díaz Murillo
In this section, you will find our PQL functions. A function performs a calculation on specific Jira data such as the current user and many more. These functions may contain one or more explicit values or project fields, that will help you retrieve the information you are looking for in the project navigator, filtering through that specific field or value. Here you can find the list of Projectrak PQL functions:
currentUser()
This function will allow you to search for the projects in which the current logged user is included. This function works with the lead field (Jira native) and with any user fields you can create with Projectrak, and it doesn't matter if it's a single or multiple user picker field.
Please note, that (currentUser()) will work with both operators:
IN: will show the Projects where the current user is selected.
NOT IN: will show you the Project in where the current user is not selected.
How to use currentUser()
This function, can only be used in the project navigator's advanced search and it will apply both List and Releases view and you can use it with any user type field (including the project lead). You only need to take into account what field you want to filter through and then write it down as a PQL. Here you can find an example:
lead in (currentUser()) ORDER BY assignee ASC
