Hello Everyone, I want to create a BAQ that shows the Parent Menu and Sub Menu and the security group associated to each. I would appreciate if someone can tell me how to create the relationship. Thanks in advance. Miguel

You need multiple copies of the table. Chain them together with: table0.ParentID = table1.MenuID (outer left join) table1.ParentID = table2.MenuID (outer left join) table2.ParentID = table3.MenuID (outer left join) and so on for how ever many levels deep you menus go. BTW - the first instance o…

Hello Calvin, I am still new to this, would I create 3 copies of the Menu or SecGroup? and how do I tie them together. Thanks in advance. Miguel

Start with the menu table. Just put it in once. Then add some columns (I’d suggest the menuid description and parentmenu) and test it. Note that those names are guess off the top of my head. After you test it you’ll notice that the parent menu value for some rows is the menuid for one of the rows…

Or see the following: [image] Menu Security Report ERP 10 Attached is a BAQ I used for our security audit during our last upgrade. It gives the full menu structure and the assigned security for each menu item. PSG-tmsIndentedMenu.baq (39.0 KB)

Whoops … I went through all that thinking you were on E10. I’ve never used E9, so no idea on if any of that applies

Hello Calvin, That worked as you can see I now can display the structure. [image] Now I can display the security group associated to the menu? Thanks in Advance. Miguel

Hello Calvin, Is it possible to display the security group associated with the functions listed on the menu? Thanks in Advance, Miguel

Or a CTE query. :wink: Edit: E9 I don’t think supported recursive queries. @RC2020 , a BAQ setup like this should work. You should already have the top row of Ice.Menu just need the link to Ice.Security [image]

Hello Randy, I don’t see ICE.Menu as an option (See my available selection below) [image] How to add the table in your example? Thanks in Advance. Miguel

You already have the Menu tables in your BAQ. Just add the Security table to the first Menu table

Menu Security BAQ

Epicor ERP 9

ckrusen (Calvin Krusen) September 29, 2021, 12:19am 5

Or see the following:

Topic		Replies	Views
Menu Security Worksheet Epicor ERP 10	5	3685	August 16, 2017
User Fuction access through Menu Maintenance Epicor ERP 9 baq	1	933	August 27, 2022
Menu Security Yahoo Archive	13	2009	February 5, 2016
Security Report - Users and SecGroupDesc Epicor ERP 9	44	9885	August 28, 2024
Help with BAQ Query Epicor ERP 9 baq	16	1839	February 7, 2021

Menu Security BAQ

Related topics