User Guide

Chapter 282
Creating a Query
Create a query. From Asset Center, click Add Assets and choose Queries. Then
click New. The SQL Query dialog opens where you can use SQL Wizard to create
the query. The query results are used to generate the product pages.
Click Save Query. The Query Manager opens, click Create Table. Doing this
creates an ODBC Content Table. You can view the content table in Content
Center. Choose the query name from the Content Table list. The Content Table is
a visual representation of the products query. The figure shows the sample
database populated with sample product information.
If you need step-by-step instruction on how to create a query and an ODBC
Content Table, check the index of the Drumbeat User’s Guide or Help for the
words in bold.
Now you are ready to run DataForm Wizard. The following example, creates two
products pages, one of which lists the product items with links to the product
detail pages for each item.