Patient List Creation Reports Don't Filter

[maggienegm]

A) Outreachy Username: maggie.negm
B) Issue Title: Patient List Creation Filtering Incorrectly
C) Report Date: 01/21/2020
D) Sites Affected: Docs Site, NHANES
E) OS/Browser Used: Chrome browser in Linux OS
F) EHR Workflow Module: Report – Patient List Creation
G) Steps to Reproduce the Issue:

1. Select “Reports” from the main menu.
2. Select “Clients” under “Reports.”
3. Select “Patient List Creation” under “Clients.”
4. Fill out and submit the form.

H) Expected Behavior: The correct results should be returned.
I) What Actually Happened: Depending on the input entered, especially the “Option” chosen, the form isn’t returning the correct results.

• Demographics option: returns the same list
• Problems option: doesn’t return anything
• Medications option: doesn’t return anything
• Allergies option: doesn’t return anything
• Lab Results option: doesn’t return anything
• Communication option: returns the same list

J) Screenshots with Explanation:

• Example 1:
  Input:
  From: 01/01/2019
  To: 08/01/2019
  Option: Demographics
  Gender: Female
  Output:
  Total Patients: 104
  

• Example 2
  Input:
  Option: Demographics
  Patient ID: 123456
  Gender: Male
  Output:
  Total Patients: 104
  

• Example 3
  Input:
  Option: Allergies
  Output:
  No records found.
  

The following is the code that displays the form within Chrome Inspector:

K) Estimation of Severity: Critical – module function continues with ongoing errors
M) Solution: I would start by looking at the filtering function and the database queries being called when the form is submitted within the PatientListController.php file.

Similar Issue: #1496