Sorting and Filtering a Physical View

When you add table fields from a physical view to a logical model, it is often helpful to sort the physical view tables by name. To do this, click the 'Sort Tables' button on the View panel.

Click the button once to sort the tables in ascending order. Click again to sort in descending order. Click a third time to return to the original order. To jump to a specific sort order without cycling through all the options, click the right side of the button to expand the menu.

 

To quickly find tables of interest, you can also filter the list. To do this, click the 'Filter Visible Tables' button on the toolbar. This opens the 'Filter' dialog box.

 

Select 'Owned by user' to display only those tables that belong to the user's schema. Use the 'Type' menu to restrict the list to either 'Tables' or 'Views'.

To list only tables that match a specified pattern, select one of 'Search' options: 'Basic' allows you to use '*' as a wildcard, while 'Regular Expression' allows Perl 5 regex syntax.

<< Detecting Model Validity Problems © 1996-2013 InetSoft Technology Corporation (v11.4) Customizing the Browse Data List >>