Skip to content

Search, filter and save grid views

Most lists in Nexsyis, such as the Vehicle Center tabs, Folder Tracking and Cycle Time, are grids. You can search, filter and group any grid, choose its columns, and save the layout so it’s the same next time.

Most grid options are on the right-click menu. Right-click a column header for column, search and filter options, or the body of the grid to save your layout.

Use the Find Panel to search every column at once.

  1. Open the Find Panel in one of these ways:
    • Select the search (magnifying glass) icon at the far right of the grid.

      The search icon at the far right of an In Process grid

    • Right-click a column header and select Show Find Panel.

    • Press Ctrl+F.

  2. Type a keyword in Enter text to search…. The grid shows only the matching records.
  3. To start again, select Clear.

The Find Panel above the grid, with the search box and the Find and Clear buttons

  1. Right-click a column header and select Show Auto Filter Row.

    Show Auto Filter Row on the column header right-click menu

  2. A blank row appears at the top of the grid. Type in the cell under the column you want to search.

    The auto filter row with dodge typed under the Vehicle column

  1. Point to a column header and select the filter icon that appears at its top right.
  2. Select the values you want to see, then select OK.

The filter list on the Insurance column, with two insurers selected

If the filter list doesn’t have the option you need, create a custom filter.

  1. Select the column’s filter icon, then select (Custom) at the top of the list.
  2. In the Custom AutoFilter window, choose an operator and enter a value. Add a second condition with And or Or if you need it.
  3. Select OK.

For example, to see folders with outstanding A/R older than 100 days, open the Vehicle Center Outstanding AR tab and set the Age column to Is greater than 100.

The Age column filter list with (Custom) at the top

The Custom AutoFilter window set to Age is greater than 100

To see only Chrysler and Dodge vehicles on the Cycle Time screen, set the Make column to Is like Chrysler Or Is like Dodge.

The Make column filter list on the Cycle Time screen

The Custom AutoFilter window set to Make is like Chrysler or Dodge

The Filter Editor lets you build filters on several columns, and use conditions the filter list doesn’t offer, such as finding blank values.

  1. Right-click a column header and select Filter Editor.

    Filter Editor on the column header right-click menu

  2. The Filter Editor opens with the column you right-clicked. Colored text can be changed:

    • Select the blue column name to choose a different column.
    • Select the green operator to choose the kind of filter, for example Equals or Is null.
    • Enter the value to filter by.

    The Filter Editor with two conditions and the OK, Cancel and Apply buttons

  3. Select Apply to check the result, then select OK.

For example, to find folders with no arrival date on the Folder Tracking screen, open the Filter Editor from the Arrival column and change Equals to Is null.

The Filter Editor operator list with Is null highlighted

Folder Tracking showing only folders with no Arrival date, with [Arrival] Is Null in the filter bar

  • To clear all filters, select the X at the left of the filter bar at the bottom of the grid.

    The X at the left of the filter bar at the bottom of the grid

  • To clear the filter on one column, right-click its header and select Clear Filter.

    Clear Filter on the column header right-click menu

  1. Drag a column header up and drop it in the Drag a column header here to group by that column box above the grid.

    The group-by box above the grid

  2. To ungroup, drag the column header back down to its place in the grid, or right-click and select Clear Grouping.

    A grid grouped by Insurance, with Clear Grouping on the right-click menu

  1. Right-click a column header and select Column Chooser.

    Column Chooser on the column header right-click menu

  2. In the Customization window, double-click the column you want to add.

    The Customization window listing columns you can add

Right-click the column header and select Hide This Column. You can also drag the header up off the grid until a black X appears.

Hide This Column on the column header right-click menu

  • To move a column, drag its header to a new position.
  • To size a column, drag the edge of its header. Or right-click the header and select Best Fit for that column, or Best Fit (all columns).

Best Fit and Best Fit (all columns) on the column header right-click menu

After you change columns, filters, sorting or grouping, right-click the body of the grid and select Save My Grid Layout. The grid opens the same way next time.

Save My Grid Layout on the grid right-click menu

On screens that have a View drop-down, you can save a layout as a named view and switch between views.

The View drop-down with the New View, Delete View and Reset View buttons

  • Add a view: set up the grid’s columns, filters, sorting and grouping. Select New View, type a name, then select OK.
  • Change a view: make your changes, select New View, leave the name as it is, then select OK.
  • Delete a view: select the view, then select Delete View.
  • Reset a view: select Reset View to undo the changes you saved with Save My Grid Layout and go back to the system default.

The View Name window with the System View checkbox

On the Vehicle Center In Process tab, a bold folder number has a sub-report. Select the + next to the folder number to open it.

An In Process row expanded to show the Repair Techs sub-report