SSA-NAME3 API Reference Guide

10.5 HotFix 3
- 10.5 HotFix 2
- 10.5 HotFix 1
- 10.5
- 10.2 HotFix 1
- 10.2
- 10.1 HotFix 1
- 10.1
- 10.0 HotFix 1
- 10.0

Back Next

Example

We have a search where we want to find records with the same Telephone Number or records with no Telephone Number. If we have a composite key that includes the Telephone Number then it will not find the record where the number is missing unless we add a range.

When building the index we can use:

FIELD=Person_Name,Telephone_Number

This will build composite keys using two fields,

Person_Name

and

Telephone_Number

At search time we add the keyword to build the NULL range for

Telephone_Number

so that a range will be built with a NULL value.

FIELD=Person_Name,Telephone_Number NM3KEYWORDS=Telephone_Number:INSERTNULLCLOSINGRANGE

Without the

NM3KEYWORDS

control and

INSERTNULLCLOSINGRANGE

records with no Telephone Number will not be found.

The

Person_Name

part of the composite key will not be the NULL key - that can be added using

INSERTNULLCLOSINGKEY

. To avoid the range where all parts of the composite key are the NULL key you can use the

NONULLKEY=Y

control.

Useful Key and Range Keywords for Composite Keys

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

SSA-NAME3 API Reference Guide

SSA-NAME3 API Reference Guide

Example

Example