Using a /RefreshCondition help to join 2 tables (or more).

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #22295

    Donna Zehl
    Keymaster

    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))"
    
    
Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.

© 2019 HVR

Live demo Contact us