An onBuildQueryWhere condition
e.g. $model->setPluginQueryWhere('exqual', "privacy=2");
is not only added to the list filter
correct: ...FROM person WHERE .... AND (privacy=2)...
but also to all dbjoin element filters
... FROM `kanton` AS `kanton_0` WHERE (privacy=2) ORDER BY and so breaking with error "unknown column 'privacy'...".
Workaround is to set the element filter to "Recorded data", then it's creating the new WHERE condition
INNER JOIN `kanton` AS `kanton_0` ON `kanton_0`.`kanton_id` = `person`.`kanton_id_g` WHERE `person`.`kanton_id_g` IN ...
e.g. $model->setPluginQueryWhere('exqual', "privacy=2");
is not only added to the list filter
correct: ...FROM person WHERE .... AND (privacy=2)...
but also to all dbjoin element filters
... FROM `kanton` AS `kanton_0` WHERE (privacy=2) ORDER BY and so breaking with error "unknown column 'privacy'...".
Workaround is to set the element filter to "Recorded data", then it's creating the new WHERE condition
INNER JOIN `kanton` AS `kanton_0` ON `kanton_0`.`kanton_id` = `person`.`kanton_id_g` WHERE `person`.`kanton_id_g` IN ...