Using Variables as Object Filters

Depending on the object type, you can use variables in filtering your data.

Note: 

For new variables and modified variable names, you must un-compile, apply the changes then re-compile to show the changes.

The object you select must have an existing data table available.

Filter data using variables

  1. On the DWD Designer window, click Designers tab. Expand the tree view to locate the object. Locating an Object
  2. Right-click a data table and select Detailed Properties > Filter. You can also choose Properties when you right-click a data table. After the Object Properties window opens, shift to Filters view.
  3. Under Filter Tasks, click Edit Filter. The Filter window opens.
  4. Select a field from the Objects and Columns pane.
  5. Select an appropriate operator.
  6. In the Variables field, select a variable from the drop-down list. For variables with multiple values, DWD will replace the variable with the list of values enclosed in parenthesis. For example: @Variable (Value1, Value2, Value3)
    If using a variable that has String and Date datatype in Filter, single quotes should be placed before and after the variable.
  7. If there is no available variable, click the Maintain Variables icon. Creating Variables
  8. Apply changes and compile.