Hey there,
I build a form with 2 elements.
First element is a Calc Element (returns an id from somewhere).
Second element is a database join to an existing table.
The databasejoin should be rendered as checkbboxes.
Now I want to filter the results from the database join via where (where {thistable}.id = ...).
This also works fine as long as I use a hardcoded value for the Where clause.
BUT I want to use the calc element placeholder and this doesn´t work.
Is there a chance to use placeholder with Databasejoin?
Fabrik 3.9 | Joomla 3.9
I build a form with 2 elements.
First element is a Calc Element (returns an id from somewhere).
Second element is a database join to an existing table.
The databasejoin should be rendered as checkbboxes.
Now I want to filter the results from the database join via where (where {thistable}.id = ...).
This also works fine as long as I use a hardcoded value for the Where clause.
BUT I want to use the calc element placeholder and this doesn´t work.
Code:
WHERE {thistable}.id= '{registered_teams___comp_id}'
Is there a chance to use placeholder with Databasejoin?
Fabrik 3.9 | Joomla 3.9