https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7335
Cab Vinton <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #1 from Cab Vinton <[email protected]> --- This is a bit kludgy, but I believe it works: Report for patrons w/ emails: SELECT cardnumber, surname, firstname, email, dateexpiry, dateenrolled FROM borrowers WHERE email IS NOT NULL AND email!= '' ORDER BY CASE WHEN @SortOrder:=<<Search order>> = 'dateexpiry' THEN dateexpiry WHEN @SortOrder= 'cardnumber' THEN cardnumber END Official column names have to be used rather than something more user-friendly, but otherwise it's -- 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/
