[Koha-bugs] [Bug 11243] Supplier list counts all items, even canceled ones

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11243

--- Comment #12 from Jonathan Druart <jonathan.druart at biblibre.com> ---
(In reply to Katrin Fischer from comment #11)
> Hi Jonathan, I retested this and think I spotted a problem:
> 
> Order: 2 orders
> Cancel one order, delete bibliographic record
> Item cound is correct, but biblio count doesn't show the cancelled biblio.

Since the aqorders.biblionumber is set to null on deleting a biblio I don't
know how to get the correct count.
I could do something like: 
  COUNT(DISTINCT(COALESCE(aqorders.biblionumber, timestamp))) AS total_biblios
in order to get the total number of biblio for a basket. But if a same biblio
is ordered in several orders, the value will be wrong.

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