How do you get the values from a Database Picker scripted field

[Jon Kocen]

I have a Database Picker scripted field which pulls data from a database. The .value field shows the ID numbers. These ID numbers are used for an additional database query.

I need to show the text of of the Database Picker scripted field in a Post function email.

How do I get the text values?

[Martin Bayer _MoroSystems_ s_r_o__ · Accepted solution]

hi @Jon Kocen , can you provide more information? What App is used? What is the script you use (if any), etc...

[Jon Kocen]

I am using JIRA Server and the Database PIcker field from ScriptRunner

Set per the instructions and added the field to a screen. The database picker populates from the database and works great.

The query pulls 2 fields, ID, Name. It displays the Name field

In a workflow Post function I want to send a custom email and display the values of the Name field. However in the Post function when is use cfValues['myfield'] it displays the ID numbers as [23,4,99]

I want to display the Name field in the custom email Post function

[Martin Bayer _MoroSystems_ s_r_o__]

Hi @Jon Kocen can you share scripts, screenshots so it is easier for me to help?

[Jon Kocen]

1) set up Database picker field called System, pulls data from database

2) Show on screen - type ahead field, allows user to select multiple items in list

3) output in Custom email in a Post Function - in Post function custom email

4) preview output, I want to display the text value - system not the ID value

I am not sure how the field knows to display the text vs. the ID, it just does it automatically

Database Picker field

Displays data in a multi-type select

Post function custom email to display the System selections

Preview of the custom email - shows IDs not the text displayed in the System field

[Martin Bayer _MoroSystems_ s_r_o__]

Thank you for detail info... but unfortunatelly there is no simple way to do it. There is existing bug (https://productsupport.adaptavist.com/browse/SRJIRA-4496) which mentions the same as you do.

There is workarount but I'm not sure, it will work in email template :(

[Jon Kocen]

Thanks for the info, at least I know I am not going crazy :-) 

[Florian Rada]

Hi Guys, I have the same problem. Did you find an workaround?

[Jon Kocen]

Not yet. I am using the IDs for an "in" clause.

but if I really wanted the values, I would have to have another query to get the data from the DB and display them in yet another field.

[Florian Rada]

thank for your reply. My recent workaround in my case, maybe will help someone.

I added a 'duplicate' column in db and create the database picker based on these 2 identical tables (one colomn used for ID, and the other for display name). 

[Александр Бабенко]

Hello. And how did you use the string value to find the id?

[Florian Rada]

I'm not sure if I understand your question. However, I will exemplify my workaround, first image is the table (from Jira db, it's not relevant) with id, pname, DESCRIPTION and pkey columns. I used DESCRIPTION column to duplicate the values from pname. In the second imagine, I set up the query based on pname and DESCRIPTION.