[Koha] Sql report for list of items according to shelving location

[Saira Asghar]

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 <paul.a at navalmarinearchive.com>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
> Koha at lists.katipo.co.nz
> 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: saira.asghar at namal.edu.pk
Ph: 0459 236995 Ext. 138