[Koha-bugs] [Bug 7679] Statistics wizard: circulation (new filters)

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7679

--- Comment #29 from Julian Maurice <julian.maurice at biblibre.com> ---
Created attachment 26531
  -->
http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=26531&action=edit
Bug 7679: Various fixes for circulation statistics wizard

- use SQL TRIM functions to avoid having '' and ' ' considered as
  different values
- use Text::Unaccent to remove accents from columns or rows values when
  accessing %table. This is required as MySQL consider as equals two
  strings that differ only by their accents when using GROUP BY clause.
- Exclude '' values from the list of columns or rows. Otherwise we could
  have a row 'UNKNOWN VALUE' and a row 'NULL' which both have the same
  values in their cells.

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