What bib records contain an nnn field?
- Product: Aleph
- Product Version: 20, 21, 22, 23
- Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care
Description
What's the best way to get the titles of bib records which contain a particular tag (such as the 242)?
Resolution
Two ways:
1. Run the ret-01 service; or
2. Search the z00r and get the title from the z13:
SQL> select /*+ DYNAMIC_SAMPLING(2) ALL_ROWS */ z13_rec_key, z13_title from z13 where z13_rec_key in (select /*+ DYNAMIC_SAMPLING(2) ALL_ROWS */ Z00R_DOC_NUMBER from z00r where Z00R_FIELD_CODE like '242%');
(Or one could look for the z00r record for this doc number with z00r_field_code '245%'.)
- Article last edited: 31-Mar-2016