# Dynamically Selecting Pages in Tab Container

**URL:** <https://forum.inductiveautomation.com/t/dynamically-selecting-pages-in-tab-container/93196>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [July 13, 2024, 11:27pm UTC](https://forum.inductiveautomation.com/t/dynamically-selecting-pages-in-tab-container/93196 "2024-07-13T23:27:36Z")\
**Posts on this page:** 1\
**Showing post:** 13

<div class="post-metadata">

**Author:** ![mdemaris](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mdemaris/32/54639_2.png) [@mdemaris](https://forum.inductiveautomation.com/u/mdemaris)\
**Post date:** [July 15, 2024, 5:12pm UTC](https://forum.inductiveautomation.com/t/dynamically-selecting-pages-in-tab-container/93196/13 "2024-07-15T17:12:35Z")

</div>

If you are working with SQL Server, the Adventure Works DB, if I remember correctly, has an example of a table that you can set up to use with a recursive query, similar to this:

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/b/2/b2e2503b2381d4324d1400cf6add6c847df7ba0c.png)

Where you list all the menu options, then using `ParentMenu` indicate which Sub Menu Item belongs to which Main Menu option. When I created this I was going to create more than one table, but then remembered the whole `ParentMenu` concept, so the ID column name will change to `MenuID`.

EDIT:  
I decided to add a menu numbering system as well, because the primary ID numbers may get wonky.

```python
CREATE TABLE [Menus].[MenuSystem](
	[MenuID] [int] IDENTITY(1,1) NOT NULL,
	[MenuName] [nvarchar](50) NOT NULL,
	[DisplayName] [nvarchar](50) NOT NULL,
	[DisplayOrder] [int] NOT NULL,
	[ParentMenu] [int] NOT NULL,
	[MenuNumber] [int] NOT NULL,
 CONSTRAINT [PK_MainMenu] PRIMARY KEY CLUSTERED 
(
	[MenuID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [Menus].[MenuSystem] ADD CONSTRAINT [DF_MenuSystem_ParentMenu] DEFAULT ((0)) FOR [ParentMenu]
GO

```

EDIT:  
Is it possible to send a session property to a project script to determine which menu values are available to an authorized user? Or would it be better to setup a table with the roles and menu items and just query that?

I don't see another way to dynamically enforce security without a lot of `IF` statements.

---

_[View the full topic](https://forum.inductiveautomation.com/t/dynamically-selecting-pages-in-tab-container/93196)._