Happy Business Starts Here

Zuora Documentation

How does the operator IN in a batch filter work?


When I create a batch for mass actions, how does the operator IN work in the Filters tab?

Zuora Documentation

Re: How does in the operator IN work in a batch filter?


The operator 'IN' of the batch filter allows you to specify a list of filter values for the selected field.


For example, if you want to update one field name for multiple sales order lines as a batch, you can create a batch as follows:

  1. Navigate to Workbench > Manage Mass Actions.
  2. On the Batches page, click the New Batch icon add-icon.png to create the batch.
  3. In the New Batch window, specify the batch details as follows and click the Save icon save-icon.png.Screen Shot 2019-02-25 at 5.18.19 PM.png
  4. Click the Filters tab and click add-icon-green.png to add a filter criterion.
  5. Specify the criterion as follows with 'IN' being selected in the Operator column, and then click save-icon-green.png.Screen Shot 2019-02-25 at 5.24.46 PM.png
  6. Click the Next Action icon Screen Shot 2019-02-25 at 5.25.38 PM.png in the Actions column.
  7. In the Operand Value window, add each value as one line as follows. Remember the specified values must be embraced in single quotation marks.Screen Shot 2019-02-25 at 5.30.40 PM.png
  8. Close the window.

When the batch runs, the updating attribute operation will be performed on the specified sales order lines.