Skip to main content
OCLC Support

Is it possible to create a report of titles in our holdings that have no LHR attached?

Applies to
  • WMS: Collection Manager
  • WMS: Reports
Answer

It is possible to create a report of all of your titles with holdings where no Local Holdings Record is attached. Follow the steps below to create the report: 

  1. Create a Collection Manager Query collection with one of the following Selection criteria:
    • li: <your library's symbol> NOT l4:<your library's symbol>
      • Important! You MUST include the li: index with your library's symbol. Do NOT run a search without that limitation included.
  2. Enable MARC record delivery within the collection through the MARC Records tab.
  3. Save the collection being extra careful to check that the query's expected results match what you expect. If they do not or if your results are going to be over 25 million records, please contact OCLC Support.
  4. Use the Query WorldCat to create a spreadsheet of your WorldCat holdings instructions to get the report through MarcEdit.
Additional information
  • Note: that is "ell"7 and "ell"4 in the Selection criteria index, not i.
  • You can test your query in the Record Manager search box to get a rough idea of how many records will be returned. 
  • If you are only interested in identifying print material, You can exclude digital items by adding NOT x4: digital and/or NOT mt: elc. 
Page ID
12596