• Article Type: General
• Product: Aleph
• Product Version: 18.01

Description:
Summary print holdings data can be added to SFX to make Aleph target searching more precise. Currently, there is no simple way to extract this data from Aleph as part of it is in the xxx01, part in xxx60 and part in xxx50.

Data needed: title (can come from xxx01.z13), ISSN (from xxx01.z00), and holdings (xxx60.z00). It would be helpful to be able to select by collection (xxx50.z30_collection).

Right now, we're trying to do this via SQL, using LKRs between the various record types, but it's not simple.

Resolution:
It seems to me that you should be able to do this:

1. p_ret_01 in abc60 for a particular collection (852 $$c)

2. add these lines to the abc60 tab_expand:

PRINT-REC expand_doc_hol_bib
PRINT-REC expand_doc_hld_stmt
PRINT-REC expand_doc_hol_86x

3. run p_print_03 in abc60 -- using the output from step 1 as input and specifying 245, 022, 866, etc., as the fields you want to include in the exported record; and specifying "PRINT-REC" as the expand routine in the submission.

• Article last edited: 10/8/2013