Table of Contents

Query Development - Test Parameters

you are here (click to zoom) - discover the stack

This is how to test your Query with Test Parameters:

The VisualQuery Designer also allows you to set test-values for testing the query. The test-values should define all the full tokens to replace. Example:

[QueryString:Id]=27
[QueryString:SortOrder]=Desc
[Params:FilterLastName]=Mettler
[Params:FilterNameSort]=[QueryString:SortOrder||Asc]

Here's an example:

You will find a full explanation of this here: Params LookUp in Query Parameters.

Tip

As you can see in the example, even test params can contain more tokens if you need them. In the above example, Params:FilterNameSort would resolve to Desc because it will first check the QueryString:SortOrder which also has a test-value of Desc.

Read also


History

  1. Introduced in 2sxc 07.00
  2. Query Params added in 2sxc 10.22