To find all bibs without items you can try this report from the SQL Report Library: http://wiki.koha-community.org/wiki/SQL_Reports_Library#All_bibs_without_items
If the items aren't showing, but the bibs are you might have OPACHiddenItems (http://manual.koha-community.org/3.8/en/administration.html#OpacHiddenItems) set to something that's hiding items or even hidelostitems set (http://manual.koha-community.org/3.8/en/administration.html#hidelostitems). Hope that helps some, Nicole On Mon, Oct 15, 2012 at 1:48 AM, Chief Librarian, SAIACS <[email protected]> wrote: > Dear Folks, > > > > I have created a recorded and entered items details such as call number, > barcode and other information. My problem is that holding details in > cataloguing is not shown also in OPAC. I do not know if this question was > resolved earlier. > > > > I also want to find those records with no items, is there a SQL command to > find and edit them. > > > > Thanks in anticipation. > > > > ______________________________________ > > Yesan Sellan, B.Com., MLISc., PGDLAN > > Chief Librarian > > South Asia Institute of Advanced Christian Studies (SAIACS) > > 363 Dodda Gubbi Cross Road, Kothanur Post Office, Bangalore -560077, INDIA > > Phone : 91 80 2846 5235/5344/ 5649, > > Fax : 91 80 28465412, > > Mobile : 91-9972348251 > > Website : <http://www.saiacs.org/> www.saiacs.org > > Alternative Email: <mailto:[email protected]> [email protected] > or <mailto:[email protected]> [email protected] > > ______________________________________ > > IMPORTANT : This message is intended only for the addressee. It may contain > confidential information. Any unauthorized disclosure is strictly > prohibited. If you have received this message in error, please notify us > immediately so that we may correct our internal records. Please then delete > the original message. Thank you. > > > > P Please consider the environment before printing this email. > > > > _______________________________________________ > Koha mailing list http://koha-community.org > [email protected] > http://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
