/
JQL Functions
Important note Retirement of icTime and Retirement of biz on December 29th, 2023
JQL Functions
Starting with Version 5.7.0 ictime, JQL Functions can be used
ictime version | JQL Function name | Purpose | Parameter | Example Usage | Explanation |
---|---|---|---|---|---|
5.7.8.0 | IssueWithAccFor | return issues assigned to a project having a value set in Custom Field "Accounting project (icTime)" |
|
|
|
5.8.3.31 | issueWithUnchargedWorklog | returns issues only if issue has not invoiced (IcTime) worklog in the last given number of days back |
|
|
|
5.7.0 and higher | issueWithUnchargedWorklog | returns issues only if issue has not invoiced (IcTime) worklog in the last given number of days back | Number of days considered in the past. Worklogs older than the given number of days will not be considered. | project in (WFLT, XA) AND issue in issueWithUnchargedWorklog(30) | limit issues to projects (WLFT and XA) and show all Issues having not billed worklogs in the last 30 days |
issueWithUncharged Worklog - changes
Version | Change | Remarks |
---|---|---|
icTime-5.8.2.16 | Parameter handling has changed. Providing "0" for days back no returns all Issues having at least one work log which is not charged. | |
Example - issueWithUnchargedWorklog
Defining a filter using Issue search
Details on defining and saving filters can be found in the Atlassian JIRA Documentation: https://confluence.atlassian.com/jirasoftwarecloud/saving-your-search-as-a-filter-764478344.html
Add Filter result to Dashboard using Gadget "Filter-Result"
Using the saved filter in ictime Reporting
Related content
Using JQL Queries in Reporting
Using JQL Queries in Reporting
More like this
Customer specific accounting for Jira Service Desk Organizations
Customer specific accounting for Jira Service Desk Organizations
Read with this
Create Reports
Create Reports
More like this
Custom Field "Accounting project (icTime)"
Custom Field "Accounting project (icTime)"
More like this
Timesheet
Timesheet
More like this
Fix Work Logs (Warnings)
Fix Work Logs (Warnings)
More like this