# Menu Security Report

**URL:** <https://www.epiusers.help/t/menu-security-report/54004>\
**Category:** Epicor ERP 10\
**Tags:** e10\
**Created:** [March 27, 2019, 1:11pm UTC](https://www.epiusers.help/t/menu-security-report/54004 "2019-03-27T13:11:55Z")\
**Posts on this page:** 5\
**Page:** 2

<div class="post-metadata">

**Author:** ![tsmith](https://www.epiusers.help/user_avatar/www.epiusers.help/tsmith/32/64774_2.png) [@tsmith](https://www.epiusers.help/u/tsmith)\
**Post date:** [April 4, 2019, 4:34pm UTC](https://www.epiusers.help/t/menu-security-report/54004/21 "2019-04-04T16:34:14Z")

</div>

I think CTE queries are more sensitive to the ordering of the subqueries because of how they reference each other.

---

<div class="post-metadata">

**Author:** ![bmathenge](https://www.epiusers.help/user_avatar/www.epiusers.help/bmathenge/32/15872_2.png) [@bmathenge](https://www.epiusers.help/u/bmathenge)\
**Post date:** [April 4, 2019, 5:04pm UTC](https://www.epiusers.help/t/menu-security-report/54004/22 "2019-04-04T17:04:52Z")

</div>

10.2.100.7 user here.

We have never been successful in running this report with any parameter, open or specific.

We had to create BAQs to get to the data.

---

<div class="post-metadata">

**Author:** ![cgansen](https://www.epiusers.help/letter_avatar_proxy/v4/letter/c/dc4da7/32.png) [@cgansen](https://www.epiusers.help/u/cgansen)\
**Post date:** [September 28, 2021, 8:30pm UTC](https://www.epiusers.help/t/menu-security-report/54004/23 "2021-09-28T20:30:03Z")

</div>

If you run it on the server, it sometime works. But it you run it on any workstation, you can bet on it timing out.

---

<div class="post-metadata">

**Author:** ![Abip](https://www.epiusers.help/letter_avatar_proxy/v4/letter/a/ed655f/32.png) [@Abip](https://www.epiusers.help/u/Abip)\
**Post date:** [August 10, 2022, 2:00pm UTC](https://www.epiusers.help/t/menu-security-report/54004/24 "2022-08-10T14:00:38Z")

</div>

Hi, i m new in this site, need help to open this BAQ^

Thanks.

---

<div class="post-metadata">

**Author:** ![jreynolds](https://www.epiusers.help/letter_avatar_proxy/v4/letter/j/58956e/32.png) [@jreynolds](https://www.epiusers.help/u/jreynolds)\
**Post date:** [March 29, 2024, 4:17pm UTC](https://www.epiusers.help/t/menu-security-report/54004/25 "2024-03-29T16:17:40Z")

</div>

Thanks for sharing that. I was able to peel out the SQL and it’s super helpful!

[Previous page](https://www.epiusers.help/t/menu-security-report/54004.md?page=1)