Filtering, searching and sorting functions are available on many of the listing pages within B2W Operational Suite and are also available when adding components to a field log. These functions help you manage long lists of employees, materials, accounts, etc., and can help you quickly locate resources you want to add to a field log. Sorting is the process of arranging records in either ascending or descending order. Searching is the action of using specific criteria in search field(s) to narrow your search results.

Filtering

Filtering refers to the process of showing only the records from a list that match a certain criteria. Select a column, then select a filter to show only the records you want to view. There are two types of filters found in the B2W Operational Suite: the alphabetic filter and the data filter.

Example: Alphabetic Filter

To find all of the Organizations in cities beginning with the letter P:

  1. Navigate to the Organizations Listing page in Resources and click the City column heading.
  2. Click the letter P in the alphabet filter. The list changes to display only Organizations with a City value beginning with the letter P.

Note: Your filter applies to the column that has the sort order applied. To select a column, click the column heading. The selected column displays a triangle to the right of its heading.

Example: Data Filter

To find a specific location of an inventory with the data filter:

  1. Click Filter to bring up the filter options.
  2. Choose how you want to filter the data.
  3. Type in the values to filter by.

    DataFilter

Searching

Searching also refers to the process of showing only the records from a list that match a certain criteria. Unlike filtering, however, searching returns results for any record that has a matching string of text within any visible column.

Example

To find any material with the text string "granite" in its description:

  1. Navigate to the Materials page in Resources, and type the word "granite" in the search field.
  2. Click Search. Only materials that include the word "granite" will display.
  3. To clear your search results, click Clear Search.

Note: You can search for full or partial words or strings; you can include numbers in search strings; and your search can include multiple words or strings.

Sorting

Sorting refers to the process of alphabetizing a list by a column of your choice. Click on any column heading to sort your list by the values in that column.

Example

To sort your employee list by Employee Last Name:

  1. Navigate to the Employee Listing page in Resources, and click the Last Name column heading.
  2. To sort in reverse-alphabetical order, click the Last Name heading again.