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.

1. In the left navigation pane, hover on the Data Analysis icon (), then click Queries.
2. Filter the list of your queries and queries published to you as necessary.
   • From the Project drop-down list, select the project for which you want to view queries or -- to include all projects.
   • From the Configuration drop-down list, select the data configuration for which you want to view queries or -- to include all configurations.
   • From the Origin drop-down list, select the origin of the queries you want to view; select -- to include all types.

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.)
  • To publish multiple queries, click the Select Rows link, select the radio buttons of the queries, then click the Publish link.
  • If you are a superuser, you can publish to multiple login groups, including —All–. In the Publish to Login Groups drop-down list, click or Ctrl+click to select login groups. If you publish to —All– and later add a new login group, the object is published automatically to the new 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.