11 Replies Latest reply: Jul 14, 2017 3:33 PM by oliver clements RSS

    Where Not Exists()

    oliver clements

      I am trying to improve load times and have been updating code to allow for efficiency. one of the changes i was making is in regards to the Exists() function. my current script looks like this:


      FROM $(WorkflowPath)\test.QVD (qvd)
      where test_SYSTEM_CD <> 'CWF';


      and this works, but when I change "where test_SYSTEM_CD <> 'CWF';" to "where not exists(test_SYSTEM_CD,'CWF');" it returns 0 results. this would probably only save me a few seconds, but i am more interested in why this wouldn't work.

      Thanks in advance.