# 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