I have an foriegn key deptid in entity employee where each dept has ValidFrom, ValidTo columns.
Dept table has some new depts and some old ones, having a validTo date.
So, in Employee entity, foreign key deptid, how do I mention filter conditions to compare ValidTo to current date, so I can see only those depts which has a ValidTo date greater than today's Date.
Tried ValidTo > fn:current-date in the foreign key filter but not working.
