Page Comparison

items.id=="" NOT items.barcode==""

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.

cql.allRecords=1 NOT items.barcode==""

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.

cql.allRecords=1 NOT items.id==""

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.

cql.allRecords=1 NOT items.barcode=="" NOT item.status.name=="On order"

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.

item.notes.staffOnly=="true"

Finds “Staff Only” item notes

electronicAccess.uri==""

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).

notes.staffOnly=="true"

Finds “Staff Only” instance notes

cql.allRecords=1 not holdings.id=""

instances without holdings records

Retrieves all records except those having an associated holdings id value.