SoftadminGuide.Parameter_Columns_Create

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