Renaming Users can Break JQL Filters
Issue
When you rename a user's username, all existing filters that still use the old username should still be working fine. This doesn't seem to be the case.
For example:
Let's say we renamed "johndoe" to "johndoe2345",then opened an existing filter that was referencing "johndoe":
assignee = "johndoe"
Performing this search would result in the result of "no issues found". But after refreshing the page would we see:
"The value 'johndoe' does not exist for the field 'assignee'."
Reindexing doesn't fix the issue.
Cause:
The assignee value that is in the filter is just text in searchrequest, so updating the app_user table (i.e changing the username) doesn't go out and update the text string in the searchrequest table.
Workaround
Update the filters manually through the GUI to reflect the correct username
Related Links
JRASERVER-36971 - Getting issue details... STATUS