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 search issues using Scriptrunner Database Picker Field

Hayden Smith_xixnh4

I'm investigating using Database Picker fields from script runner to link with our other systems. I have a field set up and am able to select and set values from the database fine. This will be replacing a Text Field to enforce consistency with data input, and the database itself has ~600 entries that can change regularly, so don't want to manage a select field.

Anyway having set up the Database Picker field, I can see that the Searcher is set as "None" and when I click on the "None" the screen it takes me to informs me "There are no search templates for this custom field type." and I can't search based on this field in JQL. Is this a limitation with the Database Picker of have I missed something when setting it up as looking over the instructions I don't think I missed anything?

Accepted answers

Daniel Garcia_meo5d6

I wonder if we could workaround the issue by having a custom scripted field that just returns the value of the database picker. We could then search on that.

All comments

Daniel Garcia_meo5d6

I wonder if we could workaround the issue by having a custom scripted field that just returns the value of the database picker. We could then search on that.

Hayden Smith_xixnh4

Thanks for the suggestion Daniel. It's taken a while for me to have a chance to look at it but I can confirm that using the resource to take the id value stored by my database picker field and then pull the friendly name from the resource I can store the values in a scripted field and search on that.

It's clunky but the main thing is that it works.

Rodolfo So

can you share how do you execute that? Thanks

Daniel Garcia_meo5d6

The scriptrunner for jira plugin lets you define derived fields that are defined with a groovy script

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

scriptrunner

adaptavist