Sorting and Filtering Data

Sorting

To sort C1DataView rows, complete the following steps:

From the C1ViewSetDesignerForm, select a DataView.
Enter a sort order definition in the Sort property by specifying the columns in the order they should be sorted.

Note: Each column name should be separated by a comma. Ascending order is the default sort order, but you can sort in descending order by adding DESC after the column name.

Filtering

To filter C1DataView rows, complete the following steps:

From the C1ViewSetDesignerForm, select a view from the ViewSet.
Enter a filter definition in the DataView's C1DataView.RowFilter property.

The syntax of a filter expression is the same as for the WHERE clause of the View Definition Language, with the single exception that the RowFilter expression references columns of C1DataView (C1ViewColumn objects) while the View Definition Language's WHERE expression references columns of the base DataTable(s).