https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26940
Séverine Queune <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #23 from Séverine Queune <[email protected]> --- Jonathan and Katrin, I don't know if you're waiting for a specific sign off from Didier, but to me everything works fine. Here are the results of the different requests, wich seem consistent to me : mysql> SELECT d.borrowernumber, GROUP_CONCAT(comment SEPARATOR '\n') AS comment FROM borrower_debarments d JOIN borrowers b ON b.borrowernumber=d.borrowernumber WHERE (b.debarredcomment IS NULL OR b.debarredcomment = '') AND ( expiration > CURRENT_DATE() OR expiration IS NULL ) GROUP BY d.borrowernumber; +----------------+---------+ | borrowernumber | comment | +----------------+---------+ | 70 | NULL | +----------------+---------+ 1 row in set (0.00 sec) mysql> SELECT COUNT(*) FROM (SELECT 1 FROM borrower_debarments d JOIN borrowers b ON b.borrowernumber=d.borrowernumber WHERE (b.debarredcomment IS NULL ) AND ( expiration > CURRENT_DATE() OR expiration IS NULL ) GROUP BY d.borrowernumber) as e; +----------+ | COUNT(*) | +----------+ | 1 | +----------+ 1 row in set (0.01 sec) mysql> SELECT COUNT(*) FROM (SELECT 1 FROM borrower_debarments d JOIN borrowers b ON b.borrowernumber=d.borrowernumber WHERE (b.debarredcomment IS NULL OR b.debarredcomment = '' ) AND ( expiration > CURRENT_DATE() OR expiration IS NULL ) AND (comment IS NOT NULL OR comment <> '') GROUP BY d.borrowernumber) as e; +----------+ | COUNT(*) | +----------+ | 0 | +----------+ 1 row in set (0.00 sec) Let me know if you need I sign it ! -- You are receiving this mail because: 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/
