/
Issue Work Logs

Issue Work Logs

Owned by Pablo Beltran (Unlicensed)
Last updated: Sept 27, 2018

ISSUEWORKLOGS

Column

ISSUEID

ID

AUTHOR

CREATED

TIMESPENT

COMMENT

PROJECTROLEID

UPDATEDONUPDATEDBYUPDATEDFROM

Type

BIGINT

BIGINT

VARCHAR

TIMESTAMP

BIGINT

VARCHAR

BIGINT

TIMESTAMPVARCHARTIMESTAMP

Indexed

x

x








x

Since the 7.4.0 version, it is possible filter issues by their last update date.

Example:

SELECT * FROM ISSUEWORKLOGS WHERE UPDATEDFROM = CURRENT_DATE - 7

The SQL+JQL query above will return all the work logs (respecting users' permissions in JIra) updated within the last 7 days.


Related content