EndPoint Read Worklogs

Contents

1 Label
2 Description
3 Parameters
4 Output Columns
5 Input Columns

Name

get_worklogs

Description

No description available

Parameters

Parameter

Label

Required

Options

Description

Key

Issue Key(s) or Ids - Comma Separated (PRJA-10,PRJA-13)

Use comma separated IDs or Keys for Issues. 1000 ids max or JIRA internal limit for Payload.

SearchBy

Search by

Option	Value
Project	Project
JQL	JQL
Key	Key

Project

Specify a project to search issues for

JQL

Option	Value
Search Ids (IN)	key IN(10001, 10002, 10003)
Search Keys (IN)	key IN(CS-1, CS-2, CS-3)
Search Projects (IN)	project IN(PROJ1, PROJ2, PROJ3)
Search Status (EQUAL)	status='Done'
Search Date (Expression 1)	created >=-5d
Search Date (Expression 2)	created >=startOfMonth() AND created <=now()
Search Date (Expression 3)	created >=startOfYear() AND created <=startOfDay()
Search Date (Static)	created >= 2008/12/31
Search Date (Static with time)	created >= 2008/12/31 23:59
Search Project and Status (AND + IN)	project=CS AND status NOT IN ('Done', 'Open', 'Closed')
Search Assignee and Created Date	assignee is NOT EMPTY and created < -1d
Search Text (Contains - Fuzzy)	Summary ~ 'some words' OR description ~ 'some words'
Search Text (Contains - Fuzzy Wildcard)	Summary ~ 'some' OR description ~ 'some'
Search Text (Contains - Exact)	Summary ~ '\"exact words\"' OR description ~ '\"exact words\"'
Search Text (Does Not Contain - Fuzzy)	Summary !~ 'some words' OR description !~ 'some words'
Search Empty OR Null	fixVersion is empty OR fixVersion is null
Search Is Not Empty OR Is Not Null	fixVersion is not empty OR fixVersion is not null
Search WAS Operator (previous value)	status WAS "Resolved" BY (jsmith,srogen) BEFORE "2019/02/02"
Search WAS IN Operator	status WAS IN ("Resolved", "In Progress")
Search WAS NOT IN Operator	status WAS NOT IN ("Resolved", "In Progress")
Search WAS + BY + DURING (date range)	status WAS "Resolved" BY (jsmith,srogen) DURING("2019/02/02", "2020/02/02")
Search CHANGED operator	assignee CHANGED
Search CHANGED operator (multiple)	status CHANGED FROM "In Progress" TO "Open"

Use JQL to use an advanced mode of searching. Few links are https://www.atlassian.com/blog/jira/jql-the-most-flexible-way-to-search-jira-14 and als check https://wac-cdn.atlassian.com/dam/jcr:241d9c9b-475f-411f-90a2-97ca344442b3/atlassian-jql-cheat-sheet-2.pdf?cdnVersion=2169 [API reference]

CustomColumnsRegex

Enter regular expression for custom columns which you like to output. Use Pipe to type keys (internal names for columns). You can use Regex too (e.g. field_100\d+ )

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw	Description
IssueId	`DT_WSTR`	`nvarchar(20)`	20	False
IssueKey	`DT_WSTR`	`nvarchar(50)`	50	False
Id	`DT_WSTR`	`nvarchar(20)`	20	False
Self	`DT_WSTR`	`nvarchar(150)`	150	False
StartAt	`DT_I4`	`int`		False
MaxResults	`DT_I4`	`int`		False
Total	`DT_I8`	`bigint`		False
AuthorSelf	`DT_WSTR`	`nvarchar(200)`	200	False
AuthorAccountId	`DT_WSTR`	`nvarchar(150)`	150	False
AuthorEmailAddress	`DT_WSTR`	`nvarchar(200)`	200	False
AuthorDisplayName	`DT_WSTR`	`nvarchar(200)`	200	False
AuthorIsActive	`DT_BOOL`	`bit`		False
AuthorTimeZone	`DT_WSTR`	`nvarchar(100)`	100	False
AuthorAccountType	`DT_WSTR`	`nvarchar(50)`	50	False
CommentFormatted	`DT_NTEXT`	`nvarchar(MAX)`		False
Comment	`DT_NTEXT`	`nvarchar(MAX)`		False	Join formatted text blocks using space separator (new lines will be lost)
UpdateAuthorSelf	`DT_WSTR`	`nvarchar(500)`	500	False
UpdateAuthorAccountId	`DT_WSTR`	`nvarchar(200)`	200	False
UpdateAuthorEmailAddress	`DT_WSTR`	`nvarchar(200)`	200	False
UpdateAuthorDisplayName	`DT_WSTR`	`nvarchar(200)`	200	False
UpdateAuthorActive	`DT_BOOL`	`bit`		False
UpdateAuthorTimeZone	`DT_WSTR`	`nvarchar(80)`	80	False
UpdateAuthorAccountType	`DT_WSTR`	`nvarchar(50)`	50	False
Created	`DT_DBTIMESTAMP`	`datetime`		False
Updated	`DT_DBTIMESTAMP`	`datetime`		False
Started	`DT_DBTIMESTAMP`	`datetime`		False
TimeSpent	`DT_WSTR`	`nvarchar(50)`	50	False
TimeSpentInSeconds	`DT_I8`	`bigint`		False
AuthorAvatarUrls48x48	`DT_WSTR`	`nvarchar(500)`	500	False
AuthorAvatarUrls24x24	`DT_WSTR`	`nvarchar(500)`	500	False
AuthorAvatarUrls16x16	`DT_WSTR`	`nvarchar(500)`	500	False
AuthorAvatarUrls32x32	`DT_WSTR`	`nvarchar(500)`	500	False
UpdateAuthorAvatarUrls48x48	`DT_WSTR`	`nvarchar(500)`	500	False
UpdateAuthorAvatarUrls24x24	`DT_WSTR`	`nvarchar(500)`	500	False
UpdateAuthorAvatarUrls16x16	`DT_WSTR`	`nvarchar(500)`	500	False
UpdateAuthorAvatarUrls32x32	`DT_WSTR`	`nvarchar(500)`	500	False

Input Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw	Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.