Bulk Edit Queries Examples
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 (including the URL Relationship; 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 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.
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.
Items:
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
Search for items with one or many item statuses
Search for item records in one or many locations either temp or perm
Search for particular item material types
Search by barcode, HRIDs and UUIDs
Search instances that are for eResources where there is one holdings record and on that holdings have more than one item record.
Search for open loans (items status = checked out) due on a specific date.
Users:
Search for users with passed expiration date
Search for users with a specific patron group or list of patron groups
Search for student workers
Search for patrons with patron block.
Marc SRS Bibliographic:
Search all bibliographic marc srs records for an 008 that is an invalid length (less or more than 40).
Questions:
General question: How should the records identified by each query be acted upon?
By suppression of instance records do we mean Staff suppress or Suppress from discovery?
How do you define local holdings? Holdings with permanent or temporary location associated with a specific library?
Should search by statistical code be available on each inventory record level?
Is the search by barcode/uuid/hrid just by one barcode or multiple? How this relates to uploading a file with identifiers?
How do you determine that the instance is for eResource?
How would you identify student worker?
For the questions ...
General question: How should the records identified by each query be acted upon?
For example, searching the statistical code. For a search of statistical code for UM Retention, I want to make sure that all the items have been withdrawn. Here the action would be to update the item status. For searching instances that are for eResources with one holdings record and multiple item records, then the action would be to delete the extra item record since for us it should be a 1-1-1 relationship between instance-holdings-item. Searching for location would mean updating that location in the holdings record or removing the temporary at the item level.
By suppression of instance records do we mean Staff suppress or Suppress from discovery?
I think I would want the ability to be able to do one or the other or both. Sometimes I run a LDLite query for our instances marked as delete which should be staff suppressed and suppressed from discovery and over time there are variations on that theme that we fix up.
How do you define local holdings? Holdings with permanent or temporary location associated with a specific library?
Local holdings are holdings statements that include information on coverage such as year, volume, enumeration. The LHR or local holdings records process for us only concerns our print serials where we need to export marc records that have this information for a selected subset of print serials and then we send this marc file to OCLC. Some of our print serials are in the general and special collections and we need to take information found in the holdings records and instance from print serials in our general collections.
Should search by statistical code be available on each inventory record level?
This would be amazing to have.
Is the search by barcode/uuid/hrid just by one barcode or multiple? How this relates to uploading a file with identifiers?
Search by barcode would be multiple and this does relate to being able to upload a file with identifiers. I realize that some of these searches are complex and are more appropriate for a tool like LDLite where we can get a list of identifiers to act on.
How do you determine that the instance is for eResource?
For us here, we can use the marc field 338 or the instance format computer – online resource. We are careful to make sure all our eresources have this. However, other schools may have other practices such as using the Holdings Type field in the holdings record.
How would you identify student worker?
I think we have user groups (undergraduate and graduate).