Instances:
- Search all instances that aren't suppressed and that have no holdings/items attached and that aren't boundwiths and are source = marc
- Search all instances that aren't suppressed and are source = folio with a status of Awaiting receipt in the POL over a certain period of time
- Search all instances that aren't suppressed that have any information in the Electronic access fields (marc srs 856)
- Search all instances that aren't suppressed that don't have eng as the language of cataloging
- Search all instances that aren't suppressed that are missing format and type information
- Search all instances that aren't suppressed that are invalid
- Search all instances by contributor
- Search all instances by subject
- Search all instances by title
- Search all instances cataloged between specified dates
- Search all instances created between specific dates
- Search all instances updated between specific dates
- Search for instances that are suppressed in Location “Music Storage,” with material type “Media,” and not mode of issuance not ‘serial.’
- Search for stat code “OUP-EBA-PUR-2023,” with create date “TODAY.”
Holdings:
- Search for our local holdings records for our print serials and retrieve only those holdings and not all holdings attached to that instance. For example, we have print serials in special collections and general collections on the same record and I need only the one in general collections.
- Search for holdings records that aren't suppressed where one of the fields in the Electronic Access array is missing like relationship type or link text or public note.
- Search for holdings that aren't suppressed that is connected to an instance that isn't suppressed and where there is only that holdings record.
- Search for call number in holdings that have whitespace before or after and/or a return.
- Search for holdings that are only in a certain location or set of locations either permanent or temporary.
- Search by statistical code.
...