You can create a parameter map that is based on existing
query items.
Procedure
- Right-click the Parameter Maps folder
in the Project Explorer pane and select New
Parameter Map Based on Query Items.
A new
parameter map is added in the Parameter Maps folder
with the working name New Parameter Map.
- Rename the map as required and double-click the map to
open the editor.
- Click the New Query item icon.
- Click the query item to use as the key, and then click
the query item to use as the value. Both query items must be from
the same query subject.
- Optional: In the properties pane, specify the Default
Value property.
The default value is used if
the key that is used in an expression is not mapped. If no default
is provided, an unmapped key could produce an error.