How to bulk change Rich Filters ownership in the Rich Filters for Jira Dashboards app

Ownership of rich filters may need to be transferred, particularly when a user leaves the organization. This article provides instructions on changing ownership of rich filters in bulk by updating the relevant database table.

Prerequisites

  • Access to the appropriate Jira database.

  • Proper database backup before running any update queries.

  • Familiarity with SQL queries and database types (PostgreSQL, MySQL, SQL Server, etc.).

Solution

The Rich Filter's ownership information is stored in the database table AO_24D977_QRFAE0. This table contains the following key fields:

  • ADMIN_KEY: Stores the user ID or key of the administrator/owner of the rich filter.

  • ID: A unique identifier for the entry.

  • RICH_FILTER_ID: The ID of the associated rich filter.

To bulk change the ownership of rich filters from one user to another, an SQL query can be run to update the ADMIN_KEY field.

Example Query

The following SQL query shows how to change the ownership of rich filters from a user leaving the organization to a new user.

UPDATE AO_24D977_QRFAE0 SET ADMIN_KEY = '<newUser>' WHERE ADMIN_KEY = '<userWhoLeavesTheOrganization>'

 

Considerations

  • Database Type: The SQL syntax may vary slightly depending on the database type you are using, for example, PostgreSQL, MySQL, or SQL Server.

  • Backup: Ensure that you have backed up your database before executing the query to prevent data loss.

  • Impact: This query will affect all rich filters currently owned by the user who is leaving the organization.

This query was tested on Jira version 9.11.3.