Extension tables example

The Optiva administrator can configure the search to include more than one extension table per symbol.

Optiva supports extension table searches for these objects: Item, Formula, Label Content, Project, Company, and Specification. The setup tasks and the search behavior are the same for these objects.

In this example, the Brand and Date columns are searchable columns for the C_FORMULA1 extension table. For a simple search, you can specify more than one brand, but you can only specify one date. The Line ID column is excluded from the Search Formula page.

In the Search Formula page, the Extension Tables section is shown in the Main tab. Users can specify Simple criteria or Advanced criteria in the Search Formula > Extension Tables tab. The behavior is the same as with other Simple and Advanced searches.