2.4.10  Suppressing Query Execution in Design View

Note: If you press the 'Cancel' button in the Viewsheet loading dialog box, the Views­heet is automatically displayed in meta-data mode.

The design view for a Viewsheet is intended to simulate the functional Viewsheet as closely as possible, including all data representation and interactivity. However, when a Viewsheet relies on large or complex queries, retrieval of data from the database at design time can introduce unnecessary delays into the design process. In such cases, it is convenient to suppress the execution of queries in the Viewsheet design view and instead display only meta-data.

To manually suppress execution of queries in the design view, follow the steps below:

1. Click the 'Options' button in the Visual Composer toolbar. This opens the 'Viewsheet Options' dialog box.

2. Select the 'Use Metadata' option, and click 'OK'.

 

With 'Use Metadata' enabled, data-view and selection components in the design view display query meta-data rather than the query result set.

 

<< 2.4.9 Limiting Data Retrieved by a Viewsheet © 1996-2013 InetSoft Technology Corporation (v11.5) 2.4.11 Suppressing Parameter Prompting >>