Page 1 of 1

lookup table filter

Posted: Sun Aug 07, 2022 9:23 pm
by lamany77

hi alll
i have a code on lookup table filter

i have code below :

"active='1' and code='".currentuserinfo("code_lem")."'";

but not work

but if i try :
"active='1'"
it works

i hope the solution from you guys
thanks you very much


Re: lookup table filter

Posted: Sun Aug 07, 2022 10:03 pm
by arbei

If the user is not logged in, there is no current user info yet. You should check if the value has value first, then add the filter, e.g. you may use PHP ternery operator (? :).


Re: lookup table filter

Posted: Sun Aug 07, 2022 10:09 pm
by mobhar

Try CurrentUserInfo instead of currentuserinfo.


Re: lookup table filter

Posted: Wed Aug 10, 2022 11:03 am
by lamany77

thanks all.
it;s works