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