4 Replies Latest reply: Feb 10, 2014 7:50 PM by Alec Smith RSS

    QVW Load Statement Where Clause

    Alec Smith

      Hello,

       

      I have four separate taps that each contain a separate load statement (see first screen shot). I am trying to add a WHERE clause on the JrnlHdr load statement (i.e. WHERE JrnlHdr.JrnlKey_Journal IN (3,5,11) and have it apply to all of the other load statements (see data model screen shot).  When I add the WHERE clause to the "JrnlHdr" load statement, the other load statements do not reduce the number of fetched records as expected.  

       

      Thank you in advance for any assistance. 

       

      Screen Shot 2014-02-10 at 1.39.33 PM.png

      Data Model 2.png