How to list Projects using view restrictions on comments ?

[Saujanya Deshmukh]

Hi All,

I want to list the project using view restrictions to a particular group on comments ? (Comments are visible only to particular group - Management / Developers). Can I query database to find this detail?

-S

[justindowning]

If you you have a Project Role that this criteria (Comments visibile to group 'foo'), then you can certainly query this in the database.

select pname from project, projectroleactor where project.id = projectroleactor.pid and roletypeparameter = 'foo' and projectroleid  = '<project_role_id>';

[Penny Wyatt (On Leave to July 2021)]

Hey S D,

Sorry, I'm not certain what you're asking, as JIRA terminology can be rather tricky at times :-) There is no project-level view restriction on comments - you can set project-level permissions for adding or editing comments, or set project-level permissions for viewing issues, but for viewing comments there's only a per-comment permission.

I think you're trying to find projects that contain comments that are restricted to an Issue Security Level called "Managers / Developers" - is this correct?