Thu, 24 Sep 2026
Login

How concatenate list column fields to a display field for a popup select box

Confluence User - 06 Feb, 2024

I would like to concatenate three fields to one display field in a popup select box. I'm not experienced with beanschell scripting and hash variables.

datalists;beanshell;javascript;hashvariable

4

Confluence User •
06 Feb, 2024 •
confluenceUser •
•
confluenceUser •

You can use SQL script to do that

E.g

Concat script 
SELECT t.id, CONCAT(t.firstname, ' ', t.lastname)FROM table1 t


Confluence User •
06 Feb, 2024 •
confluenceUser •
•
confluenceUser •

Thank you. Where do I place that script? In the beanshell of the new displayfield in de list?

Sorry I'm not that experienced

Confluence User •
06 Feb, 2024 •
confluenceUser •
•
confluenceUser •

Can you advise where to place this?

Confluence User •
07 Feb, 2024 •
confluenceUser •
•
confluenceUser •

You can use SQL query to load the selectbox

1
CSV | Excel | XML | PDF
RELATED QUESTIONS
How to embedded autoplay video to Homepage ?
Plugin for PDF Editor
npm install in joget
How to generate unique ID using Textfield?
Can I make list that read the Running Processes ? I want to add my own list and not using the list in monitor
Can I make list that read the Running Processes ? I want to add my own list and not using the list in monitor
How to customize datalist process formatter
How to hide an information tile on ui builder based on a dynamic #formLookup value in Joget?
Please help me fix the problem. The text field is pulling data from a datalist with more than 50k records and the browser hangs.
Please help me fix the problem. The Pop up select box is pulling data from a datalist with more than 50k records and the browser hangs.
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print