SoftadminGuide.FieldStandard_ColumnsWithOperator

Type: Stored procedure

Creates a standardized control to pick multiple columns, like SoftadminGuide.FieldStandard_Columns_Create, but with "=" or "LIKE" operators added.
This is useful when selecting columns for a WHERE-search. To see it in action, look at the "Search, New, Edit, Delete"-guide.

Expects a table #SoftadminGuideMultiControl created by SoftadminGuide.Field_MultiControl_Definition.

Parameters

@FieldName mandatory varchar(1000)
The field name, used to refer to this field by other fields and when getting the value from the multi-control.
@Label mandatory varchar(1000)
@TableFieldName mandatory varchar(600)
The field name of a field created using SoftadminGuide.FieldStandard_Table_Create.
@JoinsFieldName optional varchar(600)
The field name of a field created using SoftadminGuide.FieldStandard_TableJoins_Create.
@Description optional nvarchar(max)
@IsMandatory optional bit
Default 1.