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
Issues with no comments:
select i.key
from issues i
inner join issuecomments c on c.issueid=i.id
where i.jql='project = SSP'
group by i.key
having count(*) = 0