Specify columns to include in the search index. Optionally, specify the columns for the record header in the search results.
Select an application version and a table.
Click
View
Constraints
.
Click the
Columns
tab.
A list of all the columns in the table appears.
Enable the
Index for Search
field for each column you want to add to the search index.
Click the
Constraints
tab.
Click the add icon to add a constraint.
A row appears with the name
NEW CONSTRAINT
.
Double-click the
Name
field and enter a name.
Optionally, to specify a column name as the record heading on the results page, click the
Type
field and select
Search Header
.
If you do not specify a column for the record heading, Data Archive uses the column name of the primary key. In the absence of a primary key, Data Archive uses the row ID for the record heading.
Enable the
Enabled
field.
Click the add icon in between the Child Table Columns and Parent Table Columns sections of the Constraints tab.
A row appears in the Child Table Columns section.
Click the
Type
field and select
Column
.
Click the
Name
field and select a column.
To add more columns to the record header, repeat steps
10 to
12.