Open topic with navigation

# 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 `*`) then the `NOTWILD` field specifier acts in the same way as the NOTMATCH field specifier.

NOTE:

You can optimize the field specifier speed by restricting the field to the `MatchType` property type.

## Format

    FieldText=NOTWILD{yourStrings}:yourFields

`yourStrings` | One or more strings containing wildcards. A document returns only if at least one instance of one of `yourFields` does not contain any of these strings. You can specify strings that contain punctuation (but see Note) or consist of several words. NOTE: To distinguish query syntax punctuation from punctuation within strings, double-percent-encode commas and curly braces within strings. Query syntax punctuation must be left unencoded. There must be no space before or after a separator comma.
`yourFields` | Type 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`. Separate multiple fields with colons (`:`). There must be no space before or after a colon.

## 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"

Then it is not returned as a result.

However, if the document contains:

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

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

NOTE:

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.

## See Also

- MATCH Field Specifier

- WILD Field Specifier

© 2018 EntIT Software LLC, a Micro Focus company | Send documentation feedback to Micro Focus Close Send documentation feedback To open the configured email client on this computer, open an email window. Otherwise, copy the information below to a web mail client, and send this email to swpdl.idoldocsfeedback@microfocus.com. We appreciate your feedback! Product: Topic Title: Help Topic: Feedback:

_FT_HTML5_bannerTitle.htm