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?
Answer
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))"