/
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 versionJQL Function namePurposeParameterExample UsageExplanation
5.7.8.0IssueWithAccForreturn issues assigned to a project having a value set in Custom Field "Accounting project (icTime)"
  • first
    • project key in which issues should be searched for (source project)
  • second
    • project key used in "Accounting project" custom field used in any issue in source project
  • issue in IssueWithAccFor("GOSD", "CXMP")
5.8.3.31issueWithUnchargedWorklogreturns issues only if issue has not invoiced (IcTime) worklog in the last given number of days back
  • first
    • Number of days considered in the past. Worklogs older than the given number of days will not be considered.
  • second (optional)
    • Number of days considered in the past. Worklogs newer than the given number of days will not be considered.
  • single parameter usage
    • project in (WFLT, XA) AND issue in issueWithUnchargedWorklog(30)
  • range usage
    • project in (WFLT, XA) AND issue in issueWithUnchargedWorklog(30, 10)
  • limit issues to projects (WLFT and XA) and show all Issues having not billed worklogs in the last 30 days
  • limit issues to projects (WLFT and XA) and show all Issues having not billed worklogs in the last 30 days NOT considering work logs in the last 10 days
5.7.0 and higherissueWithUnchargedWorklogreturns issues only if issue has not invoiced (IcTime) worklog in the last given number of days backNumber 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

VersionChangeRemarks
icTime-5.8.2.16Parameter 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
More like this
Custom Field "Accounting project (icTime)"
Custom Field "Accounting project (icTime)"
More like this
Fix Work Logs (Warnings)
Fix Work Logs (Warnings)
More like this