https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24488 Bug ID: 24488 Summary: Holds to Pull sometimes shows the wrong 'first patron' details Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Circulation Assignee: koha-bugs@lists.koha-community.org Reporter: aleisha@catalyst.net.nz QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com, kyle.m.hall@gmail.com The query that pulls the information for the Circ -> Holds to pull table is incredibly complex and doesn't always pull the correct information. It has a bunch of commands in it that repeatedly reorders the results (group_concats and counts). This means the order of the results cannot be guaranteed to be the same with every execution, and sometimes we see the wrong 'first patron' for the given date selection. It's hard to test because it only happens sometimes, but I have been able to reproduce it this way: - Place two holds for two different patrons on the same biblio - Check the Holds to pull, it'll show the details of the first patron - Change the reservedate for the second hold in the database to be yesterday - Check the Holds to pull, it shows the details of the wrong hold under 'first patron' but shows the correct details 'under earliest hold date' - Change the date selection, it doesn't fix itself -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.