Serial number of all issues should display in another project Multi select custom field Values

Question

Hi Team,

I have a serial number Field in One project (Ex: Abc) Lets assume 10 tickets are created with 10 different Serial numbers. When i Search JQL query for the tickets with Serial number entered, then i will get 10 tickets with Serial number.

Here my question is I have another project "Xyz" and i have multi option select custom field.

I want all those serial numbers from "Abc" project should display in the Multi select custom field of Xyz Project. Is it possible to achieve this?

Note: We have script runner plugin

Thanks,

Thomas Opiolka - codefortynine · Answer

Hi @Prathap DL ,

In case you are willing to try another 3rd party app you could try External Data for Jira Fields.
In this app you can use Local Jira as a data source to fetch the data easily and use Field Option Sync to keep you multi-select custom field in sync. Sounds like a good fit to me.

I should mention that I am collaborating with the vendor of the app I recommended.

I hope this is helpful,

Thomas

Trudy P Claspill · Answer

Hello @Prathap DL

Welcome to the Atlassian community.

What type of field is the Serial Number field?

I have been reviewing the ScriptRunner documentation, and so far I'm not finding a way to do what you want specifically with that app.

However, I think you might be able to accomplish this with an Automation Rule.

You would need to create a multi-select custom field for use in project XYZ.

In an Automation Rule you could detect changes to the Serial Number field in project ABC.

Then, I think, you might be able to use the Send Web Request action to call the REST API to update the options available in the multi-select custom field.

https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-issue-custom-field-options/#api-rest-api-3-field-fieldid-context-contextid-option-put

You might need to first GET all the existing values defined for the multi-select issue and check if the value you want to add already exists.

https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-issue-custom-field-options/#api-rest-api-3-field-fieldid-context-contextid-option-get

If you have not worked with the Send Web Request action before, you can find a 2020 article about it here:

https://community.atlassian.com/t5/Jira-articles/Automation-for-Jira-Send-web-request-using-Jira-REST-API/ba-p/1443828

Disclaimer: I haven't actually tried this so I am not guaranteeing it would work, nor can I provide the exact details for how to implement it.