Folder field types

The following table lists the folder field types supported by Content Manager OnDemand.

Field Type

Description

Annotation Color Search

Use to search annotations to a document by specifying a color. A match occurs and an item is added to the document list if the color of the text in one or more annotations to the document is the same as the color specified in the search field. The search is run on the server. You can define one annotation color search field per folder.

Annotation Text Search

Use to search annotations to a document for the specified string. A match occurs and an item is added to the document list if one or more annotations to the document contain the text specified in the search field. The search is run on the server. You can define one annotation text search field per folder.

Application Group

For a folder search field, contains a list of the application groups that can be searched from the folder, allowing users to limit a search to one application group in a folder. For a folder display field, lists the name of the application group in which the document was found. You can define one application group field per folder.

Big Int

Contains whole numbers between -9223372036854775808 and 9223372036854775807.

Decimal

Contains numbers between 10(307) and 10(308) with up to 15 significant digits.

Date Contains a valid date from January 1, 0001 to December 31, 9999.

Date (old style)

Contains a valid date from January 1, 1970 to December 31, 2058.

Date/Time Contains a valid date from January 1, 0001 to December 31, 9999.

Date/Time (old style)

Contains both a date and time value. The date can be from January 1, 1970 to January 18, 2038. The time is stored in one second increments.

Date/Time (TZ) Contains a valid date from January 1, 0001 to December 31, 9999.

Date/Time (TZ) (old style)

Contains both a date and time value. A Date/Time (TZ) field is exactly like a Date/Time field, but uses the time zone from the client.

DecFloat (16)

Decimal floating-point number with 16 digits of precision.

DecFloat (34)

Decimal floating-point number with 34 digits of precision.

Document Type

Used to show the document type in the document list.

Full Text Index Highlight

Search documents for highlighted indexed content. The results are returned in the Document hit list.

Full Text Index Search

Search documents for indexed content. The results are returned in the Document hit list. The Full Text Index Search field is available as a queryable field only.

Full Text Index Score

Search documents for scored indexed content. The results are returned in the Document hit list.

Full Text Index Summary

Search documents for the summary of indexed content. The results are returned in the Document hit list.

Hold

For a folder search field, contains a list of the holds that can be searched from the folder, allowing users to limit a search to documents that are in the selected hold. You can define one hold field per folder.

Integer

Contains whole numbers between -2147483648 and 2147483647.

Small Int

Contains whole numbers between -32768 and 32767.

String (Fixed)

Contains letters, numbers, special symbols, such as the % and #, and any other printable character.

String (Variable)

Contains letters, numbers, special symbols, such as the % and #, and any other printable character.

Time (old style)

Contains times of day, stored in three second increments, since midnight, and limited to 24 hours.

Segment

Contains a list of the tables of index data (segments) that are stored in the application groups that can be searched from the folder. Each item in the list represents a segment of application group data, allowing users to limit a search to one table of data. Content Manager OnDemand segments application group data by date. You can define one segment field per folder.

Text Search

Use to find documents that contain a non-indexed word or phrase. A match occurs and an item is added to the document list when one or more lines in a document contain the word or phrase exactly as specified. The sequential search is run on the server. You can define one text search field per folder. You can define a text search field for documents that have a data type of Line, PDF, AFP, SCS, SCS-Extended, and User Defined with an extension of PDF. See Text Search for more information.