db fields joined table in Concat label

[Alphons]

hi, is it possible to use een DB field from a joined table in the Concat label? I've tried several notations but get every time an sql error in the frontend (
Error: 500 - Fabrik has generated an incorrect query for the list)

i render as drop-down
concat label: {thistable}.cb_agb, ' / ', site_users.username
Where: WHERE site_comprofiler.cb_agb <> ''
join: LEFT JOIN site_users ON site_comprofiler.id = site_users.id

I use Fabrik 3.1 rc2 and Joomla 3.2.1

 

[Alphons]

Extra information - Generated SQL statement:
SQL=SELECT SQL_CALC_FOUND_ROWS DISTINCT `ga_arts_zorginstelling`.`id` AS `ga_arts_zorginstelling___id`,
`ga_arts_zorginstelling`.`id` AS `ga_arts_zorginstelling___id_raw`,
`ga_arts_zorginstelling`.`date_time` AS `ga_arts_zorginstelling___date_time`,
`ga_arts_zorginstelling`.`date_time` AS `ga_arts_zorginstelling___date_time_raw`,
`ga_arts_zorginstelling`.`agb` AS `ga_arts_zorginstelling___agb_raw`,
CONCAT_WS('', site_users.username) AS `ga_arts_zorginstelling___agb`,
`ga_arts_zorginstelling`.`naam_zorginstelling` AS `ga_arts_zorginstelling___naam_zorginstelling_raw`,
`ga_zorginstelling`.`naam_zorginstelling` AS `ga_arts_zorginstelling___naam_zorginstelling`,
`ga_arts_zorginstelling`.`id` AS slug
, `ga_arts_zorginstelling`.`id` AS `__pk_val`
FROM `ga_arts_zorginstelling`
LEFT JOIN `site_comprofiler` AS `site_comprofiler` ON `site_comprofiler`.`cb_agb` = `ga_arts_zorginstelling`.`agb`
LEFT JOIN `ga_zorginstelling` AS `ga_zorginstelling` ON `ga_zorginstelling`.`naam_zorginstelling` = `ga_arts_zorginstelling`.`naam_zorginstelling`
WHERE 1 = -1
ORDER BY CONCAT_WS('', site_users.username) ASC LIMIT 0, 10

 

[Alphons]

Same join - other list/element the generated SQL-statement is:
Error: 0 - SQL=SELECT DISTINCT(`site_comprofiler`.`cb_agb`) AS value, CONCAT_WS('', site_users.username) AS text FROM `site_comprofiler` AS `site_comprofiler` JOIN SITE_USERS ON SITE_USERS.ID = SITE_COMPROFILER.ID JOIN WHERE site_comprofiler.cb_agb <> '' ORDER BY text ASC

Problem is the extra JOIN direct in front of WHERE.

How can i solve this problem?

 

[Sophist]

I think you probably your Label concat should be:

{ga_arts_zorginstelling___cb_agb}, ' / ', `site_users`.`username`

 

[Alphons]

thanks! I will try this format. I'm now stuck in scheduled task