Custom field values

[Aswathi D]

Hi 

I have a custom field in jira called " assigned teams " and the values are A,B,C,D ..

I need to remove B,C and add F 

But this new value F should replace all the queries , user stories which are using the values B and C 

How can I do this ?

I don't know where these values are used as well ..

[meliodas16]

Hello @Aswathi D,

Assuming you customfield is a "Select list", you can either rename, disable or delete an option.

• Edit(Rename) : change the name of the option from B to F for example. All current issues will have their display values automatically refelecting the new name.
• Disbale : the option B for example will no longer be available for choice (edit/creation). Current issues where the value of your customfield = B will remain unchanged. The option will still be available in the JQL search.
• Delete : remove the values from all associated issues. The option will no longer be available in the JQL search

To replace current issues where your customfield equals B or C with F, you can do a bulk change. 

Regarding saved filters, you should update them manually one by one or via the api using a a groovy script(you'll need Scriptrunner for example) or via SQL (less recomeded if you're not familiar with it)

Kind regards.

[Tobias H]

Hi Aswathi!

First of all add team F to the Custom Field choices.

If you have access to Global Automations, you should be able to create an automation that is run across all projects like this.

1. When: Manual Trigger (if this is a one time only thing)
2. Add New Condition
   1. Select JQL condition
   2. Create a JQL string that matches your reality, something like: "Assigned Team[Dropdown]" in (B, C)
   3. Save
3. Then add New Action
   1. Select Edit Issue
   2. Press the Cogwheel dropdown and select Assigned Team
   3. Select team F here
   4. Save

Now the automation is completed and once it runs it will look for all issues where Team B,C is assigned and edit it to team F.

I do have some suggestions, either to only do it for Non-Resolved issues, or Issues created after a specific date. Perhaps don't delete B and C, only mark them as Non-Active, so you aren't changing the past just to fit the present/future.

[Tobias H]

Also, if you need help to find out the JQL string, you can do it like this:

1. Go to Search
2. Set up a filter using Basic mode
3. Make sure Project = All
4. Press + More
5. Search for and select "Assigned Team"
6. This will open a new dropdown, from here select team B and C
7. Press Search
8. Switch to JQL
9. Copy the JQL string.
   1. It will look something like this: "Assigned Team[Dropdown]" in (B, C) order by created DESC
   2. Make sure to only copy the part before order by created DESC

[Aswathi D]

Hi @Tobias H ,

Thanks for your reply.

I can manage to bulk change the tickets which are using the old values .

But I need to know how to find the saved filters which are using these values ?

[Tobias H]

Nicely done!

How to find a solution to finding saved filters is probably a bit out of my knowledge zone I'm afraid 😅

And looking at this older question regarding the topic just confirms that: https://community.atlassian.com/t5/Jira-questions/How-to-find-all-JIRA-filters-that-include-JQL-for-a-custom-field/qaq-p/732061

Perhaps drop a question in one of the old threads and see if someone that have answered will be able to assist you 🤞