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?