Patient List Creation Reports Issues


(timothy) #1

Hello,
I found out that the date restriction on Reports >> Clients >> Patients LIst Creation; does not restrict to specific dates during pull out.
i.e you submit a request for a pull out for Jan 1, 2020 to Jan 27, 2020.
Outcome: it does pull out for dates both within the specified dates and before the specified dates.

I am using openemr 5.0.1(7)


(ViSolve) #2

@timothy1,
Currently for “Demographics” option, date filter is not applied. To make it work, include the highlighted part(refer screenshot) in the file interface/reports/patient_list_creation.php.

Kindly share your views.

Thanks,
ViSolve-120


(timothy) #4

@visolveemr,
Thanks for your response.
Please what is the specific line in the file will it be posted.
Thanks


(ViSolve) #5

@timothy1,
File name : interface/reports/patient_list_creation.php
Line No : 366(Approximately)
Copy and paste the below lines after communication (refer screenshot specified in the above thread)

case “Demographics”:
$whr_stmt=$whr_stmt." AND pd.date >= ? AND pd.date < DATE_ADD(?, INTERVAL 1 DAY) AND pd.date <= ?";
array_push($sqlBindArray, $sql_date_from, $sql_date_to, date(“Y-m-d H:i:s”));
break;

Kindly check and let us know if you have further clarifications.

Thanks,
ViSolve-120


(timothy) #6

@visolveemr,
I have copied and pasted it, however on clicking on patient list creation there is no display.
It is blank.
A cursory look at the file, from ln 325, specifies the sql joint statement which is not available for demographics.
I may be wrong.
what can be done?


(timothy) #7

Hello,
@visolveemr,
Can this be solved, any way out?


(ViSolve) #8

@timothy1
• Click on Reports >> Clients >> Patients List Creation
• Initially the page will be blank, and on clicking submit button the data will be filtered out.
• The filter option is not applied for demographics. To include it try to replace the file attached below
patient_list_creation.php (38.0 KB)

Still if you find any issues, provide us the detailed steps.

Thanks,
ViSolve-120


(timothy) #9

Hi,
No more issues.
It worked. thanks @visolveemr.


(timothy) #10

Hi @visolveemr,
Thanks for your contribution and effort the other day.
There is a new issue. I found out that when we do report pull out there are some patients that are missing.
However on deleting the line of code you gave above, those patients will appear and the number of patients that will be captured in the report pull out will be higher.
What could the issue be and

What can be done?

Thanks.