Using the Reset on Search Option in VDM

Trouble Viewing Images? Right-click on any image and select "Open in new tab" to view a larger version. You can also zoom in using Ctrl + Mouse Wheel for easier readability.

Article Goal

Demonstrate how to enable and use the Reset on Search property for parameters in VDM to prevent unwanted values from persisting during repeated view execution.

What is Reset on Search?

Reset on Search is a parameter-level option in VDM that clears previously selected parameter values each time the view is re-run. This provides a clean slate for every execution.

Why Use Reset on Search?

Without Reset on Search enabled, parameters from a previous query execution may persist, potentially causing inaccurate or unintended query results—especially when using logical conditions like OR.

Example Scenario:

If an "OR" condition exists in your query and the prior parameter values aren’t cleared, they may carry over and affect your current query logic, producing incorrect data results.

Steps to Enable and Use Reset on Search

Step 1: Open VDM and Run Your View

Start VDM and open the View that requires parameter management.

Step 2: Open the Parameters Panel

Click on the Parameters button from the main interface to add or edit parameters.

Step 3: Add or Modify a Parameter

Select an existing parameter or add a new one where you want to apply the Reset on Search setting.

Step 4: Enable Reset on Search

Check the Reset on Search option for the selected parameter.

Tip: This setting is most useful for views where parameter context changes frequently or when testing different values rapidly.

Step 5: Run the View

Execute the view once with your desired parameter inputs.

Step 6: Re-run with Different Parameters

Re-run the view again. The previous selections should now be cleared, prompting a new parameter input.

Note: If the option is not enabled, VDM will remember the last used values and prefill them during subsequent runs of the same session.

Example Output

Article Summary

The Reset on Search parameter property in VDM ensures clean query execution by clearing previously selected values each time the view is run. It's especially helpful when testing or using complex filter logic, preventing stale parameter data from interfering with the current run.