Menu Security Report

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

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.

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.

1 Like

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

Thanks.

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