Dear Mr. Paul. A Thank you so much for sharing this report. This is absolutely according to my need.
Thanks again On Fri, Nov 1, 2013 at 8:28 PM, Paul A <[email protected]>wrote: > At 06:54 PM 11/1/2013 +0500, Saira Asghar wrote: > >> Hello Everyone >> >> I need a report for list of items according to shelving location. If >> anyone >> has this kind of sql report then please send me or help me in generating >> this. >> > > You might try: > > SELECT > biblio.author,biblio.title,**biblio.copyrightdate,items.** > barcode,items.price,items.**dateaccessioned,items.** > location,items.booksellerid > FROM items, biblio > WHERE items.biblionumber = biblio.biblionumber > AND > items.location = <<Pick your shelf (use auth. value)>> > ORDER BY biblio.author ASC > > then modify to suit your own needs. > > Best - Paul > > ______________________________**_________________ > Koha mailing list http://koha-community.org > [email protected] > http://lists.katipo.co.nz/**mailman/listinfo/koha<http://lists.katipo.co.nz/mailman/listinfo/koha> > -- *Regards* Saira Asghar Librarian Namal College, 30-Kilometer Talagang Road, Mianwali, Pakistan. E-mail: [email protected] Ph: 0459 236995 Ext. 138 _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
