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?
hi @Jon Kocen , can you provide more information? What App is used? What is the script you use (if any), etc...
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Jon Kocen can you share scripts, screenshots so it is easier for me to help?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 :(
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello. And how did you use the string value to find the id?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.