https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37879
Bug ID: 37879
Summary: Whitespaces mess with report results
Change sponsored?: ---
Product: Koha
Version: 23.05
Hardware: All
OS: All
Status: NEW
Severity: new feature
Priority: P5 - low
Component: Cataloging
Assignee: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
CC: [email protected]
When a whitespace character (such as a space, tab, or line break) is
accidentally added at the end of a subfield, it can cause issues in SQL
reports. Specifically, it shifts all subsequent fields to the next columns,
which disrupts the results.
For example, if I select authid, 670$a, and 670$b from the auth_header table,
and a space or tab has been added at the end of the 670$a subfield data in,
say, the 3rd authority record, the resulting CSV will have an empty 670$b
column. The data from 670$b will appear in the 1st column of the 4th line, the
authid of the 4th record will be in the 670$a column, and so on.
Therefore, would it be possible to add a tool or something that prevents
catalogers from adding or pasting text that starts or ends with a whitespace
character?
--
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]
https://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/
