ISSUECOMMENTS
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
The comments restricted to a project role (ROLEID is NOT null) can be view by the author's comment, the project administrators, the JIRA administrators and by the user playing the required role in the project only.
It requires project browse permissions in any case.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