Sorting
Grid displays support sorting by clicking on a column heading. Clicking again will reverse the sort order. An arrow icon in the heading will indicate the sort column and direction.
Filtering
There are three filtering options:
•Column Filtering
•Row Filtering
•Page Filtering
Column Filtering
Column filtering can be accomplished by entering free form text in the column filter input box or using the column dropdown when provided.
Enter a value in the filter text box and press <Enter> to filter. Filtering in text columns will be done with a "Contains" operation. To specify a "Starts With" operator, precede the string with "*", e.g. "*co".
Additional filters on the same page will be applied with "And" logic.
.png)
When a filter is in effect, the navigation ribbon will update to reflect counts associated with the filter. For example, a filter has been made on the Fields page and counts for Tables, Variables, etc are updated to show the counts associated with the filtered Fields.
.png)
Column Filters may only be applied to one page at a time. Creating a column filter on another page will replace all filters previously created on the initial page.
Clearing Column Filters
Filters may be cleared in one of several ways.
•Press the button on the Filter Bar.
•For a dropdown filter, select "All" from the list.
•Remove the text from a filter text box and press <Enter>.
Note that removing any one filter will clear all filters. You cannot remove a filter singly.
Column Filter Modifiers
You may use a modifier in the filter to specify a filter operation type as shown in the table below.
Modifier
|
Example
|
Description
|
Column Type
|
=
|
=99
|
Equal (default)
|
Number
|
!=
|
!=99
|
Not Equall
|
Number
|
>
|
>99
|
Greater Than
|
Number
|
<
|
<99
|
Less Than
|
Number
|
>=
|
>=99
|
Greater Than or Equal
|
Number
|
<=
|
<=99
|
Less Than or Equal
|
Number
|
*
|
*value
|
Starts With
|
Text
|
%
|
%value
|
Ends With
|
Text
|
The Modifier characters will always be treated as modifiers. There is no direct way to use these Modifier characters as actual search text. A workaround is use the Page Filter followed by Row Filter "Filter to Visible".
Row Filtering
Filtering by Row may be accomplished by right-clicking in the grid and choosing an option from the context menu.
•Filter to Selected: Use the currently selected rows as filter criteria. Selected status is indicated by shading. You can selected multiple rows using Shift-click or Ctrl-click.
•Filter to Visible: All currently visible rows on the page will be used as the filter criteria. This is particularly useful when combined with the page Search function.
.png)
Page Filtering
Page Filtering is performed by typing text in the grid Search box and pressing <Enter>. Search is performed in the content of all columns on the current page.
A Page Filter does not filter other pages.
Page Filters do not persist when leaving the page.
.png)
Clearing Page Filter
To clear a page filter, remove the text from the Search box and press <Enter>.
|