Default Query Value

Trouble seeing the images? Right click on images and open in new tab to enlarge or zoom in on the page (Ctrl + mousewheel).

In this article we provide information and an example using the Default Query Value (DQV).

Why Use Default Query Value?

The Default Query Value is the value that is used when nothing is selected on a parameter.

Example: An IN parameter with the values 1, 2 and 3. None of them are selected during run time but the Default Query Value is set to ('1', '2', '3'). 

Video Tutorial:

Steps to Use Default Query Value

Important Notes: 

• Default values will have priority over Default Query value (default is set in the parameter wizard, therefore the value is not empty) 
• It is recommended to NOT have a Default Value if a Default Query Value is set.
• Reset on Search can be useful for clearing out any previously selected values.
• Default Query Value (DQV) does not observe the specified object identifier or IN statement structures (EXAMPLE: the parenthesis around the value). What is inserted into the Default Query Value is a one for one replacement in the SQL statement.

1. Open VDM and run your view.

2. Click on Parameters.

3. Add or modify a parameter.

OPTIONAL: Enable the Reset on Search option.

4. Set the values for the Default Query Value (DQV).

Note/Reminder: DQV does not observe the specified object identifier

5. Finish any other parameter modifications and then click off the selected parameter to save the changes.

6. Run the view without selecting any values and verify the Default Query Value being sent gets the desired results.

Selected Parameters at Run Time: None

Results: View ran for EmployeeID 1 and 3