[Koha-bugs] [Bug 24305] Batch Item modification via item number in reports does not work with CONCAT in report

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

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

Holly <hc at interleaf.ie> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |hc at interleaf.ie

--- Comment #2 from Holly <hc at interleaf.ie> ---
I tested this and noticed something odd. The examples given in the test plan
worked as expected:

Results from reports using only the CONCAT statement did not produce a link to
to the batch tools.

Reports that did not use the CONCAT statement at all did produce a link to the
batch tools. 

Reports that had the CONCAT statement but also had results that were not
concatenated did produce a link to the batch tools, but only for the results
that were not concatenated. e.g

SELECT itemnumber, CONCAT('<a
href=\"/cgi-bin/koha/cataloguing/additem.pl?op=edititem&biblionumber=',
biblionumber, '&itemnumber=', itemnumber, '#edititem', '\">', itemnumber,
'</a>' ) AS itemnumber
    FROM items
    LIMIT 10;

produced a link to the batch tools for the first instance of itemnumber.

However, I tried to create a report that used the CONCAT statement for both the
biblionumber and the itemnumber and the results included a button to link to
the batch tools, however it did not have a dropdown menu to select which tool
to go to.

SELECT CONCAT('<a href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=',
biblionumber, '\">', biblionumber, '</a>' ) AS biblionumber, CONCAT('<a
href=\"/cgi-bin/koha/cataloguing/additem.pl?op=edititem&biblionumber=',
biblionumber, '&itemnumber=', itemnumber, '#edititem', '\">', itemnumber,
'</a>' ) AS itemnumber
    FROM items
    LIMIT 10

I don't think the button should appear at all in this instance and it shouldn't
appear if it is not going to link out to anything. 

Best,
Holly

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