MDM Foreign Key filter

djugal — Sat, 16 Nov 2024 02:48:39 GMT

Hi,

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.

Any Help ??

Talend Fabric 6.5.1

topic MDM Foreign Key filter in Talend Data Catalog

MDM Foreign Key filter