Index Field Types
Details of index field types that can part of an unstructured text index.

Index Field Types

Data in the Haven OnDemand text index is stored in fields. The fields can have different types depending on the content of the field, and what the field is used for. This page describes the main field types and their uses.

Note: Field names in Haven OnDemand are not case sensitive. For example, the TITLE field name is equivalent to Title or title.

  • Reference. The Reference fields contain a document reference that identifies the document. This might be a file path or URL, or some other identifying content. You can use this field to retrieve a specific document.

  • Index. Index fields contain the majority of the document content. When the data is indexed, index fields receive additional processing, such as stemming and stop word removal, to make it easier to search the data. Typically, index fields contain text that you query frequently, such as the title and main body of a document. You can also use Query Text field restrictions for Index fields. See Field Restrictions.

  • Parametric. Parametric fields contain content for parametric (faceted) search and filtering. Typically, it contains a limited set of values to make it easier to filter content by a value. You can also use the MATCH field_text operator for Parametric fields. See Field Text Operators.

  • Numeric. Numeric fields contain a number. This field type makes it faster to search for specific numeric values, and also enables searching for ranges, or values near a specified number, by using numeric field_text operators. See Field Text Operators.

  • Date. Date fields contain a date, in one of the configured date formats. This field type makes it faster to search for dates, and enables searching for date ranges, or dates near a specified date, by using the date field_text operators. See Field Text Operators.

  • Rank. Rank fields contain an internal document rank, which you can use to order search results. Rank values are also used to bias the relevance sort order.

  • Store Only. Store Only fields contain any other type of data that does not have a special type. These fields generally contain values that you do not need to search for specifically, but which might be useful information, such as the content length.

  • Expire Date. Expire Date fields contain a date that Haven OnDemand uses to determine when to expire the document.

For information about the fields of each type available for the different text index flavors, see Index Flavors.

Date Formats for Date Fields

The following table describes the formats that you can use in your documents for fields that are configured as Date type:

Format Description Examples
SHORTMONTH D+ YYYY H+:N+#PM The short form of the month (for example, Jan, Feb), a day (one or two digits), a year (four digits), and a time in hours (one or two digits) and minutes (one or two digits), with AM or PM indicator. Mar 16 2015 12:37PM
Jul 6 1954 3:21AM
SHORTMONTH D+ YYYY The short form of the month (for example, Jan, Feb), a day (one or two digits), and a year (four digits). Mar 16 2015
Jul 6 1954
DD/MM/YYYY The day (two digits), month (two digits), and year (four digits), separated by forward slashes. 16/03/2015
06/07/1954
YYYY/MM/DD The year (four digits), month (two digits), and day (two digits), separated by forward slashes. 2015/03/16
1954/07/06
YYYY-MM-DD The year (four digits), month (two digits), and day (two digits), separated by dashes. 2015-03-16
1954-07-06
AUTNDATE The Haven OnDemand date format (one to a maximum of 10 digits). This format uses Unix time for the epoch range (Jan 1 1970 to Jan 19 2038), and it also covers dates between 30 October 1093BC and 26 October 3058 to a resolution of one minute. Dates outside of this range are stored with values that allow them to be sorted correctly. 1426509420 4286754441