Adding extension fields and table columns

The Optiva administrator can configure the Search <Object> pages to include extension fields and extension table columns.

Symbol > Extensions tab
Extension Table Definition > Columns tab

This configuration is performed through two columns in the Symbol page and the Extension Table Definition page. These columns are described in the table.


Column	Value	Description
Search Ind	0 - Not Searchable 1 - Searchable 2 - Searchable - Using SubCode	Specifies whether the extension table field or extension table column is visible in the Search <Object> page. The Searchable - Using SubCode choice pertains only to fields that have sub-coded validation entries. Parameters (`TPALL`) are one example of sub-coded validation entries. When the search criteria is built, the `@DFLT` entry is always used to find the appropriate sub-coded validation entry. Then, the data type from the sub-coded validation entry is used to perform the appropriate data conversion. For example, a parameter value (`PValue`) can be converted to a numeric value.
Search Style	0 - Standard 1 - Range 2 - Multi-Select	Specifies the format of the searchable column. This column is not relevant if the value of the Search Ind column is Not Searchable. The Standard choice formats the searchable column so that you can only specify one value: Text box for string or numeric type fields Drop-list for enumerated lists or enumerated query type fields Calendar control for date type fields Lookup type fields The Range choice shows the criteria fields for a minimum value and a maximum value. Used for date and numeric type fields. The Multi-Select choice formats the searchable column so that you can specify multiple values. Used only for fields that are associated with an enumerated list or enumerated query Multi-select text box for enumerated list or enumerated query type fields Note: Multi-select is not supported for Lookup type fields. The `OR` logic is used to search for the selected values.