View existing queries
The Queries page provides information about existing queries and enables you to define new queries. For the selected project and data configuration, the Queries page lists queries that you have created or that are published to you. If you have the Administer Users permission, the page also lists unpublished queries created by any users in your login group.
What you can do next
- To view, print, or download the table, or to change the way data displays in the table, see About tables.
- To print, download, or delete multiple queries, click Select Rows. Select the check box for one or more rows or click the Select All link to check all rows (or Clear All to uncheck all rows). Then click Print, Download, or Delete.
- To create a query using the built-in Query Wizard, click the Create Using Query Wizard link.
- Click a query's Row Action menu (
), to do the following:
- To run the query, click Run and select a data configuration.
- To run the query and create a case series from the query results, click Create Case Series. You select a data configuration, review variables and values, and optionally change the name, description, and project assignment before saving the case series.
- To view the query logic, click View. This option shows the variables and values that make up the query, as well as the logic.
- To run the query and then run a report against cases found by the query, click Report and select a data configuration. After you run the query, the Report Definitions page appears.
For queries you created, click a query's Row Action
menu () to do the following:
- To copy a query, click Copy. Then provide a name for the copy and save it.
- To edit the query, click Edit. You can click Back to select a different data configuration.
- To rename the query, click Rename. You can also change its description or assign it to a different project.
- To publish a query, click Publish, select
the login group(s), then click Back. (If you have the
Administer Users permission, you can publish configurations created by any user
in your login group.)
Tip:
- If you are a superuser and the object is not multi-enterprise support-related, you can publish to multiple login groups, including —All—. From the Publish to Login Groups list, select one row and hold Ctrl+ left click to select more rows.
- If you publish to —All— and later add a new login group, the object is published automatically to the new login group.
- If you are a superuser and the object is multi-enterprise support-related, then you can only publish to the object owner’s login group.
- To run the query and then run a report against cases found by the query, click Report and select a data configuration. After you run the query, the Report Definitions page appears.
- To delete a query, click Delete. At the message asking if you want to delete the query, click OK. The query is deleted and no longer appears on the Queries page.
Note:
Editing or deleting a query has no effect on any case series, database restrictions, custom terms, or interactive reports that were created using the query.Parent topic: Query the safety database