Community Component 25.1
Community Component Help

# Fields that Do Not Contain a Specified Value

## NOTMATCH

The `NOTMATCH` field specifier (case sensitive) allows you to find documents in which at least one instance of the specified fields contains a value that does not match the specified string.

If there are one or more instances of a particular field in the document, the document returns as long as at least one instance does not contain any of the specified strings, even if another instance of the field does match. The document does not return if all instances of the specified fields contain an exact match of one of the specified strings.

    FieldText=NOTMATCH{yourStrings}:yourFields

where:

`yourStrings` | is one or more strings. A document returns only if at least one instance of one of `yourFields` contains a value that is not an exact match for these strings. The matching is case insensitive. `FieldText` queries which include commas and braces in the query have specific percent-encoding requirements. For information about percent-encoding, see FieldText.
`yourFields` | is one or more fields. A document returns only if it contains one of these fields, and if the value in at least one instance of the field does not exactly match any of `yourStrings`. If you want to specify multiple fields, separate them with colons (there must be no space before or after a colon).

For example:

    FieldText=NOTMATCH{cat}:ANIMAL

At least one instance of the `ANIMAL` field must have a value other than `cat` for the document to return as a result.

For example, if a document contains only:

    #DREFIELD ANIMAL="cat"

it does not return as a result.

However, if the document contains:

    #DREFIELD ANIMAL="cat"
    #DREFIELD ANIMAL="dog"

it returns as a result, because one of the `ANIMAL` fields does not contain the value `cat`.

If you want to find documents in which the specified string is not present in any instance of the specified field, use the `MATCH` specifier with the Boolean operator `NOT`. For example, `FieldText=NOT+MATCH{cat}:ANIMAL` does not return any documents that have an `ANIMAL` field with the value `cat`, even if there are other `ANIMAL` fields with different values.

Related Topics

- MATCH

## NOTSTRING

The `NOTSTRING` field specifier (case sensitive) allows you to find documents in which at least one instance of the specified fields contains a value that does not contain any of the specified strings as a substring.

If there are one or more instances of a particular field in the document, the document returns as long as at least one instance does not contain any of the specified strings, even if another instance of the field does contain the string. The document does not return if all instances of the specified fields contain one of the specified strings as a substring.

    FieldText=STRING{yourStrings}:yourFields

where:

`yourStrings` | is one or more strings. A document returns only if at least one instance of one of `yourFields` contains a value that is not a substring of any of these strings. `FieldText` queries which include commas and braces within the query have specific percent-encoding requirements. For information about percent-encoding, see FieldText.
`yourFields` | is one or more fields. A document returns only if it contains one of these fields, and if the value in at least one instance of the field does not contain any of `yourStrings` as a substring. If you want to specify multiple fields, separate them with colons (there must be no space before or after a colon).

For example

    FieldText=NOTSTRING{cat,dog}:ANIMAL:TOPIC

At least one instance of the `ANIMAL` or `TOPIC` field value must contain a value that does not contain the substring cat or dog for the document to return.

For example, if a document contains only:

    #DREFIELD ANIMAL="old cat"

or

    #DREFIELD TOPIC="dogs like playing catch "
    #DREFIELD ANIMAL="dog"

it does not return as a result.

However, if the document contains:

    #DREFIELD TOPIC="dogs have trouble catching mice"
    #DREFIELD ANIMAL="dog"
    #DREFIELD ANIMAL="mouse"

it returns as a result, because one of the `ANIMAL` fields does not contain the substring `cat` or `dog`.

If you want to find documents in which the specified string is not present in any instance of the specified field, use the `STRING` specifier with the Boolean operator `NOT`. For example, `FieldText=NOT+STRING{cat,dog}:ANIMAL` does not return any documents that have an `ANIMAL` field with the substring `cat` or `dog`, even if there are other `ANIMAL` fields with different values.

Related Topics

- STRING

## NOTWILD

The `NOTWILD` field specifier (case sensitive) allows you to find documents in which at least one instance of the specified field contains a value that does not match the specified Wildcard string.

If there are one or more instances of a particular field in the document, the document returns as long as at least one instance does not contain the specified string, even if another instance of the field does match. The document does not return if all instances of the specified fields contain the specified string.

If the query does not contain any Wildcard characters (? or *), the `NOTWILD` field specifier acts in the same way as the `NOTMATCH` field specifier.

    FieldText=NOTWILD{yourStrings}:yourFields

where:

`yourStrings` | is one or more strings that contain Wildcards. A document returns only if at least one instance of one of `yourFields` does not contain any of these strings. `FieldText` queries that include commas and braces in the query have specific percent-encoding requirements. For information about percent-encoding, see FieldText.
`yourFields` | is one or more fields. A document returns only if it contains one of these fields, and if the value in at least one instance of the field does not contain any of `yourStrings`. If you want to specify multiple fields, separate them with colons (there must be no space before or after a colon).

For example:

    FieldText=NOTWILD{passi*incarnata}:Climbers:Plants

At least one instance of the `Climbers` or `Plants` field must contain a value which does not contain a phrase that begins with `passi` and ends with `incarnata` (for example, `passionflower incarnata` or `passiflora incarnata`) for this document to return as a result.

For example, if a document contains only:

    #DREFIELD Climbers="passiflora incarnata"

or

    #DREFIELD Climbers="passiflora incarnata"
    #DREFIELD Plants="passionflower incarnata"

it does not return as a result.

However, if the document contains:

    #DREFIELD Climbers="passiflora incarnata"
    #DREFIELD Plants="passionflower incarnata"
    #DREFIELD Climbers="bindweed"

it returns, because one of the `Climbers` fields contains a value that does not match the Wildcard string `passi*incarnata`.

If you want to find documents in which the specified string is not present in any instance of the specified field, use the `WILD` specifier with the Boolean operator `NOT`. For example, `FieldText=NOT+WILD{passi*incarnata}:Climbers` does not return any documents that have a `Climbers` field with a phrase that begins with `passi` and ends with `incarnata`, even if there are other `Climbers` fields with different values.

Related Topics

- WILD

- MATCH

Copyright 2024 Open Text
Version 25.1 | Last updated January 2025

Send documentation feedback

Close

Send documentation feedback

To send feedback using your default email client, open an email window.

Otherwise, send your feedback and the information below to MFI-swpdl.idoldocsfeedback@opentext.com.

We appreciate your feedback!

Product: Knowledge Discovery Community Component 25.1

Topic Title: Fields that Do Not Contain a Specified Value