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

Halo friends, I need technical help in sql, Am at zero level hence I need your help from scratch. Always grateful. Godfrey Quoting Saira Asghar saira.asgha...@gmail.com: Hello Everyone I need a report for list of items according to shelving location. If anyone has this kind of sql report

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

Hi Godfrey, you do not specify fields you are interested in. Only some fields from the items table? Or some fields from the bilio table too? Anyway, maybe you can start trying select * from items order by cn_sort or select * from biblio b, items i where b.biblionumber=i.biblionumber order by

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

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. I shall be very thankful for your kind help. Waiting for reply -- *Regards* Saira Asghar Librarian Namal College,

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

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

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

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 pau...@navalmarinearchive.comwrote: At 06:54 PM 11/1/2013 +0500, Saira Asghar wrote: Hello Everyone I need a report for list of items