Important note Retirement of icTime and Retirement of biz on December 29th, 2023

JQL Functions

Owned by iConcept Support
Last updated: Jan 27, 2020 by Reinhard Lopinski
2 min read

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