Modifying a Query Filter

The same JavaScript logic modifies a Results and a Query filter, except a query uses Process instead of Recalculate to update the data with the new filter value. Processing a query requires a database connection.

Example

Change the existing limit in the Limits Query section based on the drop-down selection. Use the Process method instead of the Recalculate method to update the query results.

ActiveDocument.Sections["Limits Query"].Process()

To test the script, a database connection is needed. Use Brio 6.0 Sample 1.oce. Leave the Host Name and Host Password blank.

The exercises in this section modified a limit according to a user’s selection. Variables were used to hold the user’s choice and to hold the object model path to the limit line object.