I want to extract a table based on a join condition because they are dependent tables, for example
from tab1 t1, tab2 t2
and modified_date >(select max(date) from tab3)
Is it possible to put in a join condition in the /RefreshCondition for /Restrict Action?
Yes, it is possible, using the format below:
/RefreshCondition="id in (select t2.id from tab2 t2 where modified_date > (select max(date) from tab3))"