[Koha-bugs] [Bug 23792] Send borrowernumbers from report to batch modify

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

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

Holly <hc at interleaf.ie> changed:

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

--- Comment #3 from Holly <hc at interleaf.ie> ---
Hi,
I just wanted to express interest in this change. As Andrew mentioned in
situations where the cardnumber field is null, it would be a great help to be
able to use the borrowernumber instead.

I also wanted to mention one other thing, and apologies if this is out of scope
of this bug, but some of the libraries I support have raised that if you use an
alias for the cardnumber column in a report then the option to send the results
to the batch patron modification tool does not come up. 

Example:

SELECT borrowers.cardnumber AS 'Student Number', borrowers.firstname AS 'First
Name', borrowers.surname AS 'Second Name'
FROM borrowers

The results of a report like this would include a column of cardnumbers with
the name "Student Number", and the option to send the results to be batch
modified will not come up.


I don't know if it is alright to mention that on this specific bug or if there
is anything that could be done so it would be possible to use aliases and still
get the option to send report results to the batch patron modification tool,
but I thought I'd chance it!

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