Manual Filtering

Users can be allowed to filter column contents at runtime based on a text value.

Configuring Manual Filter

In the Basic Settings section, select Allow Filter :

Grid Allow Filter configure

Applying Manual Filter

At runtime, a text box appears under each column name, allowing users to filter by this column content :

Grid Allow Filter runtime

Only values that start with the input text is filtered.

Clearing Manual Filter

To clear the filter, the User can click on the cross of that text box :

Grid Allow Filter runtime clear

Manual Sorting

When loading a Grid widget, sorting order depends on data binding and sorting configuration.

However, when manual sorting is allowed, the User can click on column titles to manually sort the Grid on that column :
To enable this feature (enabled by default), un-check Allow Sorting under Basic Settings :

Grid Allow Sorting configure

Single sorting

Clicking the column header will cycle between 3 states :

  • not sorted
  • sorted ascending
  • sorted descending

Example

Here is the default sorting : Year ascending, continent ascending, (Production ascending) :

Grid Allow Sorting example 1

When the User clicks on continent, the Grid is now sorted by continent in ascending alphabetical order :

Grid Allow Sorting example 2

When clicking a second time, the column is now sorted descending :

Grid Allow Sorting example 3

Number fields can also be sorted manually :

Grid Allow Sorting example 4

Multiple sorting

Using the Ctrl keyboard key and clicking another column header (Ctrl+click) will combine the sorting clauses in the correct order.
A number icon indicates the order of the sorting clauses.

Example

  1. Clicking on UP twice sorts it in descending order,
  2. Ctrl+click on Count sorts by “UP descending” first, then “Count ascending”
  3. Ctrl+click on Line twice sorts by “UP descending” first, then “Count ascending”, then “Line descending”

Grid Allow Sorting example 5
Last modified: Aug 22, 2019

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment