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)"	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")	get all issues in project "GOSD" having the project "CXMP" being assigned as Accounting project 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	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 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

ictime | time tracking 5.x

JQL Functions

Analytics

issueWithUncharged Worklog - changes

Example - issueWithUnchargedWorklog

Defining a filter using Issue search

Add Filter result to Dashboard using Gadget "Filter-Result"

Using the saved filter in ictime Reporting

Related content