dohertj2/jdescopingtool
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
jdescopingtool/TestScripts/SearchPage/130_TimeSpan_WorkCenter_WorkOrder_ItemOperationMIS.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

13 KiB
Raw Permalink Blame History

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)
Reference in New Issue View Git Blame Copy Permalink