Create a View Query
Create a View query when you want to display information from a table or view.
To create a View type query:
- Click the New Record icon in the toolbar at the top of the form.
- Enter a name for the query in the Query Name field.
- Enter a title for the query in the Title field.
- Enter a description for the query in the Description field.
- Select View in the Type field.
- To make the query available to be assigned to a Work Center, select the Assignable in Work Center checkbox.
- Enter a view or table name in the Query Text field. You can also press F4 to select a table or view from a list.
- Click the Update Columns button. This will update the Columns tab with the columns in the selected view/table.
- Use the Columns tab to define how the columns should display in the Work Center. Press F1 in any of the fields on this tab for more information.
- Add parameters to the Parameters tab to restrict the records that the query returns. See Restricting Queries with Parameters.
- Associate the query with specific Work Center templates using the Associations tab. This limits what kinds of Work Centers users can add the query to. See About Associating Queries with Work Center Templates.
- Save the query.
- If you want to link the queries so that users can drill-through them on a Work Center, use the Links tab. See Creating Inquiries.
- Set security for the query using the About the VA Inquiry Security Form form.