# Search Type 130: Time Span + Work Center + Work Order + Item/Operation/MIS

## Overview

Test scripts for Search Type 130, which combines Time Span, Work Center, Work Order, and Item/Operation/MIS (Part Operations) filters. This search type allows users to search for work order data within a specific date range, filtered by work center, work order number, and part operation details.

**Search Type ID:** 130

**Filters Enabled:**
- Timespan (Start Date, End Date)
- Work Center
- Work Order
- Item/Operation/MIS (Part Operations)

---

## Valid Test Data

### Timespan
- Valid date range in database: **1905-01-20** to **2020-09-01**
- Recent: `2020-01-01` to `2020-09-01`
- Mid-range: `2018-01-01` to `2019-12-31`
- Historical: `2016-01-01` to `2017-12-31`

### Work Centers
| Code |
|------|
| 0083AS |
| 0278AS |
| 0424AS |
| 0586AS |
| 0696AS |
| 1010AS |
| 1011AS |
| 10595CA |
| 11275CA |
| 11350CA |

### Work Orders
| WorkOrderNumber | ItemNumber |
|-----------------|------------|
| 99059700 | 00598004702 |
| 99002260 | 82070000028 |
| 99002259 | 82070000027 |
| 99002258 | 82070000019 |
| 99002257 | 82070000018 |
| 99002256 | 82070000017 |
| 99002255 | 00855140333 |
| 99002254 | 00855480834 |

### Item/Operation/MIS (Part Operations)
| ItemNumber | OperationNumber | MisNumber | MisRevision |
|------------|-----------------|-----------|-------------|
| 00-5952-012-01 | 505 | 26-1002-003-00 | 00 |
| 00-5952-012-02 | 505 | 26-1002-003-00 | 00 |
| 00-5952-013-01 | 505 | 26-1002-003-00 | 00 |
| 00-5952-013-02 | 505 | 26-1002-003-00 | 00 |
| 00-5952-014-01 | 505 | 26-1002-003-00 | 00 |
| 00-5952-014-02 | 505 | 26-1002-003-00 | 00 |

---

## Positive Test Cases

### TC-130-P01: Single Values for All Filters

**Preconditions:**
- User is logged in
- User has access to the Submit Search page

**Steps:**
1. Navigate to Submit Search page
2. Enter search name: "TC-130-P01 Single Values"
3. Select "Time Span + Work Center + Work Order + Item/Operation/MIS" search type
4. Set minimum date to `2018-01-01`
5. Set maximum date to `2020-09-01`
6. Add work center `1010AS`
7. Add work order `99002255`
8. Add part operation: Item `00-5952-014-01`, Operation `505`, MIS `26-1002-003-00`, Rev `00`
9. Submit search

**Expected Results:**
- Search is created with status "Queued"
- Search appears in search list with correct name
- All filter values are saved correctly
- Search processes successfully

---

### TC-130-P02: Multiple Work Centers

**Preconditions:**
- User is logged in
- User has access to the Submit Search page

**Steps:**
1. Navigate to Submit Search page
2. Enter search name: "TC-130-P02 Multiple Work Centers"
3. Select "Time Span + Work Center + Work Order + Item/Operation/MIS" search type
4. Set minimum date to `2019-01-01`
5. Set maximum date to `2020-09-01`
6. Add work center `0083AS`
7. Add work center `1010AS`
8. Add work center `1011AS`
9. Add work order `99002260`
10. Add part operation: Item `00-5952-012-01`, Operation `505`, MIS `26-1002-003-00`, Rev `00`
11. Submit search

**Expected Results:**
- Search is created with status "Queued"
- All three work centers are saved in the search criteria
- Search processes successfully

---

### TC-130-P03: Multiple Work Orders

**Preconditions:**
- User is logged in
- User has access to the Submit Search page

**Steps:**
1. Navigate to Submit Search page
2. Enter search name: "TC-130-P03 Multiple Work Orders"
3. Select "Time Span + Work Center + Work Order + Item/Operation/MIS" search type
4. Set minimum date to `2018-01-01`
5. Set maximum date to `2019-12-31`
6. Add work center `0424AS`
7. Add work order `99002255`
8. Add work order `99002256`
9. Add work order `99002257`
10. Add part operation: Item `00-5952-013-01`, Operation `505`, MIS `26-1002-003-00`, Rev `00`
11. Submit search

**Expected Results:**
- Search is created with status "Queued"
- All three work orders are saved in the search criteria
- Search processes successfully

---

### TC-130-P04: Multiple Part Operations

**Preconditions:**
- User is logged in
- User has access to the Submit Search page

**Steps:**
1. Navigate to Submit Search page
2. Enter search name: "TC-130-P04 Multiple Part Ops"
3. Select "Time Span + Work Center + Work Order + Item/Operation/MIS" search type
4. Set minimum date to `2018-01-01`
5. Set maximum date to `2020-09-01`
6. Add work center `0586AS`
7. Add work order `99002258`
8. Add part operation: Item `00-5952-012-01`, Operation `505`, MIS `26-1002-003-00`, Rev `00`
9. Add part operation: Item `00-5952-012-02`, Operation `505`, MIS `26-1002-003-00`, Rev `00`
10. Add part operation: Item `00-5952-013-01`, Operation `505`, MIS `26-1002-003-00`, Rev `00`
11. Submit search

**Expected Results:**
- Search is created with status "Queued"
- All three part operations are saved in the search criteria
- Search processes successfully

---

### TC-130-P05: All Filters with Multiple Values

**Preconditions:**
- User is logged in
- User has access to the Submit Search page

**Steps:**
1. Navigate to Submit Search page
2. Enter search name: "TC-130-P05 All Multiple Values"
3. Select "Time Span + Work Center + Work Order + Item/Operation/MIS" search type
4. Set minimum date to `2018-01-01`
5. Set maximum date to `2020-09-01`
6. Add work center `1010AS`
7. Add work center `11275CA`
8. Add work order `99002254`
9. Add work order `99002255`
10. Add part operation: Item `00-5952-014-01`, Operation `505`, MIS `26-1002-003-00`, Rev `00`
11. Add part operation: Item `00-5952-014-02`, Operation `505`, MIS `26-1002-003-00`, Rev `00`
12. Submit search

**Expected Results:**
- Search is created with status "Queued"
- All work centers, work orders, and part operations are saved correctly
- Search processes successfully

---

### TC-130-P06: Historical Date Range

**Preconditions:**
- User is logged in
- User has access to the Submit Search page

**Steps:**
1. Navigate to Submit Search page
2. Enter search name: "TC-130-P06 Historical Range"
3. Select "Time Span + Work Center + Work Order + Item/Operation/MIS" search type
4. Set minimum date to `2016-01-01`
5. Set maximum date to `2017-12-31`
6. Add work center `10595CA`
7. Add work order `99059700`
8. Add part operation: Item `00-5952-013-02`, Operation `505`, MIS `26-1002-003-00`, Rev `00`
9. Submit search

**Expected Results:**
- Search is created with status "Queued"
- Historical date range is accepted
- Search processes successfully (may return fewer or no results)

---

### TC-130-P07: Narrow Date Range (Same Month)

**Preconditions:**
- User is logged in
- User has access to the Submit Search page

**Steps:**
1. Navigate to Submit Search page
2. Enter search name: "TC-130-P07 Narrow Date Range"
3. Select "Time Span + Work Center + Work Order + Item/Operation/MIS" search type
4. Set minimum date to `2020-06-01`
5. Set maximum date to `2020-06-30`
6. Add work center `0696AS`
7. Add work order `99002259`
8. Add part operation: Item `00-5952-014-05`, Operation `505`, MIS `26-1002-003-00`, Rev `00`
9. Submit search

**Expected Results:**
- Search is created with status "Queued"
- Narrow date range is accepted
- Search processes successfully

---

## Negative Test Cases

### TC-130-N01: Missing Required Date Range

**Preconditions:**
- User is logged in
- User has access to the Submit Search page

**Steps:**
1. Navigate to Submit Search page
2. Enter search name: "TC-130-N01 No Dates"
3. Select "Time Span + Work Center + Work Order + Item/Operation/MIS" search type
4. Leave minimum date empty
5. Leave maximum date empty
6. Add work center `1010AS`
7. Add work order `99002255`
8. Add part operation: Item `00-5952-014-01`, Operation `505`, MIS `26-1002-003-00`, Rev `00`
9. Attempt to submit search

**Expected Results:**
- Validation error is displayed
- User is prompted to enter a valid date range
- Search is not created

---

### TC-130-N02: Missing Work Center

**Preconditions:**
- User is logged in
- User has access to the Submit Search page

**Steps:**
1. Navigate to Submit Search page
2. Enter search name: "TC-130-N02 No Work Center"
3. Select "Time Span + Work Center + Work Order + Item/Operation/MIS" search type
4. Set minimum date to `2018-01-01`
5. Set maximum date to `2020-09-01`
6. Do not add any work center
7. Add work order `99002255`
8. Add part operation: Item `00-5952-014-01`, Operation `505`, MIS `26-1002-003-00`, Rev `00`
9. Attempt to submit search

**Expected Results:**
- Validation error is displayed
- User is prompted to add at least one work center
- Search is not created

---

### TC-130-N03: Missing Work Order

**Preconditions:**
- User is logged in
- User has access to the Submit Search page

**Steps:**
1. Navigate to Submit Search page
2. Enter search name: "TC-130-N03 No Work Order"
3. Select "Time Span + Work Center + Work Order + Item/Operation/MIS" search type
4. Set minimum date to `2018-01-01`
5. Set maximum date to `2020-09-01`
6. Add work center `1010AS`
7. Do not add any work order
8. Add part operation: Item `00-5952-014-01`, Operation `505`, MIS `26-1002-003-00`, Rev `00`
9. Attempt to submit search

**Expected Results:**
- Validation error is displayed
- User is prompted to add at least one work order
- Search is not created

---

### TC-130-N04: Missing Part Operation

**Preconditions:**
- User is logged in
- User has access to the Submit Search page

**Steps:**
1. Navigate to Submit Search page
2. Enter search name: "TC-130-N04 No Part Op"
3. Select "Time Span + Work Center + Work Order + Item/Operation/MIS" search type
4. Set minimum date to `2018-01-01`
5. Set maximum date to `2020-09-01`
6. Add work center `1010AS`
7. Add work order `99002255`
8. Do not add any part operation
9. Attempt to submit search

**Expected Results:**
- Validation error is displayed
- User is prompted to add at least one part operation
- Search is not created

---

### TC-130-N05: Start Date After End Date

**Preconditions:**
- User is logged in
- User has access to the Submit Search page

**Steps:**
1. Navigate to Submit Search page
2. Enter search name: "TC-130-N05 Invalid Date Range"
3. Select "Time Span + Work Center + Work Order + Item/Operation/MIS" search type
4. Set minimum date to `2020-09-01`
5. Set maximum date to `2018-01-01`
6. Add work center `1010AS`
7. Add work order `99002255`
8. Add part operation: Item `00-5952-014-01`, Operation `505`, MIS `26-1002-003-00`, Rev `00`
9. Attempt to submit search

**Expected Results:**
- Validation error is displayed
- User is prompted that start date must be before end date
- Search is not created

---

### TC-130-N06: Empty Work Center Value

**Preconditions:**
- User is logged in
- User has access to the Submit Search page

**Steps:**
1. Navigate to Submit Search page
2. Enter search name: "TC-130-N06 Empty Work Center"
3. Select "Time Span + Work Center + Work Order + Item/Operation/MIS" search type
4. Set minimum date to `2018-01-01`
5. Set maximum date to `2020-09-01`
6. Attempt to add an empty string as work center
7. Add work order `99002255`
8. Add part operation: Item `00-5952-014-01`, Operation `505`, MIS `26-1002-003-00`, Rev `00`
9. Attempt to submit search

**Expected Results:**
- Empty work center value is rejected
- Validation error is displayed
- Search is not created

---

### TC-130-N07: Missing Search Name

**Preconditions:**
- User is logged in
- User has access to the Submit Search page

**Steps:**
1. Navigate to Submit Search page
2. Leave search name empty
3. Select "Time Span + Work Center + Work Order + Item/Operation/MIS" search type
4. Set minimum date to `2018-01-01`
5. Set maximum date to `2020-09-01`
6. Add work center `1010AS`
7. Add work order `99002255`
8. Add part operation: Item `00-5952-014-01`, Operation `505`, MIS `26-1002-003-00`, Rev `00`
9. Attempt to submit search

**Expected Results:**
- Validation error is displayed
- User is prompted to enter a search name
- Search is not created

---

### TC-130-N08: Incomplete Part Operation (Missing Operation Number)

**Preconditions:**
- User is logged in
- User has access to the Submit Search page

**Steps:**
1. Navigate to Submit Search page
2. Enter search name: "TC-130-N08 Incomplete Part Op"
3. Select "Time Span + Work Center + Work Order + Item/Operation/MIS" search type
4. Set minimum date to `2018-01-01`
5. Set maximum date to `2020-09-01`
6. Add work center `1010AS`
7. Add work order `99002255`
8. Attempt to add part operation with only Item `00-5952-014-01` (missing operation, MIS, revision)
9. Attempt to submit search

**Expected Results:**
- Validation error is displayed
- User is prompted to complete all part operation fields
- Search is not created

---

## Notes

- Work center codes vary in format (e.g., `0083AS`, `10595CA`, `1700CB`)
- Part operations require all four fields: Item Number, Operation Number, MIS Number, and MIS Revision
- Data extracted from `WorkOrderStep_Hist` and `MisData_Hist` tables
- Work orders from `WorkOrder_Hist` table (1,742,847 records)