These settings allow you to identify special fields within the SQL statement that Perceptive Search will use for extra handling.
You can set the following options:
Title column
Specifies the field to use as the Perceptive Search document title in the index. By default, the first column with a string data type will be selected.
Changed record identifier
Perceptive Search will use this value to decide if a record has changed since it was lasted indexed. You can select either Calculated, which will look for changes in any field, or choose from among the fields you have selected.
Order by
Specifies the order in which to add documents to the Perceptive Search index. You can select either Default Order, which results in the order that the records are returned from the database system, or choose from the fields you have selected.
Click Next to proceed to Review.