Is there a way to bulk update user ids in filters and quick filters? In the database, maybe?

[William Kahn]

We are moving to SSO for our self hosted data center. One of the requirements is that the user id is the email address. Currently our instance does not require that as a user id. We were able to update all the user ids in our UAT environment, but it broke all the existing filters and quick filters on boards that include an assignee id. Is there a way that we can do a bulk 'find and replace' in the database without having to go into every existing filter/ quick filter individually? Or is there any method at all?

[Trudy Claspill]

Hello @William Kahn 

Atlassian strongly recommends against making any direct updates to the database due to the possibility of making them incorrectly and corrupting the database.

Having said that...

There are tables in the database that hold the JQL for saved filters (searchrequest) and the JQL for Quick Filters (AO_60DB71_QUICKFILTER). It is technically possible to search for filters where the JQL field contains the current username of a user. It is technically possible to use a SQL UPDATE statement with the "replace" function to replace a substring with another string within a text field.

(Disclaimer: I provide no guarantee or warranty for the above information. Use at your own risk.)