# Search Criteria in Tab

This section describes 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 that lists a 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. It reduces the number of search results. Choose a predefined date range, or create a custom date range by using the Custom range feature. | Select Apply to add date range.
Max results | The number of results to be shown in the list. | Select from 6 options, ranging between 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. | Click to expand. Select a specific status from the list. Different options are listed and shown depending on the center. The default value might also differ. All OK OK (repaired) OK Loosening NOK NOK (Stopped) NOK Loosening NOK (RM) NYD Not completed Not used Aborted Canceled Filtered loosening Free running Batch reset Batch bypass Batch decrement Batch increment Rehit MANUAL_OK MANUAL_NOK
Program1 | The Program selection box is used to define a specific program for a measurement. It reduces the number of search results. Choose an available program from the list, or enter the name of the program directly. | Select ALL or a program from the list or use the wildcard character % to perform a search.
Bolt1 | 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 set to All by default. When a user enters an input, the system searches for both identifiers. It first checks the Bolt Number (if the input is numeric, it attempts to match the Bolt Number) and then checks the Bolt Name (if the input is text, it attempts to match with the Bolt Name). To search by Bolt Name, you can use the wildcard character (%) to perform a search for Bolt name.
Identifier1 | The Identifier selection is a user defined way of keeping track of the different tightenings. For example, barcode or VIN in an assembly line. | Select an identifier type from the list. Enter multiple comma separated identifier strings in the text box.
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. A shift can be for a maximum of 24 hours and in Administration it is only possible to start a shift after the current 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. | By default, this field is set to All .
First record | The First record selection box is used to define the dates for a measurement. This reduces 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.
PIN2 | The product identification number. | Enter a product identification number.
VIN2 | The vehicle identification number. | Enter a vehicle identification number.
Sequence2 | 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 Name2 | The product part name. | Enter a part name.
Barcode2 | The product barcode. | Enter a barcode.
PR Family2 | The product family. | Enter a product family.
PR Name2 | 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.

1 You can use wildcards when you search for programs and identifiers.

- * : This replaces zero or more characters.

- _ : This replaces one character only.

  Example: When you enter 00_, you find all three-character identifiers that start with 00. The search does not make a difference between uppercase and lowercase characters.

2 The 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.

## Selection Limits and Processing Time

The system and its underlying SQL database enforce a 10-minute processing limit per query. If a selection takes longer than 10 minutes, the database terminates the operation and returns an error message.

Factors Affecting Processing Time

The time required to process a selection depends on:

- Size of the selection (number of results): A higher number of results increases query processing time.

- Number of programs relative to the amount of results: The proportion of programs included in the results affects the query duration.

- Applied filters and parameters: Additional filters or complex parameters use more system resources and can increase processing time.

The following example illustrates approximate report‑generation times using a test environment with the specifications below.

Test Server Specifications

- Processor: Intel® Xeon® Gold 5118 CPU @ 2.30 GHz (2 processors, running at 2.29 GHz)

- Memory: 8 GB RAM

- System Type: 64‑bit operating system, x64‑based processor

- Operating System: Windows Server 2019

Database Characteristics

- Database size: 4,474,935 MB

- Total results stored: 314,999,385

- Total programs: 21,414

Report Generation Performance
Date range | Approximate generation time | Results returned | Total results in the database at the time
--- | --- | --- | ---
3-year period | ~ 13mins | Up to 100,000 | 274,750,776
2-year period | ~16 seconds | Up to 100,000 | 104,702
1-year period | < 3 seconds | Up to 100,000 | 75

General Performance Notes

- Most report selections return results within approximately 10 minutes.

- If a selection is too large to process within this timeframe, the system automatically stops the operation and displays an error message.

- To improve performance, consider narrowing the date range or adding additional filters when working with very large datasets.

In most cases, users can expect results within 10 minutes. If the selection is too large to process within this timeframe, the system stops the operation and displays an error message.

Best Practices for Large Selections

To avoid long wait times and errors:

- Start with a small or medium-sized selection.

- Increase the size gradually if needed.

- Avoid starting with the maximum possible selection, as this can lead to delays and potential errors.

Following this approach reduces delays and enhances overall efficiency.