Excluding graphic novels from PAC search results via record set

Clearinghouse Repository Polaris Repository
1

During the July 17, 2025, cataloging forum, a question was raised about excluding graphic novels from search results.

Here at CLC, what we had to do was build up a record set of graphic novels and then exclude that record set by creating a new PAC Limit By option.

What I didn’t have during the session was how we identified the graphic novels. I’m including the information below from our developer @mfields about how we do this.

select distinct bt.BibliographicRecordID
from polaris.polaris.BibliographicTags bt
join polaris.polaris.BibliographicSubfields bs
    on bs.BibliographicTagID = bt.BibliographicTagID
where bt.TagNumber = 008
    and substring(bs.Data, 25, 1) = '6'
1 Like