[Koha] Need help to create SQL query to display public list content

[Abdullrahman Hegazy]

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 at 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 at 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 at bue.edu.eg <Abdullrahman.hegazy at bue.edu.eg>*