Character (Att type or control type)

CharacterImg01

Character node has the following properties:

Category Property  
General Properties Default Operator CharacterImg02
Default Operator Type
Title Filter Default Operator
Condition Casing
Grid Title Filter Include Title Filter
Search Box
Data List
Allow Multiple Selection
Data List Include Total Records
Data List Update Minimum Characters
Data List Max Values
Range Range Middle Text
Range From Default Operator
Range To Default Operator

General Properties:

Default Operator:

Specifies the operator that will assign by default to all filters based on character attributes. In the example of the image, it will assign as the default operator 'like'.


Default Operator Type:

Specifies the default type of operator that will be assigned by default to filters based on character attributes or when inserting a regular filter.

Value With dynamic operators, by default will insert the following:

CharacterImg03

Value Regular:

CharacterImg04

Value Range:

CharacterImg05

Title Filter Default Operator:

Specifies the default operator that will be assigned by default to the title filters.

Condition Casing:

Specifies if it will include in the filter condition a casing condition. The values for this property are None, ToUpper, ToLower. 
 

Value ToUpper, by default will insert the following condition:

CharacterImg06

Properties Of Category Grid Title Filter:

Include Title Filter:

Specifies the default value for the attributes of this kind of type (in this example Character). This property in attributes specifies if it will include column title filter or not. All the following properties of this category only applies when this property is True.


Search Box:

Specifies whether these kind of attributes will have a search box inside the column title filter.  The possible values are:

  • None: it won't include a search box
  • Single: it will include one search box
  • Range: it will include two search boxes so that users can filter from some data to other data
  • Date Range Picker: it will use the range picker displayed in the following link: New User Control for Date, Datetime, and Range fields. Only applies for Filters Date and DateTime

CharacterImg07

Data List:

Specifies whether these kind of attributes will include a list of the possible values or not. The options for this property are:

  • Dynamic: means that it will include a list of real values of this column, and these search will be done on server side, which means that will display values from the current page and from pages that are not visible.
    CharacterImg08
     
  • Fixed: means that it will include a list of fixed items. This can be used when the attribute contains enumerated values, or is a combo box with fixed items.
    CharacterImg09
     
  • None: it won't include a list with possible values for that column.

Data List Include Total Records:

Specifies whether to include next to the data item, the amount of records which have that value. This only applies when the data list is dynamic.


Data List Update Minimum Characters:

Specifies the minimum amount of characters needed to fulfill in the search box, so that the dynamic list updates its values. If the value is 0 means that you can leave empty the search box and the dynamic list will be displayed and updated. This only applies when the data list is dynamic.


Data List Max Values:

Specifies the maximum amount of items to display in the dynamic data list.


Allow Multiple Selection:

Specifies whether the filters associated to the grid titles will have the option to select more than one option from the list or not. This property only makes sense when the property 'Data List' has the value 'Fixed List' or 'Dynamic List'.


Example of property 'Allow Multiple Selection' as True

CharacterImg10

Example of property 'Allow Multiple Selection' as False

CharacterImg11

Properties Of Category Range:

Range Middle Text:

Specifies the text that will be displayed between the from field and the to field, in a range filter.


Range From Default Operator:

Specifies the default operator for the from field.


Range To Default Operator:

Specifies the default operator for the to field.


If you want to read more information about Column Filters, read the following link: Column Filters

The nodes Varchar, Numeric, Date, DateTime, Boolean and Combo are analogous to this node but for different type of attributes and control types.