Custom JQL (Data Center)
- Zhenya Elfimova
Why custom JQL?
Data Center version has Secured Work Logs functionality, which was implemented to make work logs invisible for everyone except a specific list of team members, who are permitted to track work logs, such as Team Leads or controllers with a custom role.
As worklogs are secured, they are stored and processed in a table of your database another way. Issues cannot be found by sending JQL requests, which contain standard JQL fields.
Custom JQL fields return all issues (with secured and public worklogs). Results are filtered according to Timesheet Builder permissions and Jira project permissions.
Introduction
Custom JQL fields
There are three work log fields, which have custom analogue.
Jira JQL | Actonic JQL |
|---|---|
worklogAuthor | sWorklogAuthor |
worklogDate | sWorklogDate |
worklogComment | sWorklogComment |
Syntax
We have implemented these custom JQL fields, so that they have the same behavior and list of supported operators and functions as standard fields.
You can search for issues as you usually do, create a custom filter using the custom fields.
Search by worklog author
Supported operators
=
!=
not in
in
Supported functions
currentUser()
Examples
Task | JQL |
|---|---|
issues with work logs of a user | sWorklogAuthor = user1 |
issues with work logs of selected users | sWorklogAuthor in (user1, user2) |
issues with work logs of all users except selected | sWorklogAuthor not in (user1, user2) |
issues with work logs of current user | sWorklogAuthor = currentUser() |
issues with work logs of group of users | sWorklogAuthor in membersOf("jira-administrators") |
Search by work log date
Supported operators
=
!=
<
<=
>
>=
not in
in
Supported functions
currentLogin(), lastLogin()
endOfDay(), endOfWeek(), endOfMonth(), endOfYear()
startOfDay(), startOfWeek(), startOfMonth(), startOfYear()
now()
Examples
Task | JQL |
|---|---|
issues with work logs added this month | sWorklogDate >= startOfMonth() and sWorklogDate <= endOfMonth() |
issues with work logs added this year | sWorklogDate >= startOfYear() and sWorklogDate <= endOfYear() |
Search by work log comment
Supported operators
~
!~
is
is not
Examples
Task | JQL |
|---|---|
issues with work log comment “testing“ | sWorklogComment ~ testing |
issues with empty work logs | sWorklogComment is EMPTY |