http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7679
Julian Maurice <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Failed QA |In Discussion --- Comment #16 from Julian Maurice <[email protected]> --- 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. _______________________________________________ Koha-bugs mailing list [email protected] http://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/
