nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to find the filters that uses a custom field

prakash ganeshan_wxvp94

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

Accepted answers

All comments

Udo Brand

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

prakash ganeshan_wxvp94

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

Renaming the field "Projects" drop-down to "Business".
Retiring some values in this field.
Renaming some values in the field.
Adding some new values to the list.
Making this field a required one.

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.

Udo Brand

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

prakash ganeshan_wxvp94

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 ?"

Cap10Bill

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.