[Koha-bugs] [Bug 34639] Item shown in transit on detail.pl even if marked as arrived or cancelled

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34639

Lari Taskula <lari.taskula at hypernova.fi> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |Needs Signoff

--- Comment #12 from Lari Taskula <lari.taskula at hypernova.fi> ---
Adding order_by back the way it was before works just fine. I confirmed this
with dumping the SQL trace and it indeed still performs the ORDER BY

SELECT `me`.`branchtransfer_id`, `me`.`itemnumber`, `me`.`daterequested`,
`me`.`datesent`, `me`.`frombranch`, `me`.`datearrived`, `me`.`datecancelled`,
`me`.`tobranch`, `me`.`comments`, `me`.`reason`, `me`.`cancellation_reason`
FROM `items` `item__row`  JOIN `branchtransfers` `me` ON ( `me`.`datearrived`
IS NULL AND `me`.`datecancelled` IS NULL AND `me`.`itemnumber` =
`item__row`.`itemnumber` ) WHERE ( `item__row`.`itemnumber` = ? ) ORDER BY
`datesent` DESC, `daterequested` ASC: '2299

It now looks okay to me.

-- 
You are receiving this mail because:
You are watching all bug changes.