1 Reply Latest reply on Mar 18, 2013 4:46 AM by Stu McNeill

    query for non resolved and either unassigned or assigned to me

    itskiguy Apprentice



      I'm running Service Desk 7.5 not service packed.


      I'm trying to put together what should be a very simple query.  I want to query Incidents that meet the following criteria:


      status is not closed

      status is not resolved

      current analyst is either null, me, or a recently departed employee


      here is what I have in the criteria definition


      Status.Title Is Not Equal To ( Closed )

      AND Status.Title Is Not Equal To ( Resolved )

      AND Current Assigned Analyst Is One Of ( me, otherperson )

      OR Current Assigned Analyst Is Null


      Advanced Criteria Conditions:

      (1 AND 2) AND (3 OR 4)


      When I test this query, I get no results.  If I remove either line 3 or 4, it works fine.  Any thoughts on what this query should look like to make it work?