Bulk Edit Queries Examples

Instances:

1. Search all instances that aren't suppressed and that have no holdings/items attached and that aren't boundwiths and are source = marc
2. 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
3. Search all instances that aren't suppressed that have any information in the Electronic access fields (including the URL Relationship; marc srs 856)
4. Search all instances that aren't suppressed that don't have eng as the language of cataloging
5. Search all instances that aren't suppressed that are missing format and type information
6. Search all instances that aren't suppressed that are invalid
7. Search all instances by contributor
8. Search all instances by subject
9. Search all instances by title
10. Search all instances cataloged between specified dates
11. Search all instances created between specific dates
12. Search all instances updated between specific dates
13. Search for instances that are suppressed in Location “Music Storage,” with material type “Media,” and not mode of issuance not  ‘serial.’
14. Search for stat code “OUP-EBA-PUR-2023,” with create date “TODAY.”

Holdings:

1. 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.
2. 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.
3. Search for holdings records that aren't suppressed where one of the fields in the Electronic Access array is X for the relationship type or link text or public note.
4. 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.
5. Search for call number in holdings that have whitespace before or after and/or a return.
6. Search for holdings that are only in a certain location or set of locations either permanent or temporary.
7. Search by statistical code.

Items:

1. Search for items that were created during a certain time period and then updated during a certain time period with the status of in process
2. Search for items with one or many item statuses
3. Search for item records in one or many locations either temp or perm
4. Search for particular item material types
5. Search by barcode, HRIDs and UUIDs
6. Search instances that are for eResources where there is one holdings record and on that holdings have more than one item record.
7. Search for open loans (items status = checked out) due on a specific date.

Users:

1. Search for users with passed expiration date
2. Search for users with a specific patron group or list of patron groups
3. Search for student workers
4. Search for patrons with patron block.

Marc SRS Bibliographic:

1. Search all bibliographic marc srs records for an 008 that is an invalid length (less or more than 40).

Questions:

1. General question: How should the records identified by each query be acted upon?
2. By suppression of instance records do we mean Staff suppress or Suppress from discovery?
3. How do you define local holdings?  Holdings with permanent or temporary location associated with a specific library?
4. Should search by statistical code be available on each inventory record level?
5. Is the search by barcode/uuid/hrid just by one barcode or multiple?  How this relates to uploading a file with identifiers?
6. How do you determine that the instance is for eResource?
7. How would you identify student worker?