Versions Compared

Version Old Version 3 New Version Current
Changes made by

Reshma Begum

Mark Kleinsmith

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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 's 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:

...

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.

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

Info

Considerations

  • Database Type: The SQL syntax may vary slightly depending on the database type you are using (e.g., 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.

Info

This query has been was tested on Jira version 9.11.3 version.