teoyh
Member
In one of my list I had added the following prefilter;
Join : Where
field : codeno
Condition : In
Value : select substring(sapno,3,8) from employee
Type : Query
Apply : Registered
But I the following error;
You have an error in your SQL syntax;
....
FROM `attendance`
WHERE (attendance.codeno IN (select substring(sapno,'3','8) from stm_employee') ) LIMIT 0, 10
Any reason why substring cannot be used ?
Join : Where
field : codeno
Condition : In
Value : select substring(sapno,3,8) from employee
Type : Query
Apply : Registered
But I the following error;
You have an error in your SQL syntax;
....
FROM `attendance`
WHERE (attendance.codeno IN (select substring(sapno,'3','8) from stm_employee') ) LIMIT 0, 10
Any reason why substring cannot be used ?