I am on the verge of allowing our customers to access their issues in our JIRA instance.
But I need to set all existing comments to private before doing so.
Could anyone point me in the right direction to accomplishing this directly in PostgreSQL via sql?
Usual caveats apply as to hacking your data directly:
JIRA comments are stored in the
jiraaction DB table.
You will see a column named "actiontype" and you will probably find that all rows have a value of "comment".
(Worklogs used to be in there too, but got moved).
Comments can be secured via a group or a project role (depending on global settings).
There is a column called "actionlevel" for when its a group and another called "rolelevel" for project role.
If both these are NULL, then no security, otherwise you only set one or the other.
After running your SQL you will need to do a reindex in order for the JQL searches to secure your searches accordingly.
Hello Atlassian Community! My name is Emilee, and I’m a Product Marketing Manager for the Marketplace team. Starting with this post, I'm kicking off a monthly series of Spotlights to highlight Ma...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot