Runtime Filter using Logical
This is something so easy in standard SQL but I'm struggling with in OSvC, how do you do multiple logicals for example ((a & b) or (c & d) or (e and f)) ? Can you show me a screenshot of a filter like that? Or is there a way to manually edit the and/ors text?
(Status AND assgn_acct_id) OR (Last Edit AND assgn_acct_id AND Transaction Type) OR ( incidents.source_hierarchy in list Ask A Question, End-user Incident Update AND transactions.trans_type in list Status Changed AND transactions.source_hierarchy in list End-user Incident Update AND incidents.status_id in list Solved)