JQL Extensions

Owned by Deniz Oğuz
Last updated: Aug 29, 2019
1 min read

Has Worklog Attribute

Search for issues which has a specific worklog attribute value. 

Search Issues with Worklogs Which has "Type of Work" Set to "Testing"
issue in hasWorklogAttribute("Type of Work", "Testing")


Search Issues with Worklogs Which are "Billable"
issue in hasWorklogAttribute("Billable", "yes")
Search Issues with Worklogs Which has "Invoice Number" "12345"
issue in hasWorklogAttribute("Invoice Number", "12345")


Worked Issues

Since JIRA 6.4, JIRA itself provides 3 JQL functions related to work logs. Please use them instead of workedIssues function provided by WorklogPRO. 

  • worklogAuthor: Search for issues a particular user has logged work against.
  • worklogComment: Search for issues that have a Comment in a work log entry which contains particular text.
  • worklogDate: Search for issues that have comments in work log entries that were created on, before, or after a particular date (or date range)
  • workRatio: Search for issues where the Work Ratio has a particular value.

For details of this JQL functions please check this documentation: https://confluence.atlassian.com/jira064/advanced-searching-fields-reference-720416679.html

workedIssues  JQL function returns all the issues worked in a period. It takes 2 arguments, start date and end date and returns worked issues within this period. Date-time format is the same used in date-time picker. 

issue in workedIssues("01/Jan/2017", "31/Jan/2017")