Basic Tab (Table/New Table Dialog Box)
Use this tab to define the fields in a model.
Options
Capitalization
Specify the case in which the data was entered.
The effect of using this option depends on whether the Add values of this entity to the model check box is selected.
- For all values of Capitalization other than Unknown:
- Regardless of how the user types in the data value in the question, the SQL statement generated by English Query matches the capitalization values. For example, if the user asks, "Who sold the most widgets," and the capitalization on the product_name field is "UPPERCASE", then the SQL statement will contain
product_name = 'WIDGET'. An exception to this can occur when the values of product_name are loaded into the model. If there are any data values that violate the capitalization convention, these are memorized so that the correct capitalization will be used in the SQL statement.
- For capitalization that is Unknown:
- The capitalization in the SQL statement generated by English Query matches the user's capitalization exactly, whether or not the data values have been loaded into the model. For example, if the user asks, "How many awards did Gone With the Wind win," the SQL statement is movie_name = 'Gone With the Wind'. When users are unlikely to know the correct capitalization to use, pick the closest capitalization value other than Unknown, and load values of the entity into the model so that the capitalization is memorized by English Query.
If you do not know how the data was entered or the data is inconsistently capitalized, select the Unknown check box.
Date Type
Specify the date type of the data in the field, if any.
- Integer Year, Integer Month, Integer Quarter, and Integer Day
- Use if the field containing a year, month, quarter, or day is a number (for example, 2000).
- 2 Digit Year
- Use if the field contains the last two digits of the year (for example, 99).
- 3 Letter Month
- Use if the field contains a month in String format (for example, Mar). Not available for Integers.
- Month or Quarter Name
- Use if the field contains a month or quarter in String format (for example, March). Not available for Integers.
Name Structure
Specify the type of name data contained in the field, if any.
For example, in the last two selections, [Middle] indicates that the middle name is optional. If the structure does not match any of the options, choose None.
Search Type
Specify the type of search to perform by default on the field when a user enters a question.
- Exact Match
- Default if the field is not full-text indexed. Display the field that matches exactly, including capitalization. For example, "where is the restaurant named Bento" would find a restaurant named Bento but not The Bento Box, Bento Express, or Tachibana Bento.
- Contains
- Display all rows with fields that have words that include the specified word or letters. For example, "Where is the restaurant named Bento" would find The Bento Box, Bento Express, and Tachibana Bento.
- Prefix
- Display all rows with fields that have words beginning with the letters indicated. For example, "where is the restaurant named Bento" would find Bento Express but not The Bento Box.
- Sounds Like
- Find rows with fields containing words that have the same sound. For example, "where is the restaurant named bentow" would find The Bento Box, Bento Express, and Tachibana Bento.
- Free Text
- Default if the Full-text indexed check box is selected for the field. Display all the rows with fields that approximately match the words or phrase specified. For example, "Display all of the books about how I can cook seafood Japanese style" would display Cooking Seafood New England Style, The Simple Art of Japanese Cooking, and Aunt Louise's Seafood Cookbook because it would find all books about seafood, Japanese, and cooking. Only available if you select Full-text indexed.
Units of Measure
Specify in singular, rather than plural, form the units of measure in which the field data, if any, is stored (for example, year, inch, or kilometer).
Field contains a fiscal year
Indicate if this field contains a fiscal year.
Full-text indexed
Default if the field is full-text indexed. Enable full-text searching for the field if the database supports full-text indexing.
Note This option is disabled if you are not using Microsoft® SQL Server™ version 7.0 or later, or if the field data type is not String or Text.
When using SQL Server to create a full-text index for a table, specify a unique key column to be stored in the index. Specify the same column as the
Clear this option to disable full-text searching, even if the field is full-text indexed.