SELECT * FROM items,virtualshelfcontents Where items.biblionumber=virtualshelfcontents.biblionumber AND shelfnumber=308 // You can find the shelf number in the address bar after viewshelf like this "viewshelf=308" On 2 February 2015 at 01:15, carola miranda <cmirandacursos@gmail.com> wrote:
*Hi everyone!! *
*Is posible create an SQL report to display content of specific public list?*
Regards / Carola --
Carola Miranda Cerda Programación y Desarrollo WEB Adobe Certified Asociated Educator _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- *Abdullrahman Hegazy <https://www.facebook.com/Boudy.Magic>* *System Librarian Assistant* *The British University in Egypt* *Mobile**: (2)0111-53 51 602* *E-Mail: Abdullrahman.hegazy@bue.edu.eg <Abdullrahman.hegazy@bue.edu.eg>*