dohertj2/jdescopingtool
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
jdescopingtool/TestScripts/SearchPage/100_TimeSpan_WorkCenter_ItemNumber.md
T
Joseph Doherty 04383d672c refactor: UI file upload components and ephemeral RSA key service 
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.
2026-01-28 17:22:30 -05:00

411 lines
11 KiB
Markdown
Raw Permalink Blame History

# Search Type 100: Time Span + Work Center + Item Number
## Overview
Search Type 100 allows users to search by a date range combined with work center(s) and item number(s). This search type finds work orders processed through specific work centers for specific items 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 |
| Item Number | One or more item numbers | 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 |
### Item Numbers
| ItemNumber |
|------------|
| 00003200700 |
| 00003200800 |
| 00003200900 |
| 00003201500 |
| 00003205000 |
| 00003205100 |
| 00003205200 |
| 00003208800 |
| 00003208900 |
| 00003209000 |
| 00003300100 |
| 00003300200 |
| 00003300300 |
| 00003304900 |
| 00003305000 |
---
## Positive Test Cases
### TC-100-P01: Single Work Center with Single Item 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: "Test 100-P01 Single WC Single Item"
3. Select "Time Span + Work Center + Item Number" search type (Type 100)
4. Set minimum date to `2018-01-01`
5. Set maximum date to `2019-12-31`
6. Add work center `10595CA`
7. Add item number `00003205000`
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: 10595CA, Item: 00003205000
---
### TC-100-P02: Single Work Center with Multiple Item Numbers
**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 100-P02 Single WC Multi Items"
3. Select "Time Span + Work Center + Item Number" search type (Type 100)
4. Set minimum date to `2019-01-01`
5. Set maximum date to `2020-09-01`
6. Add work center `11275CA`
7. Add item number `00003200700`
8. Add item number `00003200800`
9. Add item number `00003200900`
10. Click Submit button
**Expected Results:**
- Search is created with status "Queued"
- Search appears in the user's search list
- Search criteria shows work center and all three item numbers
---
### TC-100-P03: Multiple Work Centers with Single Item 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: "Test 100-P03 Multi WC Single Item"
3. Select "Time Span + Work Center + Item Number" search type (Type 100)
4. Set minimum date to `2018-01-01`
5. Set maximum date to `2019-12-31`
6. Add work center `0083AS`
7. Add work center `0278AS`
8. Add work center `0424AS`
9. Add item number `00003201500`
10. Click Submit button
**Expected Results:**
- Search is created with status "Queued"
- Search criteria shows all three work centers and the item number
---
### TC-100-P04: Multiple Work Centers with Multiple Item Numbers
**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 100-P04 Multi WC Multi Items"
3. Select "Time Span + Work Center + Item Number" search type (Type 100)
4. Set minimum date to `2017-01-01`
5. Set maximum date to `2020-09-01`
6. Add work center `10595CA`
7. Add work center `11350CA`
8. Add item number `00003300100`
9. Add item number `00003300200`
10. Click Submit button
**Expected Results:**
- Search is created with status "Queued"
- Search criteria shows both work centers and both item numbers
---
### TC-100-P05: Historical Date Range with Work Center and Items
**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 100-P05 Historical Search"
3. Select "Time Span + Work Center + Item Number" search type (Type 100)
4. Set minimum date to `2016-01-01`
5. Set maximum date to `2017-12-31`
6. Add work center `1700CB`
7. Add item number `00003205100`
8. Add item number `00003205200`
9. Click Submit button
**Expected Results:**
- Search is created with status "Queued"
- Search criteria reflects the historical date range
---
### TC-100-P06: Work Center Code Variants (AS vs CA suffix)
**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 100-P06 WC Code Variants"
3. Select "Time Span + Work Center + Item Number" search type (Type 100)
4. Set minimum date to `2018-01-01`
5. Set maximum date to `2020-09-01`
6. Add work center `1010AS` (AS suffix)
7. Add work center `14305CA` (CA suffix)
8. Add item number `00003208800`
9. Click Submit button
**Expected Results:**
- Search is created with status "Queued"
- Both work center code formats are accepted
---
## Negative Test Cases
### TC-100-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 100-N01 Missing Dates"
3. Select "Time Span + Work Center + Item Number" search type (Type 100)
4. Leave minimum date empty
5. Leave maximum date empty
6. Add work center `10595CA`
7. Add item number `00003205000`
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-100-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 100-N02 Missing Work Center"
3. Select "Time Span + Work Center + Item Number" search type (Type 100)
4. Set minimum date to `2018-01-01`
5. Set maximum date to `2019-12-31`
6. Do NOT add any work center (leave empty)
7. Add item number `00003205000`
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-100-N03: Missing Item 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: "Test 100-N03 Missing Item Number"
3. Select "Time Span + Work Center + Item Number" search type (Type 100)
4. Set minimum date to `2018-01-01`
5. Set maximum date to `2019-12-31`
6. Add work center `10595CA`
7. Do NOT add any item number (leave empty)
8. Attempt to click Submit button
**Expected Results:**
- Submit button is disabled OR validation error is displayed
- Error message indicates at least one item number is required
- Search is NOT created
---
### TC-100-N04: 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 100-N04 Invalid Date Range"
3. Select "Time Span + Work Center + Item Number" search type (Type 100)
4. Set minimum date to `2020-09-01`
5. Set maximum date to `2018-01-01` (before minimum date)
6. Add work center `10595CA`
7. Add item number `00003205000`
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-100-N05: 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 100-N05 Missing Min Date"
3. Select "Time Span + Work Center + Item Number" search type (Type 100)
4. Leave minimum date empty
5. Set maximum date to `2019-12-31`
6. Add work center `11275CA`
7. Add item number `00003200700`
8. Attempt to click Submit button
**Expected Results:**
- Validation error is displayed
- Error message indicates minimum date is required
- Search is NOT created
---
### TC-100-N06: 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 100-N06 Missing Max Date"
3. Select "Time Span + Work Center + Item Number" search type (Type 100)
4. Set minimum date to `2018-01-01`
5. Leave maximum date empty
6. Add work center `0083AS`
7. Add item number `00003201500`
8. Attempt to click Submit button
**Expected Results:**
- Validation error is displayed
- Error message indicates maximum date is required
- Search is NOT created
---
### TC-100-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 + Item Number" search type (Type 100)
4. Set minimum date to `2018-01-01`
5. Set maximum date to `2019-12-31`
6. Add work center `10595CA`
7. Add item number `00003205000`
8. Attempt to click Submit button
**Expected Results:**
- Validation error is displayed
- Error message indicates search name is required
- Search is NOT created
---
### TC-100-N08: 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 100-N08 All Filters Missing"
3. Select "Time Span + Work Center + Item Number" search type (Type 100)
4. Leave minimum date empty
5. Leave maximum date empty
6. Do NOT add any work center
7. Do NOT add any item number
8. 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
- Work center codes have different suffixes (AS, CA, CB) indicating different work center types
- Item numbers are 11-digit codes in the JDE system
Reference in New Issue View Git Blame Copy Permalink