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