php_events: onBuildQueryWhere to sticky

Status
Not open for further replies.

troester

Administrator
Staff member
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 ...
 
Status
Not open for further replies.
We are in need of some funding.
More details.

Thank you.

Members online

Back
Top