Search for records where a field does not exist

How to create a list of records that does not have a given field

Table of Contents

1 How to:
2 Related Documentation

How to:

Sierra Create Lists is able to search for a field that does not exist, however this search is not included in the user interface. You can only include it in your search with JSON. Here’s the JSON search to look for a bib record without an 020 field:

{
  "target": {
    "record": {
      "type": "bib"
    },
    "field": {
      "marcTag": "245",
      "subfields": "a"
    }
  },
  "expr": {
    "op": "not_exists",
    "operands": [
      "",
      ""
    ]
  }
}

You can use that alone or add it to a search with other criteria.

Top of page

Related Documentation

Page:

Re-run Existing Query or Edit Existing Query for Create Lists (Sierra) (Marmot Knowledge Base)
Page:

Saved Searches (Create Lists) (Marmot Knowledge Base)
Page:

System Generated Review Files (Create Lists) (Marmot Knowledge Base)
Page:

In Transit Too Long Report and Create Lists Import Barcodes (Sierra) (Marmot Knowledge Base)
Page:

User Generated Macros (Sierra) (Marmot Knowledge Base)
Page:

Saved Searches, Saved Sorts, Saved Lists and Saved Exports (Create Lists) (Marmot Knowledge Base)
Page:

Guidelines (Create Lists) (Marmot Knowledge Base)
Page:

Patrons with Billed Items (Statement of Checked-out Items or Statement of Charges) (Create Lists) (Marmot Knowledge Base)
Page:

Sorting a Review File and Saving a Sort (Create Lists) (Marmot Knowledge Base)
Page:

Check Out (Circulation Desk) Item on the Fly (Sierra) (Marmot Knowledge Base)
Page:

Removing Duplicate Records in a Review File (Create Lists) (Marmot Knowledge Base)
Page:

Create a list using ISBNs (Marmot Knowledge Base)
Page:

Remove Records from a Review File (Global Update) (Marmot Knowledge Base)
Page:

Use Existing Search (Create Lists) (Marmot Knowledge Base)
Page:

Patron Record Fixed Length Field Definitions (Sierra) (Marmot Knowledge Base)