Three lists X, Y, Z - databasejoin in Z with concat label from X and Y

[kszadkowski]

Hello,

I have three lists: X, Y, Z
X elements: id data_x
Y elements: parent_id id data_y
Z elements: id data_z

Y is group of X - x.id and y.parent_id
Now I want to do data_z element as databasejoin to element data_y (value) but as a label (Concat Label) I want to do "data_x data_y". Concat Label - 'data_y' loading without any problem. But it can not reach to the field 'data_x'. How to do it?

 

[troester]

Put a MySQL query in Concat
(select data_x from x where x.id={thistable}.parent_id),{thistable}.data_Y

 

[kszadkowski]

It works! I thought I need do it differently ex. using placeholders. But this is a simple and effective solution

 

[hdmann]

Awesome - just what I was looking for. Thanks.