May be this is not the suitable forum for this topics and please if any recommendations it will be much appreciated.
Please I need your help.
I need to add ordering and sorting function to the [patient list] report records to be like the [Appointment Report].
I need the fields and columns (Last Visit, Patient Name, File Number) to be as hyperlinks, when I press these field the sorting changed as the field.
-When I press the patient name the records to be sorted alphabetically.
-When I press the file number the records to be sorted from the 1st one increasingly.
-When I press the last visit the records to be sorted increasingly.
I tried in patient_list.php file but its not working.
May not be so much useful in case of patient list but for smaller lists you can use this Firefox addon without need to touch the code for occasional table manipulation requirements.
You’re welcome. Please make a backup of your current file, openemr/interface/reports/patient_list.php and then replace the live file with the attached.
A concession had to be made for this javascript approach. There is no total number of patients at the bottom of the list now.
Edit: it’s only working accurately for names at this moment.
I have combined the changes in the two files (attached) and it works as expected. However, sorting with the Last Visit column gives the best result when the date display format is set in globals as YYYYMMDD as I think it sorts the column as text not as date. I believe most people can work with this is it is not possible to make it sort this column as date format.