Filter Data in a Data Grid

Important: Any changes you make to the display of a data grid are saved automatically and locally on your machine. When you next open that view, LandTracker displays the data grid as you last viewed it. You can also save customised views with new names, and if you are an editor or administrator, you can share a custom view with other users. See Manage Custom Views.

In addition to the filtering that may apply in Views, there are multiple ways to filter a data grid. You can apply as many different filters as required.

Activity Steps

  1. Right-click the column header and select Filter For from the menu.

    The Filter Column screen displays a list of all values in the column.

  2. Select the Type to specify how filtering and sorting should apply. Select from Area, Date, Money, Number and String (that is, text).

    Note: If a column has multiple data types, filtering and sorting may not work as expected.

  3. Specify a Filter if required. For example:
    • M*: Return any records starting with M.
    • >10: Return any records greater than 10. Applicable for Date and Number data types.

    • <>gold: Return records whose text does not contain gold. The <> operator is treated as a wildcard negation and produces a NOT LIKE filter.

    • NOT LIKE '%gold%': Return records whose text does not contain gold.

    • Between 1/1/2023 And 1/1/2024: Return any records within a date range.
  4. To control the filtering by individual values, check or uncheck values in the list as required.
  5. Click Apply Filter.

Note: Text filters use wildcard matching. A wildcard at the end, such as Gold*, matches text that starts with Gold. A wildcard at the beginning, such as *old, matches text that ends with old. A wildcard at both ends, such as *old*, matches text that contains old.

Note: Use simple start and end wildcards. Wildcards in the middle of a pattern and complex internal wildcard patterns are not supported by all data-grid filtering operations.

Activity Steps

  1. Right-click a cell and select Filter By Selection from the menu.

Activity Steps

  1. Right-click a cell and select Filter Excluding Selection from the menu.

Activity Steps

  1. To clear filtering from a single column, right-click the column header and select Remove Filter from the menu.
  2. To clear all filtering, right-click the data grid settings icon and select Clear Filters from the menu.

Activity Steps

  1. Right-click the view name or the data grid settings icon and select Reset View from the menu.