6 Replies Latest reply: Apr 8, 2014 3:23 AM by Alex Hamilton McLeod RSS

    Exception expression

      Using the attached sample data, how can I find out which usernames have WorkingDayDisconnects as 'true' for ALL sessions and also for which the DisconnectionReason reason is only ever blank or 'CLOSED_BY_CLIENT'

       

      i.e. if WorkingDayDisconnect is 'true' even once for a username, it needs to be excluded from the results. Similarly, if the DisconnectionReason is anything other than blank or 'CLOSED_BY_CLIENT' for all session, then it too must be excluded.