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_ite... 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 <library@saiacs.org> 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:yesan.sellan@saiacs.org> yesan.sellan@saiacs.org or <mailto:yesans@gmail.com> yesans@gmail.com

______________________________________

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 Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha