[Koha-bugs] [Bug 31361] New: Button batch operations disappears when alias is used for itemnumber of biblionumber

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

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

            Bug ID: 31361
           Summary: Button batch operations disappears when alias is used
                    for itemnumber of biblionumber
 Change sponsored?: ---
           Product: Koha
           Version: 21.11
          Hardware: All
                OS: Windows
            Status: NEW
          Severity: normal
          Priority: P5 - low
         Component: Reports
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: j.m.koopmans at saxion.nl
        QA Contact: testopia at bugs.koha-community.org

Created attachment 139128
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=139128&action=edit
screenshot report result with batch modification button

When running a SQL-report and using an alias for itemnumber or biblionumber in
SELECT, the button for 'Batch operations with 20 visible records' disappears.

Using an alias for other columns is no problem.

Example SQL with button:

SELECT items.itemnumber,items.barcode,items.notforloan as
Status,biblio.title,items.ccode as Itemtype
FROM items 
LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) 
LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber)  
WHERE items.homebranch=<<homebranch|branches>> AND
items.itype=<<itype|itemtypes>> AND items.notforloan=<<notforloan>>
ORDER BY items.itemnumber asc

Changing it to 'SELECT items.itemnumber as Itemnr, etc.' removes the button and
the ability for batch processing.

The same thing occurs when using an alias for biblionumber in a report.

Example SQL with button:
SELECT CONCAT ('<a
href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=',biblio.biblionumber,'\"
target=new>',biblio.title,' </a>') as Titel,
items.biblionumber,biblio.datecreated as Datum
FROM items 
LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) 
LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) 
where date (datecreated) BETWEEN <<From date|date>> AND <<To date|date>>
ORDER BY biblio.datecreated desc

Changing 'items.biblionumber to items.biblionumber as Biblionr' removes the
button.

Also tested it in version 20.11 with the same results.

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