1 Reply Latest reply on Dec 4, 2017 2:49 PM by Donna

    Search - create a CI search that allows for this set of parameters

    Donna Apprentice

      I need to create a search in the CI space that does this:

      ci service-stat3.JPG

      I get an error "One or more conditions are invalid or incomplete. Update the highlighted fields."

       

      The first and second line work but I cannot figure out how to make the last line work.

      CI# Status is a field constrained to a Pick List called StatusType of CIStatus

      CI#Service Status is constrained to a Pick List called StatusType of CIServiceStatus

       

      I also tried

      CI#  Status  Not Equal to  $(Status == "Historical" ||⁽²⁾ [CI#Service.]⁽¹⁾Status == "SDOnly")

      which gets me this

       

      is there any way to make a query like the work?

       

      thanks all

      Donna