Filtering Records - spectrum_quality_1 - 23.1

Spectrum Data Quality Guide

Product type
Software
Portfolio
Verify
Product family
Spectrum
Product
Spectrum > Quality > Spectrum Quality
Version
23.1
Language
English
Product name
Spectrum Data Quality
Title
Spectrum Data Quality Guide
Topic type
Overview
Reference
Tips
How Do I
First publish date
2007
ft:lastEdition
2024-03-04
ft:lastPublication
2024-03-04T22:52:13.486265

Use the Display records in which check box to filter the detail match records displayed. You can filter records based on several operators to compare user-provided values against data in one field of each detail match record.

The operators you can choose are:

  • String-type fields (MatchGroup, MatchRecordType, any matching data)
  • contains
  • is between
  • is equal to
  • is not equal to
  • starts with
  • Numeric-type fields (CollectionNumber, InputRecordNumber, MatchScore)
  • is between
  • is equal to
  • is not equal to
  • is greater than
  • is greater than or equal to
  • is less than
  • is less than or equal to

To filter records:

  1. Select a baseline or comparison match result from the Match Analysis Results view and click Refresh.
  2. Select the Display records in which check box.
  3. Select a field from the Field list box.
  4. Select an operator.
  5. Type a value for the selected operator type. If you select is between, type a range of values.
  6. When filtering on suspect views, you can filter on:
    • Parents—Filter just on parents (Suspects), all children returned.
    • Children—Filter out any children that do not fall in the filter range. Parent (Suspect) nodes returned.
    • Parents and Children—Filter on parents (Suspects), then if any parents are returned, filter on its children
  7. Click Refresh. Records that fall in the range of the options and values are displayed. If no records fall in the range of the selected options and values, a message displays that no records were returned.