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 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?

Accepted answers

Martin Bayer _MoroSystems_ s_r_o__

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

All comments

Martin Bayer _MoroSystems_ s_r_o__

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

Welcome!

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

Quick Links

Find more posts tagged with

server

jira-software

jira-software-server

atl-gruland