About Creating Queries

You can create and maintain queries, which you can add to a Dashboard, PM, or SM Work Center.

You can create and maintain queries that allow you to view specific information from Dashboard, Project Management, Service Management, and/or Accounting Work Centers.

Queries can also be linked together to create inquiries. Inquiries are two or more queries that are linked together so that users can drill-through from one query to another. See Creating Inquiries for information on creating inquiries.

You can add queries and inquiries to Work Centers so that they display specific information. For example, you can write your own SQL SELECT statement and then add that query to a Work Center. For more information about adding queries to a Work Center, see PM Work Center Overview.

About Choosing the Type of Query to Create

Create a View query

Create an SQL Query

Create a Dispatch Query

Adding a Query to a Tab

About Adding the Related Items and Attachments Functionality to a Custom SQL Query