...
...
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
...
Example
My reported issues with no comments:
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
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 |
...
...
|