Summary

Disable the Create JIRA Issue Functionality from Confluence Page from Database

Environment

Confluence 7.2.1 and above. 

For 7.2.0 and below versions, please refer https://confluence.atlassian.com/confkb/how-to-disable-the-create-jira-issue-functionality-in-confluence-681902357.html

Use Case

To help Users disable the Create Jira issue plugin from Database as the disable functionality has been removed from GUI from Confluence 7.2.1 and above

Screenshot from Confluence 7.2.1

Resolution

This feature is provided by the Confluence and Jira Content Connector system plugin. To disable the Create JIRA Issue button that appears when you highlight content in Confluence, disable the plugin using the following instructions:

  Always make a full backup of the database and be prepared to roll-back before making direct edits to the database.

• Run the following query on your Confluence database:

  • select BANDANAVALUE from BANDANA where BANDANAKEY = 'plugin.manager.state.Map'; 

• This will return a value like below. It will look different in your instance.

  • <map> 
     <entry> 
       <string>com.atlassian.confluence.ext.usage</string>
       <boolean>false</boolean>
     </entry> 
    </map>

• Copy the contents of the BANDANAVALUE column to a text editor. 
• Search in the text file, keyword 'com.atlassian.confluence.plugins.confluence-jira-content'
• To disable the plugin, change the boolean value for the add-on in question to false like below

  • <entry>
        <string>com.atlassian.confluence.plugins.confluence-jira-content</string>
        <boolean>false</boolean>
    </entry>

• • If 'com.atlassian.confluence.plugins.confluence-jira-content'  keyword is not present in the text file, you have to add the below entry in the file.

    • <entry>
        <string>com.atlassian.confluence.plugins.confluence-jira-content</string>
        <boolean>false</boolean>
      </entry>

• Then execute the following UPDATE statement to commit these changes:

  • update BANDANA set BANDANAVALUE='(copy the entire text from <map> to </map>)' where BANDANAKEY='plugin.manager.state.Map';

Note: You will be updating BANDANAVALUE with the entire contents of the text in your text editor, from <map> to </map> including portions of text that you did not update.  Restart Confluence for this change to be picked up.