Datagrid features

Apply layouts and filters to a data grid of results.

Only a single layout at a time can be applied to the data grid using the Layout toolbar option that appears above the data grid. Click Manage Custom Layouts for details on customizing data grid layouts.

When filters are applied to a column, a label titled Column Filters appears in the pane just below the data grid toolbar yet above the data grid. Click the words Column Filters to display the filters applied so that they can be individually removed by clicking the X to the right of each filter (as depicted below). Or click the X to the right of the Column Filters label to remove all filters applied to all columns throughout the data grid.

Arrows pointing up or down appear to the right of the column header label when sorting is applied to a column. The type of sort applied (ascending or descending) is indicated by which of the arrows is colored blue.

When multiple columns are sorted in a data grid, a number indicating the sort order appears to the right of each column header name. For example, indicates that the Matched Part Number column is sorted from 1 to 9... and that it is the second sort criteria applied to the data grid.

Filters that appear in the pop up when you click the Column Filters text in the label follow the format Column Name | Filter Operator: Value, where Column Name is the name that appears in the column header of the filtered column, Operator Type is the comparator (Contains, Starts With etc.), and Value is the specific value being filtered. Where ascending or descending sorting is applied, that is also indicated in the pop up by an arrow (↓↑).

The layouts and filters options can be applied to numerous results grids throughout BOM Intelligence, including datagrids displaying results for alerts, reports, searches, tabs in the View Single BOM page, and windows such as View all BOMs, BOM Tree Parts, View all Reports, and more.

Pagination consists of controls for viewing the data set: view current, next, and previous data subsets (in groups of 25, 50, 100, 250 or 500 at a time), go to the beginning, or go to the end of the whole data set, view a specific numbered item in the data set, and view the number of items currently shown. There is also the option to select All as the number of items to display. Each time you scroll down to the bottom of the current display, a new batch of results is loaded while you continue to scroll. For higher-end computers, the batch loading transition is seamless.

Hover over a column title to view additional text.

Select individual rows () upon which to complete operations. Row selection highlights the entire row.

Rows remain selected when you navigate between pages and change the formatting, such as the number of rows displayed in the present page.

• Type a keyword, lookup search, or select a pre-defined value to filter the data in a column that appears in a data grid by clicking the hamburger (), and then filter ().
  A blue funnel () appears in the column header to indicate that filtering is applied to values in that column. Different filtering types are available depending on the type of data in the column.

Pre-defined Terms. Only terms that appear in the column are available.	Lookup (Type Ahead) Search. As you type, related terms that appear in the BOM Intelligence database appear.	Freeform Search. Contains, Starts With, and Exact can be selected as the operand type from the drop-down list above the box where you type the filter term.

Column filters are automatically cleared when you navigate away from the current window to another so that the "No results found" message does not appear when a value specific to the current data grid is not found in the new data grid.

• Remove filters using one of the following methods:

• Click the Column Filters button in the pane above the data grid, and then click the name of specific column with a filter to remove.
  
• Click Clear Filter in the Filter drop-down list (where applicable).
  
• Click Clear All Tags in the right portion of the banner.
  

• Sort column data in either ascending or descending order, alphabetically or numerically, depending on the data within the column.

Arrows pointing up or down appear to the right of the column header label when sorting is applied to a column. The type of sort applied (ascending or descending) is indicated by which of the arrows is colored blue.

When multiple columns are sorted in a data grid, a number indicating the sort order appears to the right of each column header name. For example, indicates that the Matched Part Number column is sorted from 1 to 9... and that it is the second sort criteria applied to the data grid.

Filters that appear in the pop up when you click the Column Filters text in the label follow the format Column Name | Filter Operator: Value, where Column Name is the name that appears in the column header of the filtered column, Operator Type is the comparator (Contains, Starts With etc.), and Value is the specific value being filtered. Where ascending or descending sorting is applied, that is also indicated in the pop up by an arrow (↓↑).

To sort a column, in the column header click the hamburger (), and then click in the pop up window that appears to display the options in that tab.

Click either Sort Ascending or Sort Descending.

Expand or collapse several adjacent columns of data to reduce horizontal scrolling in the data grid. This functionality appears in the Alternates for Part... modal window, and the Parametric Search Results data grid.

In both the Alternates for Part... modal window, and the Parametric Search Results data grid, the Extended, Life Cycle, Compliance, Key Technical Attributes, and Additional Technical Attributes columnar sections can be collapsed or expanded by clicking - or + (respectively) in the grouped column header.
The Parametric Search Results data grid also supports collapsing and expanding the Supply Chain, LifeCycle, and Compliance sections when the Add Risk Attributes layout is applied.

• Click Hide this Column to hide a column.
  
• To unhide columns, using the drop-down list above the data grid, click either Unhide followed by the name of the column to reveal, or Unhide > Unhide All.
  

• data grid columns can be resized by clicking on a column separator and dragging it to the desired width (), to display more or less of the data grid content. The > Autosize This Column can also be used. The Autosize All Columns only resizes the columns currently visible in your screen.