Page Comparison

You can filter grids to display only the items relevant to you, and sort them in ascending and descending order.

Filtering grids

You can filter grids to list only items that:

• are equal or not equal to a number or piece of text
• are greater than, less than or between a number
• starts with, ends with or contains a piece of text
• doesn't start with, end with or contain a piece of text
• is before, after or exactly matching a date
• is within a range of two dates.

Enabling grid enhancements

Grid enhancements such as filters are disabled by default. To enable grid enhancements:

...

1. Click the arrow on the right of the header of the column you want to filter.
    
2. Select the filter you want to use.
    
3. Type the target to which you want to filter.
    
4. Click .
   The grid is restricted to items that match your filter. 

...

1. Click once on the heading field you want to sort by.
   An up arrow is displayed on the field by which the grid is sorted.
    

Descending order

To sort into descending order (Z to A or 10 to 1),

1. Click twice on the heading field you want to sort by.
   A down arrow is displayed on the field by which the grid is sorted.
     

Pivoting grids

You can launch the Grid Record Pivot View window to switch between individual grid area records.

To pivot a grid:

1. Right click on the grid you want to pivot.
2. Select Pivot Grid.
    
   The Grid Record Pivot View window is displayed.
   AnchorO_45780O_45780 

Grid Record Pivot View key fields and buttons
Fields

Buttons

O_45782

O_45783

Button	Description
Anchor
O_45784	O_45784	Display the first grid area record. anchor
	O_45785	O_45785	Display the previous grid area record.
Anchor
O_45781	O_45781	Display the next grid area record.
Anchor
	O_45782	Display the last grid area record.
Anchor
O_45783
	Refresh all grid area records.

...