Update Custom Field Drop down values based on JQL query

[Raj]

Hi,

I would like to create behavior or use automation rule which needs to update/add/remove custom field drop down values based on the JQL query which will be schedule to run thrice a day.

Also i would like to concatenate two field values from JQL query before adding it to custom field drop down (single select list)

Thanks,

Raj 

[Alex Koxaras -Relational-]

Hi @Raj and welcome to the community,

JQL yields an array of issue objects and nothing else. What you are asking can't be done the way you want it. If you describe your need with more details, then the community will be able to help you better.

[Raj]

Hi @Alex Koxaras -Relational- , Thank you!

I would like to automate adding custom field drop down values based on specific issue type title concatenated with issue key..

Example: Title (issue key) - Test Issue (TI-1)

I would like to get values from JQL or using API.

Example JQL: project=test AND status !=Resolved

[Alex Koxaras -Relational-]

So if I understand correctly your business requirement is when an issue is created, to add a new value to a single select custom field, if that value doesn't exist. That value must have the name of "IssueTypeOfNewlyCreatedIssue + IssueKeyOfNewlyCreatedIssue" -> e.g. "Task-TI-1".

Is the above statement correct?

[Raj]

@Alex Koxaras -Relational- That's right. Small change here is instead IssueType i needed "IssueTitleofNewlyCreatedIssue+IssueKeyOfNewlyCreatedIssue" and condition is to show only active ones (I mean not closed/done ones).

[Alex Koxaras -Relational-]

If you need to remove as well values which corresponds to done issues, then you have to write a scriptrunner script. This is the way to go. I'm not so sure that you can do that with Jira automation.

[Raj]

ok let me try and share here if i find solution. Thanks!