/
Issue Work Logs

Issue Work Logs

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

Table
Read with this
Custom JQLs (built on the fly)
Custom JQLs (built on the fly)
Read with this
Formatting natural and work time
Formatting natural and work time
Read with this
SQL Engine constraints
SQL Engine constraints
Read with this
Pivot Table gadget
Pivot Table gadget
Read with this
JQL and SQL (working together in the same query)
JQL and SQL (working together in the same query)
Read with this