You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
Recently a custom field name in our JIRA environment was renamed. As a result, its broken many people's filters.
Is there a way you can identify a current list of broken filters and their respective owners? That way individuals can update their filters accordingly without having to review all their filters one by one (this would be especially useful if people have over 100 filters).
If you have access to your database (or know who does), you can check the searchrequest table. In general, consulting the database directly isn't the best idea, but sometimes, in cases like this, it's warranted. You can use a query like
SELECT * FROM searchrequest where reqcontent like '%myfield%'
1. In general, what exactly does checking the searchrequest table do? What kinds of information does it provide?
2. From the example query you provided above:
a. What information would be displayed?
b. Can you provide an example of a few lines of output that I would expect to see after executing the search?
out of curiosity, how is this method different from this one?
(It seems that the method you are suggesting is a lot simpler)
Though convoluted, at least one of those soluctions (Daniel Garcia's) does appear to work; Jonny Carter's does not work for me.
Some pros and cons of each:
Mine - simple and straightforward, but you need database access
Daniel's - you don't need database access, but you must have the ScriptRunner app installed.