Home | Using Katmandoo | Quick Start Guide | How-to | Task Menu | Table of Contents | See Also | Collapse All

Filter

Overview

The Filter component is used to generate search conditions that are used in the following cases:
Illustrative snapshot (Export Wizard):
Filter in the form (Click to change size) 
  1. This drop down list box lists all the columns from the data grid (above), data will be filtered by the currently selected column name.
  2. Select a condition from the list. Please note that depending upon the data type of the selected column name, the operator list will be changed.
  3. Enter filter value in this text box
  4. Click Apply Filter (Apply Filter) to apply the specified filter condition
  5. Click (Remove Filter) to remove an existing filter condition
Illustrative snapshot (Main Form Template):

Note: Filter component in Main Form Template and Export Wizard has auto-complete feature (which populate first 1024 unique values for the selected filter column).

Filter with Auto-complete in main-form (Click it to change its size)
  1. Filter column (sorted on name and are in the main datagrid).
  2. Filter operator (specific to the data type of the filter column).
  3. When a filter column is selected, Katmandoo populates first 1024 unique values of the filter column in order to use as auto-complete for filter value as shown in (4).
  4. Auto-complete values that start with "b" as user has typed "b" in this example.
  5. Click it to apply filter.
  6. Click it to remove filter.

Filter Operator

Condition Description Applicable Data Type
Starts with Matches only those values of the selected column that start with the given filter value. String
Equals Matches only those values of the selected column that equals the given filter value. String, Numeric, DateTime and Boolean
Contains word Matches only those values of the selected column that contains the given filter value. String
Not Equals to Matches only those values of the selected column that do not equal the given filter value Numeric, DateTime
Greater than ( > ) Matches only those values of the selected column that are greater than the given filter value Numeric, DateTime
Greater than or Equal to
( >= )
Matches only those values of the selected column that are greater than or equal to the given filter value Numeric, DateTime
Less than (< ) Matches only those values of the selected column that are less than the given filter value Numeric, DateTime
Less than or Equal to
( <= )
Matches only those values of the selected column that are less than or equal to the given filter value Numeric, DateTime

Filter Value

The Filter Value can not contain any characters/words that are specified as Invalid Characters for string filter value.

NULL can be used as filter value in the Main Form only and 

See Also