Knowledge Base
Using a /RefreshCondition help to join 2 tables (or more).
Tag: 29729
Problem Summary:
I want to extract a table based on a join condition because they are dependent tables, for example
select <....>
from tab1 t1, tab2 t2
where t1.id=t2.id
and modified_date >(select max(date) from tab3)
Is it possible to put in a join condition in the /RefreshCondition for /Restrict Action?
Description/Solution:
Yes, it is possible using the /Restrict action on a table, using the format below:
/RefreshCondition="where id in (select t2.id from tab2 t2 where modified_date > (select max(date) from tab3))"