[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

Julian Maurice <julian.maurice at biblibre.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|Failed QA                   |In Discussion

--- Comment #16 from Julian Maurice <julian.maurice at biblibre.com> ---
The problem is that PROFESSION attribute has equivalent values with different
cases.

mysql> SELECT attribute FROM borrower_attributes WHERE code = 'PROFESSION'  AND
borrower_attributes.attribute is not null  AND borrower_attributes.attribute
LIKE 'Enseignant';
+------------+
| attribute  |
+------------+
| Enseignant |
| enseignant |
+------------+

The mysql GROUP BY clause is case insensitive, so in the process we lose one of
those values

mysql> SELECT attribute FROM borrower_attributes WHERE code = 'PROFESSION'  AND
borrower_attributes.attribute is not null  AND borrower_attributes.attribute
LIKE 'Enseignant' group by attribute;
+------------+
| attribute  |
+------------+
| Enseignant |
+------------+

The TOTAL takes into account 'Enseignant' and 'enseignant' values but does not
display the 'enseignant' value because of that.

I don't know what is the best way to solve this issue. Should we continue to
display only one line but display all values in the same line? Or should we
display multiple lines for every "case-variant"?

Changing status to "In discussion".

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