Filter properties
The filter controls list is an editable list where the user can refine the controls behavior. The default setting is automatically defined by the Web Designer, when creating the filter panel. During the filter panel definition, the select clause of the binded business component is analyzed: for each field in the select clause, a control is created and added to that list. Control type, linked label, mandatory, length are automatically set, according to the settings of the database fields: if a database field is mandatory, the control is mandatory and so forth. There are a great deal of filter control properties; in order to make it easy the filter control definition, not all properties are showed, only the most common; it is possible to access to the whole range of properties, by pressing the "Advanced mode" button on the toolbar.
These are all properties defined for a filter control:
To manage – flag used to define if the field must be managed, in terms of make it visible, editable and saved
Position – control order in the form
X – (optional) in alternative to the position, a label + control can be positioned exactly in a specific location, using x and y coordinates, expressed in pixels
Y – (optional) in alternative to the position, a label + control can be positioned exactly in a specific location, using x and y coordinates, expressed in pixels
Width – total width including label + control; note that for each controla label will be always created on its left, except when the label has a zero text length
Height – (optional) it can be useful in case of multi-line text controls
Label – text label, if it is empty, the label will be omitted
Operator – defines the filter operator to use: =, <, >, like, etc.
Control type – application type to apply for the control; typically this types are preset by the Web Designer when creating the form and are compatible with the database field type; the user can change this application type and refine the control format, for instance by setting a control with a date type for a datetime field. Allowed application types are defined below
Code selector – in case the control has a combo-box/lookup type, this additional property must be defined, in order to specify which code selector will manage this control
Directory upload – in case the control has a "File upload/download" type, this property must be defined, in order to specify which is the default directory where saving/loading files
Default value – value to preset into the filter control
Field length – in case of text controls, this attribute defines the maximum characters allowed in edit
Integers number – in case of number control, this attribute defines the maximum number of integer digits allowed in edit
Decimals number – in case of number control, this attribute defines the maximum number of decimal digits allowed in edit
To uppercase – flag used to make the text edited by the user be in uppercase
Mandatory – flag used to force the editing of this control, which cannot be empty when saving data
Can copy – flag used to allow the copy of the control value, when clicking on the copy button on the form toolbar
Right padding – property used to apply the right padding to a text/char control: the number is used to ensure that the final value for the control will have enough spaces on the right so that the final control value will have a length equals to this number
To trim – flag used to apply a trim to the text (no spaces on the left and right)
Positive value in check-box control
Negative value in check-box control
Minimum date – in case of date/datetime type, it is possible to set a minimum date the user can set
Maximum date – in case of date/datetime type, it is possible to set a maximum date the user can set
Minimum numeric value – in case of number type, it is possible to set a minimum number the user can set
Maximum numeric value – in case of number type, it is possible to set a maximum number the user can set.
Additional config - Optionally, it is possibile to define at control level additional settings, which will be injected along with all the others provided by Platform. These settings must be compatible with the ones defined by ExtJS for a Ext.form.Field and subclasses. In order to add these settings, use the advanced property "Additional Config." where you can specify a list of properties. The content of this property will be included in a more general {...} javascript object containing the column properties. Consequently DO NOT append the {} brackets within this property, since they are already provided by Platform. You have simply to append your properties and separate each of them with a comma ,
For example: for smart controls you can set the grid, the business component and the placeholder text for control
Allowed application types for controls, according to the related database field type:
Database field type | Application type |
Text | Text, Multi-line text, Check-box, Local/Remote Combo-box, Button lookup, Code+Button lookup |
Integer | Number |
Decimal | Number |
Char | Text, Check-box, Local/Remote Combo-box, Button lookup, Code+Button lookup |
Datetime | Date, Datetime, Time |
Date | Date, Datetime, Time |
Internal Counter | Internal Counter |
Counter based on a table | Counter based on a table |
Counter based on a custom business component | Counter based on a custom business component |
Sequence | Sequence |
File identifier | File upload/download |
Note that it is not allowed to insert/delete filter controls in this list: filter controls are automatically synchronized with the fields defined in the select clause of the binded business component, which are automatically synchronized with the data fields defined in the binded data model.
Last updated