Handy Query Searches in FOLIO
- Jennifer Bolmarcich
If you will be repeating a particular search frequently, or need to print a large list to use for data cleanup, physical inventory, etc., or if you need to search MARC SRS, using LDLite to run a report will be the most efficient way to get at the data you need. Check with Aaron Neslin about requesting a specific report. You can also ask in the #scripting-and-reports-chat for assistance in creating SQL queries for LDLite. Your institution’s representative on the Five Colleges Batch Loading Team can work with you as well.
ITEMS
QUERY | WHAT IS FOUND | HOW IT WORKS |
|---|---|---|
| items without barcodes | the first part finds items where items.id (=UUID) exists, but not items that have barcode defined as any value. Even though the UI shows a dash when there is no barcode, there is no "barcode" field in the JSON until you add a real value. |
| all instances or holdings records without items OR with items without barcodes | the first part finds all records where the barcode field is not defined. This includes any instance or holdings without items, but also finds items that have no barcodes. |
| all instances or holdings records without items | the first part finds all records where the item.id field is not defined. This includes any instance or holdings without items. |
| all instances or holdings records without items OR with items lacking barcodes that are not also on order | The query is similar to the one above, but also excludes any items with status of “On order”. This limits the located items to ones that are most likely actual errors. |
| Finds “Staff Only” item notes |
|
HOLDINGS
QUERY STRING | WHAT IS FOUND | HOW IT WORKS |
| finds holdings records that have a URL for electronic access that contains the string “hampshire” | The uri fieldname corresponds to the URL entered in the Electronic Access section of a holdings record. The query looks for any url containing the provided text. This query is most useful when searching for proxied urls or other institution-specific addresses. |
| Find holdings records with URLS but no link text |
|
| Finds “Staff Only” holdings notes |
|
INSTANCES
QUERY STRING | WHAT IS FOUND | HOW IT WORKS |
|---|---|---|
| finds instances with electronic access URIs (aka 856 links in MARC SRS) | Looks for any instance record where the field electronicAccess.uri is defined (if there is no data, the field is undefined). |
| Finds “Staff Only” instance notes |
|
| instances without holdings records | Retrieves all records except those having an associated holdings id value. |