Filter

The Filter component is used to generate search conditions that are used in the following cases:

• Loading data in the navigator
• Filtering data in the Main Form
• Filtering data before exporting so that only the filtered data is exported as shown in the following snapshot:

Illustrative snapshot (Export Wizard):

 

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) 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).

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.

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

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 

• Filter operator must be either [ Equals to ] or [ Not Equals to ].
• Filter value must be "null" (without double quotes) (it is case-insensitive).