Home Topics HVR Real-time Replicator Knowledge Base Using a /RefreshCondition help to join 2 tables (or more).
Using a /RefreshCondition help to join 2 tables (or more).
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 /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))"
© 2019 HVR
It appears you are still using Internet Explorer. Support for IE has been discontinued by Microsoft, and many features of our site may not display or work properly.
Please upgrade (it's free!) to Edge, Chrome, Safari, or any modern browser for the best user experience.