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 |
Info |
---|
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. |