Skip to main content
evan_luberda
evan_luberda
Helper ⭐️
October 20, 2016

Admin Office Hours - October 27th, 2016

  • October 20, 2016
  • 2 replies
  • 62 views
This thread is for the Admin Office Hours session for Thursday October 27th, 
2016.  Submit your questions to this thread and we'll address them during our session at 11am PST/ 1pm CST.

To register for this session, please click here.

      2 replies

      steven_doty
      steven_doty
      Contributor ⭐️⭐️⭐️
      October 26, 2016
      How can I report on instances where one user lookup matches another, without specifying?

      My use case is that I'd like to see the last time the Account Owner and CSM logged an activity on the account. I know I could specify the account owner's ID, but I have too many account owners to create the number of distinct rules required for such an approach. I'd like to make something like 
      Select Account.ID, Max(Date) from Activity where Activity.AssignedTo.ID=Account.Owner.ID .
      I'd load this on the account or customer info then as the last time the customer was contacted.
      evan_luberda
      evan_luberdaAuthor
      Helper ⭐️
      October 27, 2016
      Office hours are starting now! Click here to join!
      Terms & ConditionsAccessibility statement