Table/List Join, Use custom separator.

[black.be3]

Hi Rob/Hugh,
I have master-detail table, my master table use table/list join to detail table.
With display mode: merge rows.
One field on my detail table i set to show in list.
It work, but all (current field) data from detail table showed as one.
On display mode: Each Row separately, my detail-field rendered on separate row.

master-field || detail_1
master-field || detail_2
master-field || detail_3

While on merge rows, it showed all on one row.

master-field || detail_1 detail_2 detail_3

I wonder if we can customize seperator to show detail data, like comma, etc

master-field || detail_1,detail_2,detail_3

 

[juuser]

I would also love to have a custom separator or at least every record in its own line

Laura

 

[juuser]

Solved it like this. Added custom label name in databasejoin label as:
{thistable}.field_name,'<br>'

Of course you can change <br> to anything you like.

Laura

 

[black.be3]

Hi Laura,
Where should i put it? Can you explain step by step?

 

[black.be3]

Solved it like this. Added custom label name in databasejoin label as:
{thistable}.field_name,'<br>'

Of course you can change <br> to anything you like.

Laura

but it wil give you '<br>' on dropdown list

 

[juuser]

I see you figured it out where to put it. You are right, it will show <br> in dropdown list. I didnt noticed it myself because I had this element hidden in edit mode.

Maybe someone has better solution.

but it wil give you '<br>' on dropdown list