Query filters for Data Transformation

In the Filter field on the Transformation Job page, you can enter filter statements to filter data that will be transformed. Both the Zuora Revenue_table_name.field and Zuora_Billing_object.field formats are supported. For example, the following filter statements can get identical filter results:

•  rpro_ds_rate_plan_charge_g.charge_model = ''''Discount-Percentage''''
•  RatePlanCharge.ChargeModel = ''''Discount-Percentage''''

Custom fields can also be used as one of the filter conditions. For example, the following filter statements using custom fields are both valid:

• rpro_ds_subscription_g.cf1 = ''''yes''''
• Subscription.migration__c = ''''A136026''''

Note that the character limit for the query filter is 1000. If the filter statement exceeds 1000 characters, an error will occur.

The Filter field is required. The following table lists all supported Zuora objects and Zuora Revenue tables for each data source. All primary fields or columns in these objects are also available for use.