About Choosing the Type of Query to Create

If none of the standard Vista queries meet your needs, you can create your own.

There are several types of queries:

  • View - Use this type of query to display information from a table or view. This is the easiest type of query to create because you don't need to know SQL to create one.
  • SQL - Use this type of query to create a full SQL statement. You must have an understanding of SQL to create this type of query. If you don't know SQL, use a standard query or create a View query.
  • Dispatch - This type of query (standard or custom) is used with the Service Management Dispatch Board to filter work orders based on specific criteria. For example, the "SMDispatchWorkOrdersOverdue" query displays work orders having one or more scopes where the Due Date has passed and no trips have been created.
  • Form - These are system queries that allow you to add a query to a custom tab on a form. You cannot create new form queries. For more information, see Adding a Query to a Tab.