Running Queries

Once you've completed adding, modifying, and/or arranging the objects corresponding to the data you want to include in the document, run the query by clicking the Run Query button.

If you're using the Full Java applet or ActiveX control Web Panel, you can cancel the query at any time by clicking the Cancel Query button at the bottom right of the Panel.

When you run a query, the Web Panel submits the query to the WebIntelligence server, which processes the query, retrieves the data from the database, and builds the document. The browser fetches the resulting document from the server and displays it in the Document Results page.

Note: If you then decide to re-edit the document, and you make changes that concern formatting only, click the Apply Format button instead. This button applies formatting changes to the document using the existing data.
If you subsequently change any of the data needed for the document, however, the Apply Format button is no longer available in the Web Panel, and you must click the Run Query button again.

If when you try to run a query, the Web Panel doesn't immediately submit the document to the WebIntelligence server, there may be an ambiguous context, or a condition requiring you to fill in information. For information about dealing with these situations, see Resolving Context and Resolving Condition Prompts.

Note: If you want to save the query you have defined without running it. Click Save and Close. The report is saved with no data. You can retrieve the data and run the query by using the Refresh command.

Saving the Definition of a Query

You can build a query without having to run it right away. The Save and Close feature lets you:

• Save a query so that you can continue defining it at a later stage.
• Save a query that you have finished defining, but that you do not want to run right away, for example because you know network traffic is heavy. 

  To build a query and save its definition:

  1. Build a query by moving objects into the Result Objects and Conditions boxes in the Query Panel.
  2. Click Save and Close.
  
  The following message displays: “This report was saved with no data. Click Refresh to retrieve the data.”
  3. To run the query and return the data to the report, click Refresh.

  Return to topic: Creating and Editing WebIntelligence Documents