How to use Filter Editor in Table General?
Posted: Wed Apr 10, 2024 8:13 pm
Dear all,
I Have view name StatusHoliday and have field Dept_id, I have table teacher and field Dept_tc
i want filter record that match StatusHoliday.Dept_id = Teacher.Dept_tc
in Filter Editor:
"`dept_id`='SELECT DEPT_TC FROM TEACHER WHERE TEACHER_ID = '.CurrentUserID().'"
How to use correct syntax in filter editor query?
Please help me.
Best Regards
me