IDOL Community Component 23.2

# Fields that Contain a Specified String

You can use the following field specifiers (case sensitive) to return documents with fields that contain a specified string.

## STRING

The `STRING` field specifier (case sensitive) allows you to specify one or more strings, of which one must be contained as a substring in a specified field.

    FieldText=STRING{yourStrings}:yourFields

where:

`yourStrings` | is one or more strings. A document returns only if one of these strings is a substring of the value in one of `yourFields`. `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 this field contains one 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).

Examples:

    FieldText=STRING{cat,dog}:ANIMAL

The `ANIMAL` field value must contain the substring cat or dog for the document to return. For example, if the `ANIMAL` field has the value scattering, the document returns.

    FieldText=STRING{old cat}:ANIMAL:TOPIC

The `ANIMAL` or `TOPIC` field value must contain the substring old cat for the document to return. For example, if the `ANIMAL` field has the value old cat, old caterpillar, or bold cats, the document returns.

    FieldText=STRING{example.com}:COMPANY

The `COMPANY` field value must contain the substring example.com for the document to return. For example, if the `COMPANY` field has the value example.com or http://www.example.com/content/home, the document returns.

    FieldText=STRING{a\,b}:MISC

The `MISC` field value must contain the substring a,b for the document to return. For example, if the `MISC` field has the value a,b or a,b,c, the document returns.

## STRINGALL

The `STRINGALL` field specifier (case sensitive) allows you to specify one or more strings, which must all be contained as a substring in a specified field.

    FieldText=STRINGALL{yourStrings}:yourFields

where:

`yourStrings` | is one or more strings. A document returns only if all these strings are substrings of the value in one of `yourFields`. If you want to specify multiple strings, separate them with commas (there must be no space before or after a comma). `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 this field contains `yourStrings` as substrings. If you want to specify multiple fields, separate them with colons (there must be no space before or after a colon).

Examples:

    FieldText=STRINGALL{cat,dog}:ANIMAL

The `ANIMAL` field value must contain the substrings cat and dog for the document to return. For example, if the `ANIMAL` field has the value grooming cats and dogs or doggedly scattering seeds, the document returns.

    FieldText=STRINGALL{old cat,young dog}:ANIMAL:TOPIC

The `ANIMAL` or `TOPIC` field value must contain the substrings old cat and young dog for this document to return. For example, if the `ANIMAL` field has the value old cat chases young dog, or young doggedly chasing bold cats, the document returns.

    FieldText=STRINGALL{a\,b,e\,f}:MISC

The `MISC` field value must contain the substrings a,b and e,f for this document to return. For example, if the `MISC` field, for example, has the value a,b,c,d,e,f or 0=e,fx 1=da,ba, the document returns.

## SUBSTRING

The `SUBSTRING` field specifier (case sensitive) allows you to return documents whose field value is a substring of a specified string (or equal to a specified string).

    FieldText=SUBSTRING{yourStrings}:yourFields

where:

`yourStrings` | is one or more strings. A document returns only if one of `yourFields` contains a substring of one of the specified strings. If you want to specify multiple strings, 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 the value in this field is a substring of `yourStrings`. If you want to specify multiple fields, separate them with colons (there must be no space before or after a colon).

Examples:

    FieldText=SUBSTRING{Telecommunications,Technology}:SECTOR

The `SECTOR` field must contain a string that is a substring of Telecommunications or Technology. For example, if the `SECTOR` field has the value Telecom or Technology, the document returns. If the `SECTOR` field has the value Latest Technology, the document does not return.

Copyright 2023 Open Text
Version 23.2 | Last updated March 2023

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 swpdl.idoldocsfeedback@microfocus.com.

We appreciate your feedback!

Product: IDOL IDOL Community Component 23.2

Topic Title: Fields that Contain a Specified String