http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10635
Fridolyn SOMERS <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] | |m --- Comment #2 from Fridolyn SOMERS <[email protected]> --- (In reply to Nicole C. Engard from comment #0) > Created attachment 19888 [details] You may use a like : SELECT p.cardnumber, p.surname, p.firstname, p.streetnumber, p.address, p.address2, p.city, p.state, p.zipcode, p.email, p.phone, p.dateenrolled, p.smsalertnumber, l.action, l.timestamp AS 'action taken' FROM borrowers p LEFT JOIN action_logs l ON (p.borrowernumber=l.object) WHERE l.module='MEMBERS' AND date(l.timestamp) BETWEEN date_sub(curdate(), interval 1 week) AND curdate() AND (l.action LIKE 'MODIFY' OR l.action LIKE 'CREAT_') My 2c -- 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/
