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