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