Type:
Stored procedure
Creates a standardized control to pick multiple columns.
Expects a table #SoftadminGuideMultiControl created by SoftadminGuide.Parameter_MultiControl_Definition.
Parameters
@ParameterName
mandatory
varchar(1000)
The parameter name, used to refer to this field by other fields and when getting the value from the multi-control.
@Label
mandatory
nvarchar(1000)
The parameter label.
@TableParameterName
mandatory
varchar(600)
The parameter name of a field created using SoftadminGuide.Parameter_Table_Create.
@JoinsParameterName
optional
varchar(600)
The parameter name of a field created using SoftadminGuide.Parameter_JoinTables_Create.
@Description
optional
nvarchar(max)
Description for the field.
@IsMandatory
optional
bit
Whether the field should be mandatory.
Default: 1.
@CustomWhere
optional
nvarchar(max)
Custom where statement. May refer to these aliases:
C = sys.columns
TY = sys.types
C = sys.columns
TY = sys.types