http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11243
--- Comment #12 from Jonathan Druart <[email protected]> --- (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. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
