Issue Comments
ISSUECOMMENTS | |||||||||
---|---|---|---|---|---|---|---|---|---|
Column | ID | ISSUEID | AUTHOR | CREATED | UPDATER | UPDATED | MIMETYPE | BODY | ROLEID |
Type | BIGINT | BIGINT | VARCHAR | TIMESTAMP | VARCHAR | TIMESTAMP | VARCHAR | VARCHAR | BIGINT |
Indexed | x | x |
Example
My reported issues with no comments:
Example 1
select LINK(JQL.ISSUE, '_blank') as "Issue" from JQL left join issuecomments c on c.issueid=JQL.issueid where jql.query = ' reporter = currentUser() ' group by JQL.ISSUEID having count(*) = 0