Thu, 24 Sep 2026
Login

How to make a row in datalist column into one row

Confluence User - 08 Apr, 2020

How to make a row in datalist column into one row ?

For example a content : alfa papa beta,

usually in a datalist column it would be :

alfa

papa

beta

How to make it : alfa papa beta ?

Thank you


datalists

1

Confluence User •
08 Apr, 2020 •
confluenceUser •
•
confluenceUser •

In Datalist > Data Source, select the JDBC Binder and use SQL query string to GROUP_CONCAT the column you want; read an example from https://fellowtuts.com/mysql/concatenate-multiple-mysql-rows-into-one-field-using-group_concat/ . More here.

FYI the database name created by Joget starts with "app_fd_[your table name]" and the table column starts with "c_[form field id]".

1
CSV | Excel | XML | PDF
RELATED QUESTIONS
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
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.
I want to have a visibility control for hyperlink based on the date in a list builder, what type of operator I should use and how?
I Want to Add , Add to Cart functionality like Swiggy or Zomato This is possible in joget?
List Question
Create Folder on the Home Page
Async search list with ajax
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print