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.