chris.paschen
Chris Paschen
We've got a database join element on a form.
We have a joins where of:
WHERE {thistable}.user_id = {$my->id} AND {thistable}.state = 1
This works perfectly in the front-end. The users can only select options from the lookup table that matches their user id.
However, we need to have administrators access the same form on the admin-side but they should not have that filter applied.
We've tried to use the Apply Where To (user access level); however, the administrators are members of the front-end group (authors) that needs to access this with the filter, so it is being applied to administrators as well.
Is there any way to apply the filter on the front-end only, no mater what the level of user?
Would there be a way to do that with an Eval option code?
We have a joins where of:
WHERE {thistable}.user_id = {$my->id} AND {thistable}.state = 1
This works perfectly in the front-end. The users can only select options from the lookup table that matches their user id.
However, we need to have administrators access the same form on the admin-side but they should not have that filter applied.
We've tried to use the Apply Where To (user access level); however, the administrators are members of the front-end group (authors) that needs to access this with the filter, so it is being applied to administrators as well.
Is there any way to apply the filter on the front-end only, no mater what the level of user?
Would there be a way to do that with an Eval option code?