Search Criteria in Tab

How to work with the different search criteria that appear in the search panel.

The search panel is available for centers within the Reports, Statistics and the Analysis tab. The search will generate data from the ToolsNet database. There is a standard search panel in the upper section. An advance search section can be available in some tabs and centers. It is accessed by selecting the Run advanced report toggle.

The types of search criteria that can be selected will differ between the tabs and centers.

List of Search Criteria

Search Criteria

Description

Working with the Criteria

Tool structure

Tree folder listing specific Tool, Controller Group, Specific Controller or Virtual Station.

Select All or open up folder structure and select a specific product.

Date range

Preset date ranges or calendar to select from.

The Date Range selection box is used to define the dates for a measurement and therefore reduce the number of search results. Choose either a predefined date range, or create a custom date range using the Custom range feature.

Select Apply to add date range.

Max results

The amount of results to be shown in the result list.

There are 6 options, ranging from 50 to 5000.

Status

The Status selection is used to narrow down the search to a specific result. The number of selections varies depending on the application. Choose one of the status options that you wish to save.

Select to expand and select a specific status from the list.

Different options are listed and shown depending on the center. The default status might also differ.

  • All

  • OK

  • OK (repaired)

  • OK Loosening

  • NOK

  • NOK (Stopped)

  • NOK Loosening

  • NOK (RM)

  • NYD

  • Not completed

  • Not used

  • Aborted

  • Cancelled

  • Filtered loosening

  • Free running

  • Batch reset

  • Batch bypass

  • Batch decrement

  • Batch increment

  • Rehit

  • MANUAL_OK

  • MANUAL_NOK

Program

The Program selection box is used to define a specific program for a measurement and therefore reduce the number of search results. Choose one of the available Programs from the list, or enter the Program name directly.

Select ALL or a program from the list.

Bolt

The Bolt selection is used to narrow down the search to a specific bolt within a mass tightening pattern. In the Bolt item list, select the specific bolt within the tightening, for example, number 3, for the third bolt within the mass tightening.

This field is by default set to All .

Identifier

The first Identifier selection is a user defined way of keeping track of the different tightenings, for example, bar-codes or VIN in an assembly line.

Enter an identifier or select from the list.

Identifier (grey)

The second Identifier selection is used for search combinations by using two identifiers.

Enter an identifier or select from the list.

Shift

It is possible to connect results to a certain shift as they are reported from the controller, by tagging new results with the shift.

One shift can be a maximum of 24 hours and in Administration it is only possible to start a shift after today's date.

Shifts can be managed in Administration. It is possible to connect results to a certain shift as they are reported from the controller, by tagging new results with the shift. In Reports, shift has been added as a criteria in Result, Result Summary and Top NOK reports. One shift can be a maximum of 24 hours and in Administration it is only possible to start a shift after today's date.

Value type

The Value Type is used to filter the search to a specific angle or torque selection.

Select a value type from the list. When using Value Type, always set a Min Value and the Max Value

Min value

The Min Value selection box is used to narrow down the search to a specific step within a job sequence.

Enter the value in the field or select arrows to go up or down.

Max value

The Max Value selection box is used to narrow down the search to a specific step within a job sequence.

Enter the value in the field or select arrows to go up or down.

Job

The Job selection is used to narrow down the search to a specific Job.

Enter a job name or select a job from the list.

Steps

The Steps selection box is used to narrow down the search to a specific multistep tightening.

This field is by default set to All .

First record

The First record selection box is used to define the dates for a measurement and therefore reduce the number of search results. Choose either a predefined date range, or create a custom date range using the Custom range feature.

Select to expand preset date and select Apply or create Custom range dates and times and select Apply.

Location

Tree folder listing specific stations available.

Select to expand to filter the search to a specific location within the Location structure.

PIN1

The product identification number.

Enter a product identification number.

VIN1

The vehicle identification number.

Enter a vehicle identification number.

Sequence1

The order a tool is used.

Enter a sequence number of the product.

Model

Models put together.

Select to expand and either enter specific model in box, select a specific model available from the list or select All.

Result records

The history of the assembly process.

Select to expand and select the result record from list:

All - displays all results of the complete history of the assembly process.

First - only displays the initial status of the assembly process e.g. initial status of tightening attempts. Once set, the report will only show the initial existing result of an assembly process (tightening, manual confirmation, and barcode).

The NYD status will be shown for the respective process to best understand the expected process.

Last - displays the final status of the individual assembly process e.g. the final status of all tightening attempts, and not all steps in between. Once set, the report will only show the final existing result of an assembly process (tightening, manual confirmation, and barcode).

If no result has been received yet, then the NYD status will be displayed for the respective assembly process.

First Attempt - displays the first attempt of an assembly process, the first result that is not an NYD.

First Time Right - displays all assembly process that were not OK on the first attempt.

Event level

The Event Level selection box is used to narrow down the search to a specific type of event. The selectable events are: All, Info, Warning or Error. To specify the Event Level search, use Event Code in combination with a specific level.

Select one option: All, Info , Warning or Error.

Event code

The Event Code selection box is used in combination with a specific event level to narrow down the search.

Select numerical number manually or by using the arrows.

Joint group

The mass tightening fixtures

Enter a joint group. Handling results will be shown in the second level (Number, Description).

Joint

The tightening of the bolt.

Enter a specific joint. Handling results will be shown in the second level (Number, Description).

Part Name1

The product part name.

Enter a part name.

Barcode1

The product barcode.

Enter a barcode.

PR Family1

The product family.

Enter a product family.

PR Name1

The product name.

Enter a product name.

Program name

The Program Name selection box is used to define a specific program for a measurement and therefore reduce the number of search results.

Enter a program name or select a program from the list.

Group size

All results can be grouped according to a selectable size, called Group size. The Group Size selection is used to specify the number of results (statistics samples) used for a calculation. Statistics population example using Group Size 7: The first dot in the graph series will be the average of the first 7 results and the next dot is the average of the next 7 results.

Select one of values from the list.

Max results

The Max results selection box is used to narrow down the search to a max results per criteria.

Select one of values from the list. There are 6 options, ranging from 50 to 5000.

Max results per criteria

The Max results per criteria selection box is used to narrow down the search to a max results per criteria.

Select one of values from the list.

1The free text search boxes allows for the usage of the wildcard character asterisk (*) at the start, middle or end. For example, entering "Name*", returns all entries that start with "Name". Entering "*Name", returns all entries that end with "Name". Up to 25 characters can be used within the search box field.