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.