https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7335 Cab Vinton <bibliwho@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |bibliwho@gmail.com --- Comment #1 from Cab Vinton <bibliwho@gmail.com> --- 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.