Joseph Doherty
04383d672c
Replace InputFile with RadzenUpload in filter panels for better UX, switch to ephemeral RSA keys (safe for transport-only encryption), and add test scripts and documentation files.
401 lines
11 KiB
Markdown
401 lines
11 KiB
Markdown
# Search Type 110: Time Span + Work Center + Extract MIS
|
|
|
|
## Overview
|
|
|
|
Search Type 110 allows users to search by a date range combined with work center(s) and the Extract MIS boolean flag. When Extract MIS is enabled, the search extracts MIS (Manufacturing Information System) data associated with work orders processed through the specified work center(s) within the given time range.
|
|
|
|
### Filters Enabled
|
|
|
|
| Filter | Description | Required |
|
|
|--------|-------------|----------|
|
|
| Timespan | Date range (Min Date to Max Date) | Yes |
|
|
| Work Center | One or more work center codes | Yes |
|
|
| Extract MIS | Boolean flag to extract MIS data | Yes |
|
|
|
|
---
|
|
|
|
## Valid Test Data
|
|
|
|
### Timespan
|
|
|
|
Valid date range in database: **1905-01-20** to **2020-09-01**
|
|
|
|
Recommended test ranges:
|
|
- 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 |
|
|
| 11355CA |
|
|
| 13316CA |
|
|
| 14305CA |
|
|
| 15660CA |
|
|
| 1700CB |
|
|
| 200038CA |
|
|
| 200039 |
|
|
| 200039CA |
|
|
| 200041CA |
|
|
| 200042CA |
|
|
|
|
### Extract MIS Values
|
|
|
|
| Value | Description |
|
|
|-------|-------------|
|
|
| true | Extract MIS data for matching work orders |
|
|
| false | Do not extract MIS data |
|
|
|
|
---
|
|
|
|
## Positive Test Cases
|
|
|
|
### TC-110-P01: Single Work Center with Extract MIS Enabled
|
|
|
|
**Preconditions:**
|
|
- User is logged in
|
|
- User has access to the Submit Search page
|
|
|
|
**Steps:**
|
|
1. Navigate to Submit Search page
|
|
2. Enter search name: "Test 110-P01 Single WC Extract MIS"
|
|
3. Select "Time Span + Work Center + Extract MIS" search type (Type 110)
|
|
4. Set minimum date to `2018-01-01`
|
|
5. Set maximum date to `2020-09-01`
|
|
6. Add work center `11275CA`
|
|
7. Enable Extract MIS checkbox (set to true)
|
|
8. Click Submit button
|
|
|
|
**Expected Results:**
|
|
- Search is created with status "Queued"
|
|
- Search appears in the user's search list
|
|
- Search criteria shows: Date range 2018-01-01 to 2020-09-01, Work Center: 11275CA, Extract MIS: true
|
|
|
|
---
|
|
|
|
### TC-110-P02: Multiple Work Centers with Extract MIS Enabled
|
|
|
|
**Preconditions:**
|
|
- User is logged in
|
|
- User has access to the Submit Search page
|
|
|
|
**Steps:**
|
|
1. Navigate to Submit Search page
|
|
2. Enter search name: "Test 110-P02 Multi WC Extract MIS"
|
|
3. Select "Time Span + Work Center + Extract MIS" search type (Type 110)
|
|
4. Set minimum date to `2019-01-01`
|
|
5. Set maximum date to `2020-09-01`
|
|
6. Add work center `10595CA`
|
|
7. Add work center `11275CA`
|
|
8. Add work center `11350CA`
|
|
9. Enable Extract MIS checkbox (set to true)
|
|
10. Click Submit button
|
|
|
|
**Expected Results:**
|
|
- Search is created with status "Queued"
|
|
- Search appears in the user's search list
|
|
- Search criteria shows all three work centers and Extract MIS: true
|
|
|
|
---
|
|
|
|
### TC-110-P03: Single Work Center with Extract MIS Disabled
|
|
|
|
**Preconditions:**
|
|
- User is logged in
|
|
- User has access to the Submit Search page
|
|
|
|
**Steps:**
|
|
1. Navigate to Submit Search page
|
|
2. Enter search name: "Test 110-P03 Single WC No Extract MIS"
|
|
3. Select "Time Span + Work Center + Extract MIS" search type (Type 110)
|
|
4. Set minimum date to `2018-01-01`
|
|
5. Set maximum date to `2019-12-31`
|
|
6. Add work center `0083AS`
|
|
7. Disable Extract MIS checkbox (set to false)
|
|
8. Click Submit button
|
|
|
|
**Expected Results:**
|
|
- Search is created with status "Queued"
|
|
- Search appears in the user's search list
|
|
- Search criteria shows: Date range 2018-01-01 to 2019-12-31, Work Center: 0083AS, Extract MIS: false
|
|
|
|
---
|
|
|
|
### TC-110-P04: Historical Date Range with 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: "Test 110-P04 Historical Multi WC"
|
|
3. Select "Time Span + Work Center + Extract MIS" search type (Type 110)
|
|
4. Set minimum date to `2016-01-01`
|
|
5. Set maximum date to `2017-12-31`
|
|
6. Add work center `1010AS`
|
|
7. Add work center `1011AS`
|
|
8. Enable Extract MIS checkbox (set to true)
|
|
9. Click Submit button
|
|
|
|
**Expected Results:**
|
|
- Search is created with status "Queued"
|
|
- Search criteria reflects the historical date range and both work centers
|
|
|
|
---
|
|
|
|
### TC-110-P05: Work Center Code Variants with Extract MIS
|
|
|
|
**Preconditions:**
|
|
- User is logged in
|
|
- User has access to the Submit Search page
|
|
|
|
**Steps:**
|
|
1. Navigate to Submit Search page
|
|
2. Enter search name: "Test 110-P05 WC Code Variants"
|
|
3. Select "Time Span + Work Center + Extract MIS" search type (Type 110)
|
|
4. Set minimum date to `2018-01-01`
|
|
5. Set maximum date to `2020-09-01`
|
|
6. Add work center `0696AS` (AS suffix)
|
|
7. Add work center `13316CA` (CA suffix)
|
|
8. Add work center `1700CB` (CB suffix)
|
|
9. Enable Extract MIS checkbox (set to true)
|
|
10. Click Submit button
|
|
|
|
**Expected Results:**
|
|
- Search is created with status "Queued"
|
|
- All work center code formats are accepted
|
|
|
|
---
|
|
|
|
### TC-110-P06: Toggle Extract MIS (True then False)
|
|
|
|
**Preconditions:**
|
|
- User is logged in
|
|
- User has access to the Submit Search page
|
|
|
|
**Steps:**
|
|
1. Navigate to Submit Search page
|
|
2. Enter search name: "Test 110-P06 Toggle Extract MIS True"
|
|
3. Select "Time Span + Work Center + Extract MIS" search type (Type 110)
|
|
4. Set minimum date to `2019-01-01`
|
|
5. Set maximum date to `2019-12-31`
|
|
6. Add work center `14305CA`
|
|
7. Enable Extract MIS checkbox (set to true)
|
|
8. Click Submit button
|
|
9. Verify search is created
|
|
10. Create another search with name: "Test 110-P06 Toggle Extract MIS False"
|
|
11. Use same date range and work center
|
|
12. Disable Extract MIS checkbox (set to false)
|
|
13. Click Submit button
|
|
|
|
**Expected Results:**
|
|
- Both searches are created with status "Queued"
|
|
- First search shows Extract MIS: true
|
|
- Second search shows Extract MIS: false
|
|
|
|
---
|
|
|
|
### TC-110-P07: Large Work Center Selection
|
|
|
|
**Preconditions:**
|
|
- User is logged in
|
|
- User has access to the Submit Search page
|
|
|
|
**Steps:**
|
|
1. Navigate to Submit Search page
|
|
2. Enter search name: "Test 110-P07 Many Work Centers"
|
|
3. Select "Time Span + Work Center + Extract MIS" search type (Type 110)
|
|
4. Set minimum date to `2018-01-01`
|
|
5. Set maximum date to `2020-09-01`
|
|
6. Add work centers: 0083AS, 0278AS, 0424AS, 0586AS, 0696AS, 1010AS
|
|
7. Enable Extract MIS checkbox (set to true)
|
|
8. Click Submit button
|
|
|
|
**Expected Results:**
|
|
- Search is created with status "Queued"
|
|
- All six work centers are included in search criteria
|
|
|
|
---
|
|
|
|
## Negative Test Cases
|
|
|
|
### TC-110-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: "Test 110-N01 Missing Dates"
|
|
3. Select "Time Span + Work Center + Extract MIS" search type (Type 110)
|
|
4. Leave minimum date empty
|
|
5. Leave maximum date empty
|
|
6. Add work center `11275CA`
|
|
7. Enable Extract MIS checkbox
|
|
8. Attempt to click Submit button
|
|
|
|
**Expected Results:**
|
|
- Submit button is disabled OR validation error is displayed
|
|
- Error message indicates date range is required
|
|
- Search is NOT created
|
|
|
|
---
|
|
|
|
### TC-110-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: "Test 110-N02 Missing Work Center"
|
|
3. Select "Time Span + Work Center + Extract MIS" search type (Type 110)
|
|
4. Set minimum date to `2018-01-01`
|
|
5. Set maximum date to `2020-09-01`
|
|
6. Do NOT add any work center (leave empty)
|
|
7. Enable Extract MIS checkbox
|
|
8. Attempt to click Submit button
|
|
|
|
**Expected Results:**
|
|
- Submit button is disabled OR validation error is displayed
|
|
- Error message indicates at least one work center is required
|
|
- Search is NOT created
|
|
|
|
---
|
|
|
|
### TC-110-N03: Invalid Date Range (End Before Start)
|
|
|
|
**Preconditions:**
|
|
- User is logged in
|
|
- User has access to the Submit Search page
|
|
|
|
**Steps:**
|
|
1. Navigate to Submit Search page
|
|
2. Enter search name: "Test 110-N03 Invalid Date Range"
|
|
3. Select "Time Span + Work Center + Extract MIS" search type (Type 110)
|
|
4. Set minimum date to `2020-09-01`
|
|
5. Set maximum date to `2018-01-01` (before minimum date)
|
|
6. Add work center `11275CA`
|
|
7. Enable Extract MIS checkbox
|
|
8. Attempt to click Submit button
|
|
|
|
**Expected Results:**
|
|
- Validation error is displayed
|
|
- Error message indicates maximum date must be after minimum date
|
|
- Search is NOT created
|
|
|
|
---
|
|
|
|
### TC-110-N04: Missing Minimum Date Only
|
|
|
|
**Preconditions:**
|
|
- User is logged in
|
|
- User has access to the Submit Search page
|
|
|
|
**Steps:**
|
|
1. Navigate to Submit Search page
|
|
2. Enter search name: "Test 110-N04 Missing Min Date"
|
|
3. Select "Time Span + Work Center + Extract MIS" search type (Type 110)
|
|
4. Leave minimum date empty
|
|
5. Set maximum date to `2020-09-01`
|
|
6. Add work center `0083AS`
|
|
7. Enable Extract MIS checkbox
|
|
8. Attempt to click Submit button
|
|
|
|
**Expected Results:**
|
|
- Validation error is displayed
|
|
- Error message indicates minimum date is required
|
|
- Search is NOT created
|
|
|
|
---
|
|
|
|
### TC-110-N05: Missing Maximum Date Only
|
|
|
|
**Preconditions:**
|
|
- User is logged in
|
|
- User has access to the Submit Search page
|
|
|
|
**Steps:**
|
|
1. Navigate to Submit Search page
|
|
2. Enter search name: "Test 110-N05 Missing Max Date"
|
|
3. Select "Time Span + Work Center + Extract MIS" search type (Type 110)
|
|
4. Set minimum date to `2018-01-01`
|
|
5. Leave maximum date empty
|
|
6. Add work center `10595CA`
|
|
7. Enable Extract MIS checkbox
|
|
8. Attempt to click Submit button
|
|
|
|
**Expected Results:**
|
|
- Validation error is displayed
|
|
- Error message indicates maximum date is required
|
|
- Search is NOT created
|
|
|
|
---
|
|
|
|
### TC-110-N06: 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 + Extract MIS" search type (Type 110)
|
|
4. Set minimum date to `2018-01-01`
|
|
5. Set maximum date to `2020-09-01`
|
|
6. Add work center `11275CA`
|
|
7. Enable Extract MIS checkbox
|
|
8. Attempt to click Submit button
|
|
|
|
**Expected Results:**
|
|
- Validation error is displayed
|
|
- Error message indicates search name is required
|
|
- Search is NOT created
|
|
|
|
---
|
|
|
|
### TC-110-N07: All Required Filters Missing
|
|
|
|
**Preconditions:**
|
|
- User is logged in
|
|
- User has access to the Submit Search page
|
|
|
|
**Steps:**
|
|
1. Navigate to Submit Search page
|
|
2. Enter search name: "Test 110-N07 All Filters Missing"
|
|
3. Select "Time Span + Work Center + Extract MIS" search type (Type 110)
|
|
4. Leave minimum date empty
|
|
5. Leave maximum date empty
|
|
6. Do NOT add any work center
|
|
7. Attempt to click Submit button
|
|
|
|
**Expected Results:**
|
|
- Submit button is disabled OR validation errors are displayed
|
|
- Error messages indicate all required fields are missing
|
|
- Search is NOT created
|
|
|
|
---
|
|
|
|
## Notes
|
|
|
|
- Data was extracted from `WorkOrder_Hist` table (1,742,847 records)
|
|
- Work centers from `WorkOrderStep_Hist` table
|
|
- MIS data from `MisData_Hist` table
|
|
- The Extract MIS flag determines whether MIS data is included in search results
|
|
- Work center codes have different suffixes (AS, CA, CB) indicating different work center types
|