l2l request not available for 1 (or some?) titles -- becomes "title hold"

[Baroquem]

(Copy of https://issues.library.cornell.edu/browse/DISCOVERYACCESS-1903)

just placed a request in the new catalog for https://newcatalog.library.cornell.edu/catalog/4000659 to be delivered from the Annex to Mann, but noticed that the availability status has not changed. Shouldn’t it show that it’s been requested? Also, I noticed that the word ‘hold’ is used, which I recall in Voyager to mean it’s on hold, but will only be noticed if someone views or does something with the record.

Please clarify if this is behaving properly or if this is a glitch in the catalog.

Thanks,
Marty

Rick Silterra added a comment - 23/Jun/15 2:36 PM
Matt tracked this down to missing item information in the solr record.
Namely, there is no item information in the solr record.

so, in that situation, only kind of request that can be made for this is
a title hold.

Frances Webb added a comment - 23/Jun/15 3:45 PM - edited
Just confirming that the problem really was in my code, I think I've fixed it. I have a solution that tests out okay and should take effect in the next full Blacklight index build. The problem was a sql issue violating the structure of a left outer join, causing the query to execute like an inner join. In other words, any items without valid barcodes were not being included.

I tried to post the diff and it got mangled. The upshot is that the condition requiring any returned barcodes to be current/valid needs to be inside the join clause rather than the where clause.
Frances Webb added a comment - 03/Aug/15 10:07 AM
This has progressed to a point where I'm sending it back to Rick. I think I'm done here, but let me know if there are issues with what I've made available.

The bound-with data and empty (barcode-less) item records are now being reflected in the Solr index. (July index, currently For bound-with items that have empty item records created, these should now allow requesting of the empty items without further intervention. For those that don't have empty item records, requests can only be put in through the master item. The information about the master item is now in a field called bound_with_json.

An example of a record with four instances of this field:
http://da-stg-ssolr.library.cornell.edu/solr/blacklight/select?qt=document&id=28297

Shows these values. As you can see, for a multi-volume work, the item_enum will be populated, which is likely to differ from the item_enum for the "main" item bound in the same volume.

{"item_enum":"v.65","item_id":211754,"mfhd_id":"41908","barcode":"31924055272227"}{"item_enum":"v.75","item_id":211765,"mfhd_id":"41908","barcode":"31924055272326"}{"item_enum":"v.75A","item_id":211766,"mfhd_id":"41908","barcode":"31924055272334"}{"item_enum":"v.75B","item_id":211767,"mfhd_id":"41908","barcode":"31924055328219"}

Rick Silterra added a comment - 06/Aug/15 10:07 AM - edited
this pair is a little simpler:

this item is bound with the next item.
there is no item record for this
Shortcut link for this item is: https://catalog.library.cornell.edu/cgi-bin/Pwebrecon.cgi?BBID=5843735&DB=local

Database: Cornell University Library
Title: BIA school board handbook / written for the Bureau of Indian Affairs by Educational Consultant Services, Inc.
Published: Albuquerque, N.M. : Indian Education Resources Center, Bureau of Indian Affairs, [1974]
Description: iv, 77 p. : ill. ; 27 cm.
Location: Olin Library
Call Number: Oversize
E97.5 .N37 +
Notes: Bound with: 1973-- proceedings, National Indian Bilingual Education Conference.

0
69

*
all
{!raw f=id v=$id}
1
5843735
document






{"item_enum":"","item_id":7860364,"mfhd_id":"6337319","barcode":"31924103096933"}

xxxxxxxxxxxxxxxxxxxxxxxxxxx

Shortcut link for this item is: https://catalog.library.cornell.edu/cgi-bin/Pwebrecon.cgi?BBID=5843721&DB=local
this is the 'master' item for the previous item

Database: Cornell University Library
Conference: National Indian Bilingual Education Conference (1st : 1973 : Albuquerque, N.M.)
Title: 1973-- proceedings, National Indian Bilingual Education Conference.
Published: [Albuquerque, N.M.?] : U.S. Dept. of the Interior, Bureau of Indian Affairs, Office of Education Programs, Indian Education Resources Center, Division of Program Review and Evaluation, Branch of Curriculum, 1974.
Description: 152 p. : ill. ; 27 cm.
Location: Olin Library
Call Number: Oversize
E97.5 .N37 +
Status: Not Charged
Notes: Bound with : BIA school board handbook.

Shortcut link for this item is: https://catalog.library.cornell.edu/cgi-bin/Pwebrecon.cgi?BBID=5843721&DB=local