How to use Filter Editor in Table General?

[measan]

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

[mobhar]

You should only include the WHERE clause, see this documentation