Patrons (Lib Membership List ) by Category wise Report (Koha SQL Reports Queries)

 Library Membership List.

• Crete the New SQL Report
• Copy and Paste  following lines in the SQL report. Save and close.

SELECT borrowers.cardnumber,borrowers.borrowernumber,borrowers.surname,borrowers.title,borrowers.sex,borrowers.dateofbirth,borrowers.contactname,

borrowers.borrowernotes,borrowers.phone,borrowers.email,borrowers.address,borrowers.categorycode,borrowers.dateenrolled,borrowers.dateexpiry,borrowers.userid FROM borrowers WHERE branchcode=<<Enter patrons library|branches>> AND categorycode LIKE <<Enter categorycode borrowers|categorycode>>

ORDER BY LPAD(borrowers.cardnumber,100,' ') ASC

Run Report