You need to sign in to do that
Don't have an account?
Wizrad
Query Too Complicated & Sharing
Hi all,
I have a query, and while it is quite long, it excutes fine under one profile and gives the "Query Too Complicated" error on another profile.
AFAIK, the only differences between the two profiles is that one user has "Modify All" on the object being queried, and one user has records shared with them.
Does sharing play a role in "query complication"?
Thanks!
Yes, View All Data or Modify All Data bypasses some security checks, thus making the query far simpler than for a user without these permissions. You'll have to give at least View All Data permission, or simplify the query, possibly breaking it into multiple passes, if necessary.