Component: Menu dropdown

 Show all Hide all

Allows the user to set a session variable via a dropdown in the sidebar.

The dropdowns are configured using the Menu dropdowns menu item in the Admin menu group.

SQL

SQL Call: Populate dropdown (mandatory)

The values the user can choose from.
Supports custom errors: No
May modify database: No

Resultset: Values

Repeat mode: repeated exactly once
Row count: zero or more rows

Columns:

<column with ordinal 1> mandatory any
Id value. The session variable will be set to this value when the user selects this option.
<column with ordinal 2> mandatory string
The value shown to the user.

SQL Call: Redirect (mandatory)

Called after the user selects a value.

The temp table #menuitemparameters is available in the procedure and contains the parameters of the current menu item.
Supports custom errors: No
May modify database: No

Parameters:

@MenuItemId mandatory int
The current menu item id.

Resultset: Redirect

Repeat mode: repeated zero or one time
Row count: exactly one row

Columns:

MenuItemId optional int
Menu item to redirect to.
PassingFields optional string
Query string.
Reload optional bit
Set to 1 to reload the current page instead of redirecting.

Resultset: #menuitemparameters

Repeat mode: repeated exactly once
Row count: zero or more rows

Columns:

name mandatory string
Parameter name.
value mandatory string
Parameter value.

SQL Call: Default value

The default value of the dropdown. Only called if an SQL query is entered.
Supports custom errors: No
May modify database: No

Resultset: Default value

The default value of the dropdown.
Repeat mode: repeated exactly once
Row count: exactly one row

Columns:

<column with ordinal 1> mandatory any
Default value.