Searching of Cases under Case Listing (EMSU Web)

As an EMSU user, I need to search the case from the case listing based on the criteria so that I can filter and view the particular cases.

Menu: Case-->Cases

Rules:

1. EMSU will be able to access feedback cases from all TCs under their care. e.g. if EMSU user login is tagged to C&W, they can only view C&W managed TC cases. If EMSU user login is tagged to EM Services, they can only view EM Services managed TC etc. By default, it will show all new, open and deployed cases.
2. Users are allowed to perform a wildcard search using Case ID (Refer to Fig 1. Search using Case ID). Implement search using 'LIKE' in SQL. When user clicks on reset, system shall reset the search box.
3. Search Filters (Refer to Fig 2. Search Filters). System shall allow user to reset search filter by clicking clear all.
   1. Logged Date From - Check against creation datetime (DateTime)
   2. Logged Date To - Check against creation datetime (DateTime)
   3. TC - Only display TCs under login's user Managing Agent (e.g. C&W, EM services, CPG etc.) (Multi selection dropdown)
   4. Division - Only display division when TC is selected (dropdown)
   5. Location - Only display when TC is selected (dropdown)
   6. Category - Display category code + category description (Multi selection dropdown)
   7. SubCategory - Only display when category is selected. Display subcategory code + subcategory description of selected category (Multi selection dropdown)
   8. Complainant Contact Number - User must enter the correct contact number (free text field)
   9. Case Status - New (Default checked), Open (Default checked), TCF, FIN, Deployed (Default checked) (checkbox)
   10. EMSU Time - Sent, Onsite, Completed (checkbox)
   11. Urgency - Currently, there are 2 agency codes: E1, N2 (checkbox). Note: Urgency code can be null
   12. Lift - Not Synced (checkbox)
4. User will be able to expand and collapse search filter. 
5. On first load, system shall display all new, open and deployed cases for all TCs under their care.

Fig 1. Search using Case ID

Fig 2. Search Filters