- About queries
Queries are customized searches of a HCL Compass database.
- About query filters
Add filter definitions to queries to select only those database records that meet the criteria you define.
- Querying across multiple record types
The first step in creating a query is to select a record type. You can only select one record type from the list.
- Creating and running queries
Create queries to retrieve records in a user database. You can create a query for any record type that is defined in HCL Compass Web.
- Editing queries
You can modify the filters and display fields of a query.
- Running queries
Queries are stored in Workspace folders. You can run any query in any folder that you have access to.
- Bookmarking records, queries, reports, or charts
You can create a bookmark in your browser for a record, query, data-push report, or data-push chart that you work with frequently.
- Adding records, queries, reports, or charts to HCL Compass Favorites
You can create a HCL Compass Favorite for a record, query, traditional data-push report, or traditional data-push chart that you work with frequently.
- Sending the Web address of a query, report, or chart by e-mail
You can provide other users direct access to the results of a query, data-push report, or data-push chart by sending a URL by e-mail.
- Running recent records, queries, reports, and charts again
HCL Compass Web keeps a history of recently run records, queries, data-push reports, and traditional data-push charts during your current user session so that you can run them again.
- Configuring startup queries, reports, or charts
You can configure HCL Compass Web to run a startup query, data-push report, or data-push chart each time you log in to a user database. Only one startup query, report, or chart can be set.
- Clearing startup queries, reports, or charts
You can stop a particular query, data-push report, or data-push chart from running when HCL Compass starts up.
- Working with result sets