/
JQL Example
Document toolboxDocument toolbox

JQL Example

Owned by Attila Bordás
Last updated: May 12, 2023 by Róbert András Borvíz (Unlicensed)
JIRA_URL/rest/jttp-rest/latest/worklog-query/jql?groupUsers=users:JIRAUSER10000&groupUsers=users:JIRAUSER10001&worklogStartDate=2017-11-24&worklogEndDate=2017-12-16&jql=Project=Project

JIRA_URL/rest/jttp-rest/latest/worklog-query/jql?groupUsers=group:jira-administrators&groupUsers=users:JIRAUSER10000&worklogStartDate=2017-11-24&worklogEndDate=2017-12-16&jql=Project=Project

JIRA_URL/rest/jttp-rest/latest/worklog-query/jql?customFieldsFilter=[10120, 10500]&groupUsers=users:JIRAUSER10000&groupUsers=users:JIRAUSER10001&worklogStartDate=2017-11-24&worklogEndDate=2017-12-16&jql=Project=Project

It returns each worklog created by the specified users or groups between 2017.11.24 and 2017.12.16  and based on the provided JQL expression according to the permissions of the user running the query.

A possible response:

[
	{
		"customFields":{
			"Epic Colour":"ghx-label-9",
			"Epic Status":"To Do",
			"Rank":"0|i0001b:",
			"Sprint":"",
			"Epic Name":"EpicName",
			"Epic Link":"",
			"Story Points":""
		},
		"details":{
			"issueAffectedVersions":["1.0.2"],
			"issueAssignee":"testUser",
			"issueComponents":[],
			"issueCreated":"Nov 25, 2017 9:10:04 AM",
			"issueFixedVersions":["1.0.3"],
			"issueKey":"ISSUE",
			"issueOriginalEstimate":3600,
			"issueRemainingEstimate":240,
			"issueReporter":"testUser",
			"issueStatusName":"To Do",
			"issueSummary":"Test Issue",
			"issueTypeName":"Epic",
			"issueUpdated":"Nov 26, 2017 9:17:40 AM",
			"labels":[],
			"priorityName":"Medium",
			"projectName":"Project",
			"subTasks":[],
			"worklogBody":"Test worklog",
			"worklogCreated":"Nov 26, 2017 9:17:40 AM",
			"worklogStartDate":"Nov 26, 2017 8:00:00 AM",
			"worklogTimeWorked":480,
			"worklogUpdated":"Nov 26, 2017 9:17:40 AM",
			"worklogUser":"testUser"
		}
	}
]