https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33756
--- Comment #6 from Emmi Takkinen <[email protected]> --- (In reply to Mathieu Saby from comment #5) > I am trying to test, but your report > > SELECT budget_id, budget_code FROM aqbudgets > WHERE budget_id IN( > SELECT budget_id > FROM aqorders > WHERE quantity != quantityreceived > AND quantityreceived > 0) > > never seems to give any result. It seem logical, since when a partial > reception is made for a book ordered in multiple copies, Koha create a new > order line. > > In which situation is the condition (quantity != quantityreceived AND > quantityreceived > 0) supposed to return true ? > > I did not test further for the moment. It should return orders where quantity a.k.a. how many items has been ordered within a single order doesn't yet match the quantity of received items. Condition quantityreceived > 0 then leaves out those orders where none of the ordered items hasn't yet been received. -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] https://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/
