Bug 23792 - Send borrowernumbers from report to batch modify
Summary: Send borrowernumbers from report to batch modify
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: Reports (show other bugs)
Version: Main
Hardware: All All
: P5 - low enhancement (vote)
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-10-10 01:23 UTC by Andrew Fuerste-Henry
Modified: 2021-08-27 13:14 UTC (History)
3 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Andrew Fuerste-Henry 2019-10-10 01:23:40 UTC
Apologies if this bug is a dupe, I really thought I'd seen this one before and now can't find it.

It'd be great to be able to run a report listing patrons and send them straight to batch patron modification, as we can now do with items.
Comment 1 Katrin Fischer 2019-10-10 05:11:02 UTC
Hi Andrew, it works with cardnumber - but I agree borrowernumber would be nice, especially since I think we allow empty cardnumbers now.
Comment 2 Andrew Fuerste-Henry 2019-10-10 11:17:16 UTC
Ahha! Cardnumber to report added in Bug 23206. Thanks!
As you say, though, it'd still be good to be able to use borrowernumber when cardnumber is null.
Comment 3 Holly 2020-07-06 08:30:10 UTC
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!
Comment 4 Andrew Fuerste-Henry 2020-07-06 11:51:07 UTC
Hi Holly! Bug 23390 created a syntax for renaming columns without loosing your batch processing options. 
"This enhancement allows for renaming columns used to trigger batch modification actions in reports. Before this patch, a column had to be called 'itemnumber' to be sent from reports to batch modification. With this enhancement, you can specify `[[itemnumber| Koha_internal_id]]` to allow for a clearer name for the end-user and to allow translation of terms like 'itemnumber' while preserving the batch modification functionality."
Comment 5 Holly 2020-07-06 11:54:59 UTC
Thanks Andrew, you're great!