Menu dropdown

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

The dropdowns are configured using Admin -> Menu -> Menu dropdowns.

SQL

SQL Call: Populate dropdown (mandatory)

The values the user can choose from.

May modify database: No

Resultset: Values

Table count: 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.
LogotypeUrl optional string
Logotype to use when this value is selected in the dropdown.
LogotypeUrlMinimized optional string
The minimized logotype to use when this value is selected in the dropdown. If this is omitted then LogotypeUrl will be used when the menu is minimized.

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.

May modify database: No

Parameters

@MenuItemId int
The current menu item id.

Resultset: Redirect (optional)

Table count: 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

Table count: 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.

May modify database: No

Resultset: Default value

The default value of the dropdown.
Table count: repeated exactly once
Row count: exactly one row
Columns
<column with ordinal 1> mandatory any
Default value.