/
Issue Work Logs
Issue Work Logs
ISSUEWORKLOGS | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
Column | ISSUEID | ID | AUTHOR | CREATED | TIMESPENT | COMMENT | PROJECTROLEID | UPDATEDON | UPDATEDBY | UPDATEDFROM |
Type | BIGINT | BIGINT | VARCHAR | TIMESTAMP | BIGINT | VARCHAR | BIGINT | TIMESTAMP | VARCHAR | TIMESTAMP |
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