**END USER QUERY TEST CASES**

**TEST CASE 2-Simple Query using OR & AND option**

**Narrative:** The TTB Administrator is preparing a quarterly report &
would like to search for all reported problems with subject of failed
search in the last 3 months at Presbyterian, HUP or Pennsylvania
Hospital.

+------+----------------------------+---------+--------------+-------+
| **M  |                            | **Test  |              |       |
| odul |                            | Case    |              |       |
| e:** |                            | Name:** |              |       |
| Q    |                            | TEST    |              |       |
| uery |                            | CASE    |              |       |
|      |                            | 2       |              |       |
|      |                            | -Simple |              |       |
|      |                            | Query   |              |       |
|      |                            | using   |              |       |
|      |                            | OR      |              |       |
|      |                            | option  |              |       |
+======+============================+=========+==============+=======+
| **   |                            | **Pas   |              |       |
| Test |                            | s/Fail: |              |       |
| Dat  |                            | Fail**  |              |       |
| e:** |                            |         |              |       |
| 1/1  |                            |         |              |       |
| 0/07 |                            |         |              |       |
+------+----------------------------+---------+--------------+-------+
| **Te |                            |         |              |       |
| ster |                            |         |              |       |
| Nam  |                            |         |              |       |
| e:** |                            |         |              |       |
| Tara |                            |         |              |       |
| McSh |                            |         |              |       |
| erry |                            |         |              |       |
+------+----------------------------+---------+--------------+-------+
| **P  | To test if a User **(TTB   |         |              |       |
| urpo | Administrator)** may       |         |              |       |
| se** | perform a search using the |         |              |       |
|      | OR option.                 |         |              |       |
+------+----------------------------+---------+--------------+-------+
| **Pr | **Assumption:**            |         |              |       |
| ereq |                            |         |              |       |
| uisi | \*User has privileges to   |         |              |       |
| te** | query information          |         |              |       |
|      |                            |         |              |       |
|      | \*User login successful    |         |              |       |
|      |                            |         |              |       |
|      | \*All test data            |         |              |       |
|      | information has been       |         |              |       |
|      | previously entered.        |         |              |       |
+------+----------------------------+---------+--------------+-------+
| **   | **Affiliation:**           |         |              |       |
| Test | Presbyterian, HUP &        |         |              |       |
| Da   | Pennsylvania               |         |              |       |
| ta** |                            |         |              |       |
|      | **Subject:** failed search |         |              |       |
+------+----------------------------+---------+--------------+-------+
|      |                            |         | **Expected   | **A   |
|      |                            |         | Results**    | ctual |
|      |                            |         |              | Resu  |
|      |                            |         |              | lts** |
+------+----------------------------+---------+--------------+-------+
|      |                            |         |              |       |
+------+----------------------------+---------+--------------+-------+
| *    | 1\. User selects the       |         | 1\. Search   | 12\.  |
| *Ste | Search dashboard view.     |         | option is    | [BUG  |
| ps** |                            |         | displayed on | #     |
|      | 2\. User selects the       |         | the HOME     | 2625: |
|      | Simple search option.      |         | dashboard.   | When  |
|      |                            |         | Search       | t     |
|      | 3\. User selects "Reported |         | options are  | ester |
|      | Problem" from the 1^st^    |         | presented on | cl    |
|      | drop down box.             |         | the screen.  | icked |
|      |                            |         |              | on    |
|      | 4\. User selects "Subject" |         | 6\. \# of    | the   |
|      | from the 2^nd^ drop down   |         | characters   | cal   |
|      | box.                       |         | should be    | endar |
|      |                            |         | allowed and  | icon  |
|      | 5\. User selects "equals"  |         | should not   | no    |
|      | from the 3^rd^ drop down   |         | be case      | thing |
|      | box.                       |         | sensitive.   | happ  |
|      |                            |         |              | ened. |
|      | 6\. User enters "failed    |         | 8\.          | (The  |
|      | search" in the data entry  |         | Selection    | cal   |
|      | field.                     |         | should       | endar |
|      |                            |         | create ANDed | w     |
|      | 7\. User selects "AND"     |         | constraint.  | indow |
|      | from the 4th drop down     |         |              | did   |
|      | box.                       |         | 12\.         | not   |
|      |                            |         | Calendar     | pop   |
|      | 8\. User clicks on the     |         | should pop   | up    |
|      | **ADD MORE** button.       |         | up and date  | .)]{. |
|      |                            |         | should be    | mark} |
|      | 9\. User selects "Reported |         | able to be   |       |
|      | Problem" from the 1^st^    |         | selected.    |       |
|      | drop down box in the 2nd   |         |              |       |
|      | row.                       |         | 14\.         |       |
|      |                            |         | Selection    |       |
|      | 10\. User selects          |         | should       |       |
|      | "Reported Date" from the   |         | create ANDed |       |
|      | 2^nd^ drop down box in the |         | constraint.  |       |
|      | 2nd row.                   |         |              |       |
|      |                            |         | 18\. \# of   |       |
|      | 11\. User selects "\>"from |         | characters   |       |
|      | the 3^rd^ drop down box in |         | should be    |       |
|      | the 2nd row.               |         | allowed and  |       |
|      |                            |         | should not   |       |
|      | 12\. User clicks on        |         | be case      |       |
|      | calendar icon and selects  |         | sensitive.   |       |
|      | 07/09/2006.                |         |              |       |
|      |                            |         | 20\.         |       |
|      | 13\. User selects "AND"    |         | Selection    |       |
|      | from the 4th drop down box |         | should       |       |
|      | in the 2nd row.            |         | create ORed  |       |
|      |                            |         | constraint.  |       |
|      | 14\. User clicks on the    |         |              |       |
|      | **ADD MORE** button.       |         | 24\. \# of   |       |
|      |                            |         | characters   |       |
|      | 15\. User selects          |         | should be    |       |
|      | "Reported Problem" from    |         | allowed and  |       |
|      | the 1^st^ drop down box in |         | should not   |       |
|      | the 3rd row.               |         | be case      |       |
|      |                            |         | sensitive.   |       |
|      | 16\. User selects          |         |              |       |
|      | "Affiliation" from the     |         | 26\.         |       |
|      | 2^nd^ drop down box in the |         | Selection    |       |
|      | 3rd row.                   |         | should       |       |
|      |                            |         | create ORed  |       |
|      | 17\. User selects "Equals" |         | constraint.  |       |
|      | from the 3^rd^ drop down   |         |              |       |
|      | box in the 3rd row.        |         | 30\. \# of   |       |
|      |                            |         | characters   |       |
|      | 18\. User enters           |         | should be    |       |
|      | "Presbyterian" in the data |         | allowed and  |       |
|      | entry field.               |         | should not   |       |
|      |                            |         | be case      |       |
|      | 19\. User selects "OR"     |         | sensitive.   |       |
|      | from the 4th drop down box |         |              |       |
|      | in the 3rd row.            |         | 31\. The     |       |
|      |                            |         | System       |       |
|      | 20\. User clicks on the    |         | conducts a   |       |
|      | **ADD MORE** button.       |         | search for   |       |
|      |                            |         | all reported |       |
|      | 21\. User selects          |         | failed       |       |
|      | "Reported Problem" from    |         | searches at  |       |
|      | the 1^st^ drop down box in |         | P            |       |
|      | the 4th row.               |         | resbyterian, |       |
|      |                            |         | HUP or       |       |
|      | 22\. User selects          |         | Pennsylvania |       |
|      | "Affiliation" from the     |         | after        |       |
|      | 2^nd^ drop down box in the |         | 7/9/2006.    |       |
|      | 4th row.                   |         |              |       |
|      |                            |         |              |       |
|      | 23\. User selects "Equals" |         |              |       |
|      | from the 3^rd^ drop down   |         |              |       |
|      | box in the 4th row.        |         |              |       |
|      |                            |         |              |       |
|      | 24\. User enters "HUP" in  |         |              |       |
|      | the data entry field.      |         |              |       |
|      |                            |         |              |       |
|      | 25\. User selects "OR"     |         |              |       |
|      | from the 4th drop down box |         |              |       |
|      | in the 4th row.            |         |              |       |
|      |                            |         |              |       |
|      | 26\. User clicks on the    |         |              |       |
|      | **ADD MORE** button.       |         |              |       |
|      |                            |         |              |       |
|      | 27\. User selects          |         |              |       |
|      | "Reported Problem" from    |         |              |       |
|      | the 1^st^ drop down box in |         |              |       |
|      | the 5th row.               |         |              |       |
|      |                            |         |              |       |
|      | 28\. User selects          |         |              |       |
|      | "Affiliation" from the     |         |              |       |
|      | 2^nd^ drop down box in the |         |              |       |
|      | 5th row.                   |         |              |       |
|      |                            |         |              |       |
|      | 29\. User selects "Starts  |         |              |       |
|      | With" from the 3^rd^ drop  |         |              |       |
|      | down box in the 5th row.   |         |              |       |
|      |                            |         |              |       |
|      | 30\. User enters "Penn" in |         |              |       |
|      | the data entry field.      |         |              |       |
|      |                            |         |              |       |
|      | 31\. User selects the      |         |              |       |
|      | **Search** button.         |         |              |       |
+------+----------------------------+---------+--------------+-------+
| **N  | \*Tester needed to insert  |         |              |       |
| otes | problem reports prior to   |         |              |       |
| and  | this test case             |         |              |       |
| Que  |                            |         |              |       |
| stio |                            |         |              |       |
| ns** |                            |         |              |       |
+------+----------------------------+---------+--------------+-------+