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.