If I restrict my view to certain location from the

Set Preferences

page, why does

select * from account

return no results when I can still go to

Chart of accounts

page to see all the accounts.

its filtering by the account location restriction

Ya apparently, it is But

search

module doesn’t do that I also didn’t find a field that was returned by the query to use to try and bypass this filtering.

does the

query

module do this?

no I have it on a script, we are not getting the same results after switching from

search

to

query

.

gotcha, yeah that's an interesting quirk then, and not in a good way