Dear Team, how to get the sql report on Patron additional attributes for example Department, Student Roll number, blood group and etc?
Sample SQL Code. SELECT ROW_NUMBER() OVER (ORDER BY LPAD(borrowers.cardnumber,100,' ') ASC) AS 'S.No', borrowers.cardnumber AS "Lib Membership No",borrowers.borrowernumber,borrowers.surname AS " Name",borrowers.title,borrowers.sex,borrowers.dateofbirth AS " Date of Birth",borrowers.contactname AS "Guardian Name", borrowers.relationship, 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 <<Select User category|categorycode>> -- Thanking you.. Librarian, MAMCET <http://mamcet.com/> Trichy-Chennai Trunk Road, Siruganur, Tiruchirappalli-621 105. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha