I need to create a search in the CI space that does this:
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?