ScriptRunner: search similar work item based on field value and copy field values

Doods Perea_41uhib

Can anyone please help on my ScriptRunner problem below?

In the Jira Service Management Portal form, the customer provides the unique "Membership ID Number" (e.g. 01-ABC123).

I would like for ScriptRunner to search the Jira project where the form belongs.  If it finds the same "Membership ID Number", copy the field values of the found work item (Full Name, Date of Birth, Address, etc.).

In this way, the customer is able to complete the form faster.

Thank you.

Doods 

Benjamin_tmh9yg

Hi @Doods Perea ,

 

Not sure if approach would be the optimal way to go about it. Searching the entire project through all the form data to find information each time a customer fill out form can be expensive. 

 

You may want to have a database or use assets to hold your customer membership ID and use jira automation to pull the rest of the info. This is quite common scenario like in IT. For example, when an employee files a ticket about their laptop,  their information would be pulled from assets. Think of assets can be used as a look up table. Searching on specific table is much more efficient than search all over the project. 

 

Of course, go with what works with best for your situation. Sharing an alternative way to go about it. 

 

All the best.