Tasks

Back Next

Parameter files in data filters

In a

masking

task, you can use user-defined parameters in simple and advanced data filters.

When you use a parameter in a filter, start the filter with the parameter. Use two dollar signs to name the parameter in the following format:

$$<parameter>

Save the parameter file local to the following directory:

<Secure Agent installation directory>/apps/Data_Integration_Server/data/userparameters

You can specify the parameter file name on the Schedule page of the task wizard. The parameter values are applied when the task runs.

Simple Filter Example

Consider that you apply a filter on the Account object. Configure the filter condition that the Created Date must be equal to $$param. Then create a parameter file with the following content:

$$param=('1991-10-03')

The following image shows a simple filter with the use of a parameter:

The Data Filter dialog box shows a simple filter that is applied on the Account object. The filter applied is that the Created Date must be equal to $$param.

Advanced Filter Examples

Consider that you apply a filter on the Account object. In the Advanced Data Filter dialog box, you can specify the filter expression that the Account Name field must pick all the values from $$param. Then create a parameter file with the following content:

$$param=('Apple' , 'Microsoft')

The following image shows an advanced filter with the use of parameter as a value:

The Advanced Data Filter dialog box shows that the filtered object is Account, the list of fields, and a filter expression. The following filter expression is entered: Account.Name IN $$param

You can also specify a filter expression as a parameter. Enter $$param as the filter expression. Then create a parameter file with the following content: