Summary: | catalog reports doesn't count a lot of items | ||
---|---|---|---|
Product: | Koha | Reporter: | Nahuel Angelinetti <nahuel.angelinetti> |
Component: | Reports | Assignee: | Henri-Damien LAURENT <henridamien> |
Status: | CLOSED FIXED | QA Contact: | Bugs List <koha-bugs> |
Severity: | normal | ||
Priority: | PATCH-Sent (DO NOT USE) | CC: | chris, gmcharlt, paul.poulain |
Version: | unspecified | ||
Hardware: | All | ||
OS: | All | ||
Change sponsored?: | --- | Patch complexity: | --- |
Documentation contact: | Documentation submission: | ||
Text to go in the release notes: | Version(s) released in: |
Description
Chris Cormack
2010-05-21 01:26:00 UTC
Patch: http://lists.koha-community.org/pipermail/koha-patches/2010-March/011517.html It would be good to know the steps to reproduce this problem since the report is so vague. Can anyone confirm whether this is now fixed? Want a challenge? Test me, I'm kinda vague and misunderstood, but you just might be the one person who can understand me. Owen, the interesting lines are : - $strsth .= "select distinctrow $linefield from biblioitems left join items on (items.biblioitemnumber = biblioitems.biblioitemnumber) where barcode $not LIKE ? AND $line is not null "; + my $strsth = "SELECT DISTINCTROW $linefield FROM biblioitems + INNER JOIN items USING (biblioitemnumber) + WHERE $line IS NOT NULL "; see the distinction between INNER JOIN and LEFT JOIN : http://www.w3schools.com/sql/sql_join_left.asp and http://www.w3schools.com/sql/sql_join_inner.asp (the rest of the patch is just changing lc to UC for SQL terms) it's in master though, so marking it resolved |