2 Replies Latest reply on Apr 7, 2014 9:09 AM by Charles Budd

    Custom filter with multiple conditions including list?

    Charles Budd

      Hi all - I'm trying to create a custom filter with multiple conditions, one of which is a list. I didn't like my syntax when adding the list in, so I end up with some clunky code. I tried creating a calculated field for group 1, but that wasn't working either. Any suggestions as to how I can clean it up a little bit to make the second part a list and not a bunch of ORs?

       

      IF [Resolution]== "Unresolved" AND ([Assignee] = "User 1" OR [Assignee] = "User 2"
      OR [Assignee] = "User 3" OR [Assignee] = "User 4" OR [Assignee] = "User 5"
      OR [Assignee] = "User 6") THEN "Open - Group 1"
      ELSEIF [Resolution]== "Unresolved" AND ([Assignee] <> "User 1" OR [Assignee] <> "User 2"
      OR [Assignee] <> "User 3" OR [Assignee] <> "User 4" OR [Assignee] <> "User 5"
      OR [Assignee] <> "User 6") THEN "Open - Group 2"
      ELSE "Closed" END

       

      Thanks in advance,
      Charlie Budd