Filtering


Spread.Views allows you to write a string expression and use it in a filtering condition. You can implement simple as well as complex filtering expressions in code using dataview.data.filter('FILTER EXPRESSION') syntax.

Use the following steps to implement filtering in Spread.Views.

Sample Code

These steps assume that you have already initialized the grid and defined the columns. See Creating a Basic Grid and Defining Columns for additional information.

Example 1
This example code uses a simple expression for filtering.

    dataview.data.filter('[quanitity]>=100')

Example 2
This example code uses a complex expression for filtering to show records for a salesperson with quantity greater than or equal to 100.

    dataview.data.filter('[quanitity]>=100'&&[Country="United States")

See Also

filter