Creating a SQL View for an Alternate View

If you want to restrict the records (rows) that display in a list window, you can create a SQL view on which you base your alternate view.

If you do not have fundamental SQL knowledge, do not attempt to create SQL views.

Before you can create the SQL view, you need to know the table from which the standard view is built. You can find the name of the table on the first page of the view in the Table Name field. Once you create the SQL view, you replace the table name on the first page of the alternate view with the name of the SQL view you created.

To create a SQL view for an alternate view

1 Open an SQL query tool, such as SQL Advantage or ISQL.
2 Connect to the correct server and database.
3 Enter a query to create the new SQL view.

For example, if you want to display only those item records with the collection of “per” (periodical), you may enter a query like this:

4 Execute the query.

Important: If the function associated with the SQL view slows down dramatically, this may mean that there is a problem with the SQL view definition. In this case, you can run DBDBUG to see if accessing the SQL view in Horizon causes a table scan.

Once you have created the SQL view for the alternate view, you need to enter the name of the SQL view in the Table Name field on the first page of the view:

For information on this page of the view, see Specifying General Properties.

 


© 1998-2017 Sirsi Corporation