7 Replies Latest reply on Mar 2, 2017 10:15 AM by Kellie Mecham

    How to pull the Accounts.AccountID into a report

    Leon Adato

      It's a fairly well-known problem that SQL reports not only do not obey Account Limitations, but viewing SQL reports from an account with a limitation will fail.

       

      I realized over the weekend that if I could pull the account limitation (Limitations.WhereClause) into a query, that problem would magically go away. The path for this value is:

       

      Accounts.AccountID -> Accounts.LimitationID1 -> Limitations.LimitationID -> Limitations.Whereclause

       

      The challenge is HOW to get the current user's accountID?

       

      Any ideas?