Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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. Right click on the grid you want to filter.
  2. Select Enable Grid Enhancements.

...

  1.  Image Added

    Filters are enabled. A small arrow is displayed in each grid header.

...

  1.  Image Added 

Filtering grids
To filter a grid column:

  1. Click the arrow on the right of the header of the column you want to filter.

...

  1.  Image Added
  2. Select the filter you want to use.

...

  1.  Image Added
  2. Type the target to which you want to filter.

...

  1. Click AnchorO_34401O_34401 Image Removed Image Added
  2. Click Image Added.
    The grid is restricted to items that match your filter. 

Sorting grids
You can sort most grids into ascending or descending order by clicking on the heading fields.
AnchorO_23783O_23783 Image Removed
 Image Added

Ascending order

To sort into ascending order (A to Z or 1 to 10):

  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.

...

  1.  Image Added

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.

...

  1.  Image Added 

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.

...

  1.  Image Added
    The Grid Record Pivot View window is displayed.

...

  1. Image Added 

Grid Record Pivot View key fields and buttons
Fields

Field

Description

Column

Name of the grid area column.

Value

Value entered in the column for the selected grid area record.

Buttons

O_45784 Image Removed

Button

Description

AnchorO_45784

Image Added

Display the first grid area record.

AnchorO_45785O_45785 Image Removed

Image Added

Display the previous grid area record.

AnchorO_45781O_45781 Image Removed

Image Added

Display the next grid area record.

AnchorO_45782O_45782 Image Removed

Image Added

Display the last grid area record.

AnchorO_45783O_45783 Image Removed

Image Added

Refresh all grid area records.