Community Component 25.1
Community Component Help

# Fields whose Values Match Specific Terms or Phrases

You can use the following field specifiers (case sensitive) to return documents in which specified fields contain specified terms or phrases.

## TERM

The `TERM` field specifier (case sensitive) allows you to find documents with a specified field whose value contains a conceptual match for one or more terms that you specify. A conceptual match exists if a term you specify matches a term in a specified field after it has been stemmed.

NOTE: If the language that you use does not match the `DefaultLanguageType` specified in the Content component configuration file, add the `LanguageType` parameter to your query action (see Specify the Language Type of a Query).

    FieldText=TERM{yourTerms}:yourFields

where:

`yourTerms` | is one or more terms. A document returns only if one of `yourFields` contains a value that includes a term which conceptually matches of one of the specified terms. To specify multiple terms, separate them with commas (there must be no space before or after a comma). `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 a term in this field conceptually matches one of `yourTerms`. To specify multiple fields, separate them with colons (there must be no space before or after a colon).

Examples:

    FieldText=TERM{shopping,centers}:DRETITLE

The `DRETITLE` field must contain a term that conceptually matches shopping or centers for the document to return. For example, if the `DRETITLE` field has the value shop the document returns, but if it has the value bookshopping, it does not return.

    FieldText=TERM{training,football}:ITEM:PRODUCT

The `ITEM` or `PRODUCT` field must contain a term that conceptually matches trainers or football for the document to return. For example, if the `ITEM` or `PRODUCT` field has the value train or footballers, the document returns, while if it has the value trainer or soccer, it does not return.

## TERMALL

The `TERMALL` field specifier (case sensitive) allows you to find documents with a specified field whose value contains conceptual matches of several terms that you specify. A conceptual match exists if the terms that you specify match terms in a specified field after they have been stemmed.

NOTE: If the language that you are using does not match the `DefaultLanguageType` specified in the Content component configuration file, add the `LanguageType` parameter to your query action (see Specify the Language Type of a Query).

    FieldText=TERMALL{yourTerms}:yourFields

where:

`yourTerms` | is multiple terms. A document returns only if one of `yourFields` contains a value that includes terms which conceptually match the specified terms. Separate the terms with commas (there must be no space before or after a comma). 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 a term in this field conceptually matches one of `yourTerms`. To specify multiple fields, separate them with colons (there must be no space before or after a colon).

Examples:

    FieldText=TERMALL{shopping,centers}:DRETITLE

The `DRETITLE` field value must contain a term that conceptually matches shopping or centers for the document to return. For example, if the `DRETITLE` field has the value town center shop, the document returns.

    FieldText=TERMALL{walk,climb}:DRETITLE:TITLE

The `DRETITLE` or `TITLE` field value must contain a term that conceptually matches walking or climbing for the document to return. For example, if the `DRETITLE` or `TITLE` field has the value hill walking and rock climbing, the document returns.

## TERMEXACT

The `TERMEXACT` field specifier (case sensitive) allows you to find documents with a specified field that contains an exact match of any of the terms that you specify.

NOTE: If the language that you are using does not match the `DefaultLanguageType` specified in the Content component configuration file, add the `LanguageType` parameter to your query action (see Specify the Language Type of a Query).

    FieldText=TERMEXACT{yourTerms}:yourFields

where:

`yourTerms` | is one or more terms. A document returns only if one of `yourFields` contains a value that exactly matches one of the specified terms. To specify multiple terms, separate them with commas (there must be no space before or after a comma). 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 this field contains an exact match of one of `yourTerms`. To specify multiple fields, separate them with colons (there must be no space before or after a colon).

Examples:

    FieldText=TERMEXACT{help,helped}:DRETITLE

The `DRETITLE` field value must contain the term help or helped for the document to return. For example, if the `DRETITLE` field has the value helps or helping, the document does not return.

    FieldText=TERMEXACT{Word,Excel}:FILE:DATEI

The `FILE` or `DATEI` field value must contain the term Word or Excel for the document to return. For example, if the `FILE` or `DATEI` field has the value WordPerfect, the document does not return.

## TERMEXACTALL

The `TERMEXACTALL` field specifier (case sensitive) allows you to find documents with a specified field that contains an exact match of all terms that you specify.

NOTE: If the language that you are using does not match the `DefaultLanguageType` specified in the Content component configuration file, add the `LanguageType` parameter to your query action (see Specify the Language Type of a Query).

    FieldText=TERMEXACTALL{yourTerms}:yourFields

where:

`yourTerms` | is multiple terms. A document returns only if one of `yourFields` contains exact matches of the specified terms. Separate the terms with commas (there must be no space before or after a comma). 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 this field contains an exact match of all `yourTerms`. If you want to specify multiple fields, separate them with colons (there must be no space before or after a colon).

Examples:

    FieldText=TERMEXACTALL{rabbits,eating,carrots}:DRETITLE

This query returns only documents whose `DRETITLE` field contains all the specified terms (in their specified form). For example, a document whose `DRETITLE` field has the value Rabbits like eating carrots, or The carrots were there but the rabbits ate all the cabbage, returns as a result, but a document with a field that contains Rabbits like to eat a carrot each day does not return.

    FieldText=TERMEXACTALL{flour,milk,eggs}:DRETITLE:TITLE

This query returns only documents whose `DRETITLE` or `TITLE` field contains all the specified terms (in their specified form). For example, a document whose `DRETITLE` or `TITLE` field has the value Most cake recipes include milk, eggs and flour return as a result, but a document with a field that contains Use a cup of milk, two cups of flour and one egg does not return.

## TERMEXACTPHRASE

The `TERMEXACTPHRASE` field specifier (case sensitive) allows you to return documents in which a specified field contains an exact match of a phrase specified by you. Content component matches your phrase before it applies stemming (it does not remove stop words). It ignores any punctuation in the specifier or field.

NOTE: If the language that you are using does not match the `DefaultLanguageType` specified in the Content component configuration file, add the `LanguageType` parameter to your query action (see Specify the Language Type of a Query).

    FieldText=TERMEXACTPHRASE{yourPhrase}:yourFields

where:

`yourPhrase` | is a phrase. A document returns only if one of `yourFields` contains an exact match of the specified phrase.
`yourFields` | is one or more fields. A document returns only if it contains one of these fields, and if this field contains an exact match of `yourPhrase`. If you want to specify multiple fields, separate them with colons (there must be no space before or after a colon).

Examples:

    FieldText=TERMEXACTPHRASE{Batman! and Robins}:FILM

A document whose `FILM` field contains Showing now, Batman and Robin's film, returns as a result, but a document whose `FILM` field contains Showing now, 'Batman and Robin' the movie does not return.

    FieldText=TERMEXACTPHRASE{gift horse }:DRETITLE:TITLE

A document whose `DRETITLE` or `TITLE` field contains looking a gift horse in the mouth returns as a result, but a document whose `DRETITLE` or `TITLE` field contains the gift horse's mouth had rotting teeth does not return.

## TERMPHRASE

The `TERMPHRASE` field specifier (case sensitive) allows you to return documents in which a specified field contains a conceptual match of a phrase that you specify. Content matches your phrase after it applies stemming (it does not remove stop words). It ignores any punctuation in the specifier or field.

NOTE: If the language that you are using does not match the `DefaultLanguageType` specified in the Content component configuration file, add the `LanguageType` parameter to your query action (see Specify the Language Type of a Query).

    FieldText=TERMPHRASE{yourPhrase}:yourFields

where:

`yourPhrase` | is a phrase. A document returns only if one of `yourFields` contains a conceptual match of the specified phrase.
`yourFields` | is one or more fields. A document returns only if it contains one of these fields, and if this field contains a conceptual match of `yourPhrase`. If you want to specify multiple fields, separate them with colons (there must be no space before or after a colon).

Examples:

    FieldText=TERMPHRASE{Batman! and Robins}:FILM

A document whose `FILM` field contains Showing now: 'Batman and Robin', returns as a result.

    FieldText=TERMPHRASE{gift horse }:DRETITLE:TITLE

A document whose `DRETITLE` or `TITLE` field contains the gift horse's mouth had rotting teeth returns.

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 whose Values Match Specific Terms or Phrases