The caption is the text that is shown in front of the actual search field. This is a translatable text. See Translatable Texts.
|Normal||The search field is visible and editable by the end user.|
|Hidden||The search field is hidden and is only there to selectively display objects in the grid.|
|Read-only||The search field is visible but not editable by the end user.|
The default value is the initial value for the search field. In the case of a normal search field, this value can then be edited by the end user. In the case of a hidden or read-only search field the value is fixed.
The text that is entered into the search field is searched for in the given attribute. For each object in the grid, the attribute is inspected to see whether it matches the value that is being searched.
The attribute can be an attribute of the entity in the data grid but also an attribute of an associated entity (an attribute path). The path can follow any number of associations of type reference and optionally a reference set at the end. If you use a reference set all references will be checked for possible matches.
The table below shows the types of the attributes that are allowed in search fields.
|Search field||Allowed direct attributes||Allowed associated attributes|
|Comparison||AutoNumber, Currency, Date, Decimal, Float, Integer, Long, String||AutoNumber, Currency, Date, Decimal, Float, Integer, Long, String|
|Drop-down||Boolean, Enumeration||AutoNumber, Boolean (added in 5.5.0), Currency, Decimal, Enumeration, Float, Integer, Long, String|
The value entered by the end user (or the default value in the case of hidden and read-only search fields) is compared to the value of the attribute of each of the objects in the grid. If the match succeeds, the object will be part of the search result. There are different ways in which the attribute value and the entered value can be compared. In the third column below you see the type of search field for which the comparison operator is allowed.
|Value||Description||Search field types|
|Contains||Does the attribute value contain the entered value?||Text (attribute must be of type String)|
|Starts with||Does the attribute value start with the entered value?||Text (attribute must be of type String)|
|Greater||Is the attribute value greater than the entered value?||Text, Date|
|Greater or equal||Is the attribute value greater than or equal to the entered value?||Text, Date|
|Equal||Is the attribute value the same as the entered value?||Text, Date, Drop-down|
|Not equal||Is the attribute value not the same as the entered value?||Text, Date, Drop-down|
|Smaller or equal||Is the attribute value smaller than or equal to the entered value?||Text, Date|
|Smaller||Is the attribute value smaller than the entered value?||Text, Date|
Default value: Equal
The number of drop-down selection options is capped at 1,000. Therefore, no more than 1,000 unique values of a selected attribute can be selectable. This limit has been set to protect page loading performance on older browsers when these options need to be retrieved from the server. In Mendix 8 this limit has been removed.
If this property is set to ‘Yes’, the resulting drop-down allows you to select multiple values instead of just one. When searching all records match for which the corresponding attribute is equal to one of the selected values. For example, you can search for all orders with status ‘Submitted’ or ‘In progress’.
If the ‘drop-down’ search field is connected to an attribute of an associated entity (as opposed to the grid entity itself) the XPath constraint can be used to limit objects shown in the drop-down.
Let us say you have a grid showing bicycles. In the domain model the bicycle has an association to the shops where you can buy those bicycles. You can add a search field to the grid allowing the end user to select a shop by name. The XPath can then be used to limit the shops to those that are in a given country.
The sort order specifies the order in which the items in the drop-down search field are shown. You can sort on multiple attributes in both directions (ascending and descending). If no sort order is specified, the drop-down search field sorts on the displayed attribute.
Default value: No sort order