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

--- Comment #1 from Barton Chittenden <[email protected]> ---
Note that even though the query that I used to illustrate this problem won't
ever occur in production, this was triggered by a real report, that looked
something like this:

SELECT
    aqbasket.basketname,
    aqbasket.closedate,
    aqorders.biblionumber,
    aqorders_items.itemnumber,
    items.itemnumber AS 'items.itemnumber',
    biblio.title,
    items.barcode 
FROM
    aqbasket
    LEFT JOIN aqorders USING (basketno)
    LEFT JOIN aqorders_items on (aqorders.ordernumber =
aqorders_items.ordernumber)
    LEFT JOIN biblio on (aqorders.biblionumber = biblio.biblionumber)
    LEFT JOIN items on (aqorders_items.itemnumber = items.itemnumber)
WHERE
    aqbasket.basketname='XXXXXXXXXXXXXX'
GROUP BY
    aqorders_items.itemnumber

The 'Batch Modify' button was attached to the 'aqorders_items.itemnumber'
column, and there were instances where that was populated, even when
'items.itemnumber' was NULL.

-- 
You are receiving this mail because:
You are the assignee for the bug.
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/

Reply via email to