4.5.3 Editing a Query

To edit an existing query, follow the steps below:

1. Open the Asset panel, and expand the 'Data Source' node.

2. Expand the data source that contains the query you want to modify.

If you make a change to the structure of the database schema, press the 'Refresh Metadata' button on the toolbar to update the query.

3. Double-click the query. This opens the query for editing.

 

The query editor is organized using the same tabs as the 'New Query' dialog box: Links, Fields, Condition, Sort, and Grouping at the top, and SQL String at the bottom. See Creating a New Query and Editing a Query SQL String for instructions on using these tabs.

To view the results returned by the query, click the Preview tab at the bottom of the editor.

<< 4.5.2 Creating a Derived Query © 1996-2013 InetSoft Technology Corporation (v11.4) 4.5.4 Editing a Query SQL String >>