Jira Connector
Documentation
Version: 9
Documentation

EndPoint Read Worklogs


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) NO Use comma separated IDs or Keys for Issues. 1000 ids max or JIRA internal limit for Payload.
SearchBy Search by NO
Option Value
Project Project
JQL JQL
Key Key
Project Project NO Specify a project to search issues for
JQL JQL NO
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 Help..]
CustomColumnsRegex CustomColumnsRegex NO 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 DataType Length Raw Description
IssueId DT_WSTR 20 False
IssueKey DT_WSTR 50 False
Id DT_WSTR 20 False
Self DT_WSTR 150 False
StartAt DT_I4 0 False
MaxResults DT_I4 0 False
Total DT_I8 0 False
AuthorSelf DT_WSTR 200 False
AuthorAccountId DT_WSTR 150 False
AuthorEmailAddress DT_WSTR 200 False
AuthorDisplayName DT_WSTR 200 False
AuthorIsActive DT_BOOL 0 False
AuthorTimeZone DT_WSTR 100 False
AuthorAccountType DT_WSTR 50 False
CommentFormatted DT_NTEXT 0 False
Comment DT_NTEXT 0 False Join formatted text blocks using space separator (new lines will be lost)
UpdateAuthorSelf DT_WSTR 500 False
UpdateAuthorAccountId DT_WSTR 200 False
UpdateAuthorEmailAddress DT_WSTR 200 False
UpdateAuthorDisplayName DT_WSTR 200 False
UpdateAuthorActive DT_BOOL 0 False
UpdateAuthorTimeZone DT_WSTR 80 False
UpdateAuthorAccountType DT_WSTR 50 False
Created DT_DBTIMESTAMP 0 False
Updated DT_DBTIMESTAMP 0 False
Started DT_DBTIMESTAMP 0 False
TimeSpent DT_WSTR 50 False
TimeSpentInSeconds DT_I8 0 False
AuthorAvatarUrls48x48 DT_WSTR 500 False
AuthorAvatarUrls24x24 DT_WSTR 500 False
AuthorAvatarUrls16x16 DT_WSTR 500 False
AuthorAvatarUrls32x32 DT_WSTR 500 False
UpdateAuthorAvatarUrls48x48 DT_WSTR 500 False
UpdateAuthorAvatarUrls24x24 DT_WSTR 500 False
UpdateAuthorAvatarUrls16x16 DT_WSTR 500 False
UpdateAuthorAvatarUrls32x32 DT_WSTR 500 False

Input Columns

Label DataType Length Raw Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.