I understand having the Company/Plant security control in place for typical users so they obviously don’t see what they are not allowed to. But for System Admins users or users that are used for internal purposes only, the security really drags down the performance of the BAQ. Especially for tables like PartMtl, JobMtl that have the plant field. (The plant security wouldn’t be so bad if they used a temp table to join on, like the company security does, but instead it uses a function that calls a function that calls a function that fires on each row)
I know we could always go the External BAQ route but that just seems like an unnecessary work around and doesn’t keep the query definition self contained in the Epicor database.
So I would like to see a “View All Data” flag on the User that would remove the security baggage the goes along with regular users when running a BAQ.