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

8.7 KiB
Raw Permalink Blame History

Search Type 90: Time Span + Profit Center + Extract MIS

Overview

Search Type 90 allows users to search by a date range combined with profit 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 in the specified profit center(s) and time range.

Filters Enabled

Filter Description Required
Timespan Date range (Min Date to Max Date) Yes
Profit Center One or more profit 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

Profit Centers

Code
1AM
1BM
1CM
1PM
2DM
2SM
3TM
4IM
5SM

Extract MIS Values

Value Description
true Extract MIS data for matching work orders
false Do not extract MIS data

Positive Test Cases

TC-090-P01: Single Profit 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 090-P01 Single PC Extract MIS"
  3. Select "Time Span + Profit Center + Extract MIS" search type (Type 90)
  4. Set minimum date to 2020-01-01
  5. Set maximum date to 2020-09-01
  6. Add profit center 1PM
  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 2020-01-01 to 2020-09-01, Profit Center: 1PM, Extract MIS: true

TC-090-P02: Multiple Profit 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 090-P02 Multiple PC Extract MIS"
  3. Select "Time Span + Profit Center + Extract MIS" search type (Type 90)
  4. Set minimum date to 2018-01-01
  5. Set maximum date to 2019-12-31
  6. Add profit center 1AM
  7. Add profit center 1BM
  8. Add profit center 1CM
  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 profit centers (1AM, 1BM, 1CM) and Extract MIS: true

TC-090-P03: Single Profit 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 090-P03 Single PC No Extract MIS"
  3. Select "Time Span + Profit Center + Extract MIS" search type (Type 90)
  4. Set minimum date to 2019-01-01
  5. Set maximum date to 2019-12-31
  6. Add profit center 2DM
  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 2019-01-01 to 2019-12-31, Profit Center: 2DM, Extract MIS: false

TC-090-P04: Historical Date Range with Multiple Profit 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 090-P04 Historical Multi PC"
  3. Select "Time Span + Profit Center + Extract MIS" search type (Type 90)
  4. Set minimum date to 2016-01-01
  5. Set maximum date to 2017-12-31
  6. Add profit center 3TM
  7. Add profit center 4IM
  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 profit centers

TC-090-P05: All Available Profit 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 090-P05 All Profit Centers"
  3. Select "Time Span + Profit Center + Extract MIS" search type (Type 90)
  4. Set minimum date to 2018-01-01
  5. Set maximum date to 2020-09-01
  6. Add all profit centers: 1AM, 1BM, 1CM, 1PM, 2DM, 2SM, 3TM, 4IM, 5SM
  7. Enable Extract MIS checkbox (set to true)
  8. Click Submit button

Expected Results:

  • Search is created with status "Queued"
  • Search criteria includes all nine profit centers

Negative Test Cases

TC-090-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 090-N01 Missing Dates"
  3. Select "Time Span + Profit Center + Extract MIS" search type (Type 90)
  4. Leave minimum date empty
  5. Leave maximum date empty
  6. Add profit center 1PM
  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-090-N02: Missing Profit 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 090-N02 Missing Profit Center"
  3. Select "Time Span + Profit Center + Extract MIS" search type (Type 90)
  4. Set minimum date to 2020-01-01
  5. Set maximum date to 2020-09-01
  6. Do NOT add any profit 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 profit center is required
  • Search is NOT created

TC-090-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 090-N03 Invalid Date Range"
  3. Select "Time Span + Profit Center + Extract MIS" search type (Type 90)
  4. Set minimum date to 2020-09-01
  5. Set maximum date to 2020-01-01 (before minimum date)
  6. Add profit center 1PM
  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-090-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 090-N04 Missing Min Date"
  3. Select "Time Span + Profit Center + Extract MIS" search type (Type 90)
  4. Leave minimum date empty
  5. Set maximum date to 2020-09-01
  6. Add profit center 1AM
  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-090-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 090-N05 Missing Max Date"
  3. Select "Time Span + Profit Center + Extract MIS" search type (Type 90)
  4. Set minimum date to 2020-01-01
  5. Leave maximum date empty
  6. Add profit center 1BM
  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-090-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 + Profit Center + Extract MIS" search type (Type 90)
  4. Set minimum date to 2020-01-01
  5. Set maximum date to 2020-09-01
  6. Add profit center 1PM
  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

Notes

  • Data was extracted from WorkOrder_Hist table
  • MIS data from MisData_Hist table
  • The Extract MIS flag determines whether MIS data is included in search results
  • Profit centers correspond to branch codes in the JDE system
Reference in New Issue View Git Blame Copy Permalink