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.
555 lines
15 KiB
Markdown
555 lines
15 KiB
Markdown
# Time Span + Work Center Search (Type 40) - Test Scripts
|
|
|
|
## Overview
|
|
|
|
Test scripts for Time Span + Work Center search functionality (Search Type 40). This search type allows users to search by a date range combined with one or more work center codes.
|
|
|
|
**Filters Enabled:** Timespan, Work Center
|
|
|
|
---
|
|
|
|
## 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 |
|
|
|
|
---
|
|
|
|
## Positive Test Cases
|
|
|
|
### TC-040-P01: Single Work Center with Standard 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 Single Work Center"
|
|
3. Select "Time Span + Work Center" search type (Type 40)
|
|
4. Set minimum date to `2019-01-01`
|
|
5. Set maximum date to `2019-12-31`
|
|
6. Enter work center `0083AS` in the work center input field
|
|
7. Click Add to add the work center to the list
|
|
8. Verify the work center appears in the selected work centers list
|
|
9. Click Submit Search
|
|
|
|
**Expected Results:**
|
|
- Search is created with status "Queued"
|
|
- Search appears in the search list with name "Test Single Work Center"
|
|
- Search type is displayed as "Time Span + Work Center"
|
|
- Date range `2019-01-01` to `2019-12-31` is stored in criteria
|
|
- Work center `0083AS` is stored in the search criteria
|
|
|
|
---
|
|
|
|
### TC-040-P02: Multiple Work Centers Search
|
|
|
|
**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 Multiple Work Centers"
|
|
3. Select "Time Span + Work Center" search type (Type 40)
|
|
4. Set minimum date to `2018-01-01`
|
|
5. Set maximum date to `2019-12-31`
|
|
6. Enter work center `0083AS` and click Add
|
|
7. Enter work center `10595CA` and click Add
|
|
8. Enter work center `1700CB` and click Add
|
|
9. Verify all three work centers appear in the selected list
|
|
10. Click Submit Search
|
|
|
|
**Expected Results:**
|
|
- Search is created with status "Queued"
|
|
- Date range `2018-01-01` to `2019-12-31` is stored
|
|
- All three work centers (`0083AS`, `10595CA`, `1700CB`) are stored in criteria
|
|
- Search processes data from all three work centers
|
|
|
|
---
|
|
|
|
### TC-040-P03: Work Centers by Suffix Type (AS)
|
|
|
|
**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 AS Work Centers"
|
|
3. Select "Time Span + Work Center" search type (Type 40)
|
|
4. Set minimum date to `2019-01-01`
|
|
5. Set maximum date to `2019-12-31`
|
|
6. Add work centers with AS suffix: 0083AS, 0278AS, 0424AS, 0586AS, 0696AS, 1010AS, 1011AS
|
|
7. Verify all work centers appear in the selected list
|
|
8. Click Submit Search
|
|
|
|
**Expected Results:**
|
|
- Search is created with status "Queued"
|
|
- All 7 AS-suffix work centers are stored
|
|
- Search processes successfully
|
|
|
|
---
|
|
|
|
### TC-040-P04: Work Centers by Suffix Type (CA)
|
|
|
|
**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 CA Work Centers"
|
|
3. Select "Time Span + Work Center" search type (Type 40)
|
|
4. Set minimum date to `2018-01-01`
|
|
5. Set maximum date to `2020-09-01`
|
|
6. Add work centers with CA suffix: 10595CA, 11275CA, 11350CA, 11355CA, 13316CA, 14305CA, 15660CA, 200038CA, 200039CA, 200041CA, 200042CA
|
|
7. Verify all work centers appear in the selected list
|
|
8. Click Submit Search
|
|
|
|
**Expected Results:**
|
|
- Search is created with status "Queued"
|
|
- All 11 CA-suffix work centers are stored
|
|
- Search processes successfully
|
|
|
|
---
|
|
|
|
### TC-040-P05: All Work Centers Search
|
|
|
|
**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 All Work Centers"
|
|
3. Select "Time Span + Work Center" search type (Type 40)
|
|
4. Set minimum date to `2019-06-01`
|
|
5. Set maximum date to `2019-12-31`
|
|
6. Add all 20 work centers from the test data list
|
|
7. Verify all work centers appear in the selected list
|
|
8. Click Submit Search
|
|
|
|
**Expected Results:**
|
|
- Search is created with status "Queued"
|
|
- All 20 work centers are stored in the search criteria
|
|
- Search processes successfully
|
|
|
|
---
|
|
|
|
### TC-040-P06: Minimum Date Range (Same Day)
|
|
|
|
**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 WC Same Day Range"
|
|
3. Select "Time Span + Work Center" search type (Type 40)
|
|
4. Set minimum date to `2019-07-15`
|
|
5. Set maximum date to `2019-07-15`
|
|
6. Add work center `10595CA`
|
|
7. Click Submit Search
|
|
|
|
**Expected Results:**
|
|
- Search is created with status "Queued"
|
|
- Date range covers single day `2019-07-15`
|
|
- Search executes and returns results for that specific day
|
|
|
|
---
|
|
|
|
### TC-040-P07: Boundary Date - Start of Data 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 WC Start Boundary"
|
|
3. Select "Time Span + Work Center" search type (Type 40)
|
|
4. Set minimum date to `1905-01-20` (earliest date in database)
|
|
5. Set maximum date to `1905-12-31`
|
|
6. Add work center `0083AS`
|
|
7. Click Submit Search
|
|
|
|
**Expected Results:**
|
|
- Search is created with status "Queued"
|
|
- Search accepts the early date boundary
|
|
- Search may return no results if no data exists for this early period
|
|
|
|
---
|
|
|
|
### TC-040-P08: Boundary Date - End of Data 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 WC End Boundary"
|
|
3. Select "Time Span + Work Center" search type (Type 40)
|
|
4. Set minimum date to `2020-08-01`
|
|
5. Set maximum date to `2020-09-01` (latest date in database)
|
|
6. Add work center `11275CA`
|
|
7. Click Submit Search
|
|
|
|
**Expected Results:**
|
|
- Search is created with status "Queued"
|
|
- Search processes up to the maximum available date
|
|
- Results include data through September 1, 2020
|
|
|
|
---
|
|
|
|
### TC-040-P09: Historical Date Range Search
|
|
|
|
**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 WC Historical Search"
|
|
3. Select "Time Span + Work Center" search type (Type 40)
|
|
4. Set minimum date to `2016-01-01`
|
|
5. Set maximum date to `2017-12-31`
|
|
6. Add work center `14305CA`
|
|
7. Click Submit Search
|
|
|
|
**Expected Results:**
|
|
- Search is created with status "Queued"
|
|
- Search covers 2-year historical period
|
|
- Search executes successfully
|
|
|
|
---
|
|
|
|
### TC-040-P10: Work Center Remove and Re-add
|
|
|
|
**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 WC Remove Re-add"
|
|
3. Select "Time Span + Work Center" search type (Type 40)
|
|
4. Set minimum date to `2019-01-01`
|
|
5. Set maximum date to `2019-12-31`
|
|
6. Add work center `0083AS`
|
|
7. Add work center `0278AS`
|
|
8. Remove work center `0083AS` from the list
|
|
9. Verify only `0278AS` remains
|
|
10. Add work center `0424AS`
|
|
11. Click Submit Search
|
|
|
|
**Expected Results:**
|
|
- Search is created with status "Queued"
|
|
- Only work centers `0278AS` and `0424AS` are stored
|
|
- Work center `0083AS` is NOT included
|
|
|
|
---
|
|
|
|
### TC-040-P11: Work Center with No Suffix (200039)
|
|
|
|
**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 WC No Suffix"
|
|
3. Select "Time Span + Work Center" search type (Type 40)
|
|
4. Set minimum date to `2019-01-01`
|
|
5. Set maximum date to `2019-12-31`
|
|
6. Add work center `200039` (no suffix)
|
|
7. Click Submit Search
|
|
|
|
**Expected Results:**
|
|
- Search is created with status "Queued"
|
|
- Work center `200039` is stored correctly
|
|
- Search distinguishes between `200039` and `200039CA`
|
|
|
|
---
|
|
|
|
## Negative Test Cases
|
|
|
|
### TC-040-N01: 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 field empty
|
|
3. Select "Time Span + Work Center" search type (Type 40)
|
|
4. Set minimum date to `2019-01-01`
|
|
5. Set maximum date to `2019-12-31`
|
|
6. Add work center `0083AS`
|
|
7. Click Submit Search
|
|
|
|
**Expected Results:**
|
|
- Validation error is displayed indicating search name is required
|
|
- Search is NOT created
|
|
- User remains on Submit Search page
|
|
|
|
---
|
|
|
|
### TC-040-N02: No Search Type Selected
|
|
|
|
**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 No Type"
|
|
3. Do NOT select any search type
|
|
4. Attempt to set dates and add work centers (if possible)
|
|
5. Click Submit Search
|
|
|
|
**Expected Results:**
|
|
- Validation error is displayed indicating search type is required
|
|
- Search is NOT created
|
|
- Date and work center fields may be disabled until search type is selected
|
|
|
|
---
|
|
|
|
### TC-040-N03: Missing Minimum 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: "Test WC Missing Min Date"
|
|
3. Select "Time Span + Work Center" search type (Type 40)
|
|
4. Leave minimum date field empty
|
|
5. Set maximum date to `2019-12-31`
|
|
6. Add work center `0083AS`
|
|
7. Click Submit Search
|
|
|
|
**Expected Results:**
|
|
- Validation error is displayed indicating minimum date is required
|
|
- Search is NOT created
|
|
- Minimum date field is highlighted as invalid
|
|
|
|
---
|
|
|
|
### TC-040-N04: Missing Maximum 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: "Test WC Missing Max Date"
|
|
3. Select "Time Span + Work Center" search type (Type 40)
|
|
4. Set minimum date to `2019-01-01`
|
|
5. Leave maximum date field empty
|
|
6. Add work center `0083AS`
|
|
7. Click Submit Search
|
|
|
|
**Expected Results:**
|
|
- Validation error is displayed indicating maximum date is required
|
|
- Search is NOT created
|
|
- Maximum date field is highlighted as invalid
|
|
|
|
---
|
|
|
|
### TC-040-N05: Empty Work Center List
|
|
|
|
**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 Empty Work Centers"
|
|
3. Select "Time Span + Work Center" search type (Type 40)
|
|
4. Set minimum date to `2019-01-01`
|
|
5. Set maximum date to `2019-12-31`
|
|
6. Do NOT add any work centers
|
|
7. Click Submit Search
|
|
|
|
**Expected Results:**
|
|
- Validation error is displayed indicating at least one work center is required
|
|
- Search is NOT created
|
|
- Work center section is highlighted as requiring input
|
|
|
|
---
|
|
|
|
### TC-040-N06: Invalid Date Range (Min > Max)
|
|
|
|
**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 WC Invalid Date Range"
|
|
3. Select "Time Span + Work Center" search type (Type 40)
|
|
4. Set minimum date to `2019-12-31`
|
|
5. Set maximum date to `2019-01-01` (before min date)
|
|
6. Add work center `0083AS`
|
|
7. Click Submit Search
|
|
|
|
**Expected Results:**
|
|
- Validation error is displayed indicating minimum date must be before or equal to maximum date
|
|
- Search is NOT created
|
|
- Date fields are highlighted as invalid
|
|
|
|
---
|
|
|
|
### TC-040-N07: Invalid Work Center Code
|
|
|
|
**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 Invalid WC Code"
|
|
3. Select "Time Span + Work Center" search type (Type 40)
|
|
4. Set minimum date to `2019-01-01`
|
|
5. Set maximum date to `2019-12-31`
|
|
6. Enter invalid work center: "INVALIDWC"
|
|
7. Click Add
|
|
|
|
**Expected Results:**
|
|
- Validation error is displayed for invalid work center code OR
|
|
- System shows no matching work centers in autocomplete
|
|
- Invalid code is NOT added to the list
|
|
|
|
---
|
|
|
|
### TC-040-N08: Future 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 WC Future Dates"
|
|
3. Select "Time Span + Work Center" search type (Type 40)
|
|
4. Set minimum date to `2025-01-01`
|
|
5. Set maximum date to `2025-12-31`
|
|
6. Add work center `0083AS`
|
|
7. Click Submit Search
|
|
|
|
**Expected Results:**
|
|
- System may accept future dates (no data exists) OR
|
|
- Validation warning about future dates
|
|
- If accepted, search returns no results
|
|
|
|
---
|
|
|
|
### TC-040-N09: Invalid Date Format
|
|
|
|
**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 WC Invalid Date Format"
|
|
3. Select "Time Span + Work Center" search type (Type 40)
|
|
4. Attempt to enter invalid date format: "31-12-2019" or "2019/13/45"
|
|
5. Observe system behavior
|
|
|
|
**Expected Results:**
|
|
- Date picker prevents invalid date entry OR
|
|
- Validation error is displayed for invalid date format
|
|
- User must enter valid date in correct format
|
|
|
|
---
|
|
|
|
### TC-040-N10: Work Center with Special Characters
|
|
|
|
**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 WC Special Chars"
|
|
3. Select "Time Span + Work Center" search type (Type 40)
|
|
4. Set valid date range
|
|
5. Enter work center with special characters: "0083AS!@#"
|
|
6. Click Add
|
|
|
|
**Expected Results:**
|
|
- Validation error is displayed for invalid characters
|
|
- Work center with special characters is NOT added
|
|
- User is prompted to enter valid work center code
|
|
|
|
---
|
|
|
|
### TC-040-N11: Duplicate Work Center Entry
|
|
|
|
**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 WC Duplicate"
|
|
3. Select "Time Span + Work Center" search type (Type 40)
|
|
4. Set minimum date to `2019-01-01`
|
|
5. Set maximum date to `2019-12-31`
|
|
6. Add work center `0083AS`
|
|
7. Attempt to add work center `0083AS` again
|
|
8. Observe system behavior
|
|
|
|
**Expected Results:**
|
|
- System prevents duplicate work center entry OR displays validation message
|
|
- Work center `0083AS` appears only once in the list
|
|
- User can proceed to submit with single entry
|
|
|
|
---
|
|
|
|
## Notes
|
|
|
|
- Work center data was extracted from `WorkOrderStep_Hist` table
|
|
- Work center codes have various formats: numeric with suffix (AS, CA, CB) or numeric only
|
|
- Work centers represent physical locations or stations in the manufacturing process
|
|
- The search returns all work orders that passed through the specified work centers within the date range
|
|
- Some work centers may have variations (e.g., 200039 vs 200039CA) - ensure proper distinction
|