Files
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

15 KiB

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

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

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

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