Description

We are trying to run an inventory definition (the item-01 Service) on some of our auction catalogs, and the report isn't generating a shelf number. Our auction catalog call numbers are a numeric string based on date (YYYYMMDD). We input the call numbers for the beginning and end of a shelf range, and choose "Auction Catalogs" ("3") as the call number type and "JCAC" as the collection. After running the definition report, no shelf report number was generated so we couldn't proceed with an inventory of that section. 

We are specifying, for example: 

 p_call_no_from "2008"
 p_call_no_to "2009"
 

Resolution 

This is similar to the article " p_item_05 doesn't work for SuDocs (or other non-LC classifications) ".

The following SQL shows z30_call_no_key's with the subfield as a prefix, in the form "$$hyyyymmdd":

  SQL> select z30_call_no_key from z30 where z30_collection = 'JCAC';

You will need to do something like this: 

 from key: $$h20080001 

 to key: $$h20090001 

Try it initially without quote-marks, and if that doesn't work, try putting the key in quotation marks, single or double.  

• Article last edited: 8-Dec-2018