5 Replies Latest reply: Nov 23, 2016 1:27 PM by David Bockol RSS

    Where Clause2

    David Bockol

      The syntax for the following where clause is correct, the script runs without error, but the expected result is incorrect as if it ignored the where conditions.  I'm expecting to see only records where Entity Status2='A', Studflag='STUD' AND Profession = 'NUR' AND Yrsins2=1.  The output includes all records.  I've attached the qvw document, but the data is too large to attach.

       

       

      T1_ActiveTerm3:
      LOAD *
      Resident T1_ActiveTerm2
      WHERE ([Entity Status2] = 'A' AND Studflag='STUD' AND Profession = 'NUR' AND Yrsins2
      =1);