· Three different validations are conducted in the welding database. The objective is to ensure the comprehensive integrity of all joint criteria.
1. Click on the button “Run validation” that is only in the general tab of the header of the welding db.
1.1 Invalid Records.
Invalid records are those containing at least one welding criteria that does not comply with the specified rules for them.
All records that have at
least one 
should
be listed in the Invalid Records table.
1.2 Duplicate Records
- We categorize criteria into two types: single value-based and range-based.
- Single value-based criteria apply to the properties of Special Joint Type, Surface Finish, Part Interface Orientation, Aperture Angle, Floor Angle, Pass Number and Total Pass Number.
- The second type is Range-based criteria, which involve Weld Leg Size, Wall Height, Floor Width, Joint Edge Radius, Wall Thickness, and Floor Thickness.
- Definition of DUPLICATE:
- Recipes are considered duplicates when:
- All single value-based criteria are identical.
- All range-based criteria overlap.
In the context of range-based criteria, overlap indicates the presence of a common region or at least one shared value between the two sets of values.
In the context of range-based criteria, overlap indicates the presence of a common region or at least one shared value between the two sets of values.
For example, if we have ranges [0,8] and [4,9], they overlap because 4 falls within the range of 0 and 8.
1.3 Identical References Ids
Identical reference IDs refer to at least two or more joint criteria sharing the same reference IDs.
2. Usage of the Validation window
The Validation window allows you to filter recipes based on their presence in each box.
However, there’s a restriction: you can filter only one box at a time. To achieve this, simply check the checkboxes next to the Reference Ids corresponding to the desired box. Keep in mind that the list within each box contains MIDDLE, START, and END recipes all together.
2.1 Filter Selected Records Behavior
2.1.1 When you choose at least one Reference Id from one box, the other two sections become unclickable. Additionally, their “Select/Deselect All” buttons are disabled. This limitation ensures that you can only filter by one type of validation issue at a time.
2.1.2 After selecting your Reference Id(s), clicking on “Filter Selected Records” will present you with a list of filtered records in the welding database. These records correspond to the chosen Reference Id(s).
2.1.3 To view the filtered results, pay attention to whether they fall into the categories of MIDDLE, START, or END. Additionally, you can find the Reference Ids you’ve selected displayed at the bottom of the DB Viewer. In picture below, those are the two Invalid records that were checked in the Validation Window.
2.1.4 You can conveniently choose or unselect all elements listed in one of the validation boxes using the “Select/Deselect All” feature. This streamlines your selection process.
2.1.5 In the Duplicate Records section, each recipe with at least one duplicate is grouped by reference ID. When you encounter a label like “ReferenceID and X other(s),” it signifies that the specified reference ID has X number of duplicates associated with it. If you select these duplicates and click on “Filter,” you’ll be able to view the reference ID along with the X elements it is duplicated with.
2.2 OK Button Behavior:
· When you click the “OK” button in the validation window, it immediately takes you back to the welding database without applying any joint criteria filtering. This occurs even if you’ve selected specific validations.
· To view filtered results, you’ll need to click on the “Filter Selected Records” option.
2.3 Clear Filter Button:
· The “Clear Filter” button allows you to remove all filters and return to the initial state.
· It’s accessible from any tab within the application.
· This button works for all types of filters activated in the application.
3. Usage of the Save Window
The “Save” button serves a dual purpose: it not only displays all three types of validation errors currently in the database but also allows you to save any changes made, even if there are duplicates or errors present. You can always revisit the “Run Validation” button to review and address any issues before finalizing the save.
