要約

In the Jira Database, restricted comments have the 'rolelevel' set to the ID of the group they are restricted to. 

Below we will demonstrate how to identify these issues. 

診断

We spun up a test instance and created two comments:

• One Comment that is unrestricted
• One comment that is restricted to Administrators

Next, we did a simple query to find out the difference between the two comments:

select * from jiraaction;

Results:

 From the results, it appears that:

• Unrestricted comments have 'rolelevel' set to (null)
• Restricted comments have the 'role level' set to the ID of the role(In this case Administrators)

Tying this together and modifying the query from How to find all the comments related to one user in the database:

SELECT P.pkey||'-'||JI.issuenum||Ja.rolelevel as issuekey, JA.actionbody, JA.rolelevel
FROM jiraaction JA
JOIN jiraissue JI ON JA.issueid = JI.id
JOIN project P ON JI.project = P.id
JOIN app_user U ON U.user_key = JA.author
WHERE JA.actiontype = 'comment'
and rolelevel is null;

Results:

ソリューション

Restricted comments have the 'role level' set to the ID of the role(In this case Administrators).

Unrestricted comments have the 'rolelevel' as null.