[Koha-bugs] [Bug 10635] can't query for create in action_logs

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10635

Fridolyn SOMERS <fridolyn.somers at biblibre.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |fridolyn.somers at biblibre.co
                   |                            |m

--- Comment #2 from Fridolyn SOMERS <fridolyn.somers at biblibre.com> ---
(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.