It's not the same without you
Join the community to find out what other Atlassian users are discussing, debating and creating.
I have to find all the filters that uses a custom field. Please help me is there any wat to do this either on database or from JIRA UI
you can use this query.
select * from searchrequest s where s.reqcontent like '%yourfieldname%' or s.reqcontent like '%cf[yourcustomfieldid]%';
but there might be in addition filters that are using those filters
Hi Udo .. Thanks Now I am running into need of different help like ... Request your help on this too ..
We are planned to do the following change to one of the field of type 'drop down'.
Example:
Field Name : Projects (Not mandatory field)
Type : Drop down list
Now I dont have any problem doing these changes. I have to change all the filters that uses this field and it's value. Please help me in doing the below activity.
1. I need to find and modify all the filters to use the field name as "Business" in place of "Projects" after rename.
2. I need to find and change all the filters that uses the value in the field "Projects" that are going to renamed.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
first find the id of the field Projects and replace 'ID' with this id in the query below.
select * from searchrequest s where s.reqcontent like '%Projects%' or s.reqcontent like '%cf[ID]%';
for the second part, all filters which are using values which will be renamed are already within the resultset of the first part, since they will have 'Projects' in the filter
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Udo,
THanks for your help, just want to confirm from your end that "Does this custom field "Projects" in filter has reference to searchrequest table alone or it is referred in any other table ?"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Prakash,
it has references to other tables as well but only with its ID. So renaming the field will have no other effect beside the one on the filters using this field.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The response above is good for advanced filters which are stored as text, but what about "Basic" filters?
Thanks,
Mike
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mike,
Basic filters are stored in the same way as advanced filters. So it works for them as well.
Cheers,
Udo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Is there anyway to run this against the CloudAPI? I'm looking for all filters that use a couple of my custom fields that I'm looking are reworking. Need to get a list of filters to look at.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hey admins! I’m Dave, Principal Product Manager here at Atlassian working on our cloud platform and security products. Cloud security is a moving target. As you adopt more products, employees consta...
Connect with like-minded Atlassian users at free events near you!
Find a groupConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.
Start an AUGYou're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.