2 Replies Latest reply on Jan 8, 2015 4:16 AM by murali.cherukuri

    Query Design using AND/OR criteria

    Rookie

      I am having trouble getting the results I want froma query, I have found the document 'OR Criteria in Query isn't showing the correct result' but still can't get the results I want which are:

      All incidents which are NOT at a status of Closed or Resolved;

      AND Current Assigned Group = UHL Telecoms

      AND Current Assigned Analyst is NOT DP Telecoms

       

      As this query will not return any incidents assigned to the UHL Telecoms group which have not been assigned to an analyst I have tried including:

      OR Current Assigned Analyst IS NULL

      but this returns nothing at all!

       

      I am using Service Desk 7.5

      Here is a screenshot of my query:

      Telecom Query.png

       

      Any help would be much appreciated.