[Koha-bugs] [Bug 24488] New: Holds to Pull sometimes shows the wrong 'first patron' details

[bugzilla-daemon at bugs.koha-community.org]

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 at lists.koha-community.org
          Reporter: aleisha at catalyst.net.nz
        QA Contact: testopia at bugs.koha-community.org
                CC: gmcharlt at gmail.com, kyle.m.hall at 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.