You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Runtime Filter using Logical

edited Jul 13, 2018 2:02PM in Reporting & Analytics for B2C Service 13 comments

Content

Hello,

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)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!