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