Editing a query as SQL text

To edit a query as SQL text, you must have the SQL Editor privilege.
When you create a query, it is stored as a set of ClearQuest® parameters. To edit a query as SQL text, you must first convert it. Once converted, you cannot revert the query to the parameter form.

To edit a query as SQL text:

  1. Convert the query to SQL text. In the Navigator view, right-click the query name and click SQL > Convert to SQL Query.
  2. Edit the SQL query text.
    1. In the Navigator view, right-click the query name and click SQL > View SQL. The SQL text appears in the SQL Query view.
    2. Click Edit SQL Query on the view toolbar.
  3. When you are done, click Save.
Related concepts
About queries
About query filters
Related tasks
Creating and running a query
Editing a query
Running a query
Setting a query to run at startup
Importing a query
Exporting a query or query results

Feedback