Skip to main content

Query filters for Data Transformation

Zuora

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 the fields or columns in these objects are also available for use.

Data Source Zuora Billing object Zuora Revenue table
Order 
  • Account
  • Subscription
  • RatePlanCharge
  • RatePlan
  • ProductRatePlanCharge
  • RPRO_DS_ACCOUNT_G
  • RPRO_DS_SUBSCRIPTION_G
  • RPRO_DS_RATE_PLAN_CHARGE_G
  • RPRO_DS_RATE_PLAN_G
  • RPRO_DS_PRODUCT_RPC_G
InvoiceItem
  • Account
  • Subscription
  • RatePlanCharge
  • RatePlan
  • Invoice
  • InvoiceItem
  • RPRO_DS_ACCOUNT_G
  • RPRO_DS_SUBSCRIPTION_G
  • RPRO_DS_RATE_PLAN_CHARGE_G
  • RPRO_DS_RATE_PLAN_G
  • RPRO_DS_INVOICE_G
  • RPRO_DS_INVOICE_ITEM_G
InvoiceItemAdjustment
  • Account
  • Subscription
  • RatePlanCharge
  • RatePlan
  • Invoice
  • InvoiceItem
  • InvoiceItemAdjustment
  • RPRO_DS_ACCOUNT_G
  • RPRO_DS_SUBSCRIPTION_G
  • RPRO_DS_RATE_PLAN_CHARGE_G
  • RPRO_DS_RATE_PLAN_G
  • RPRO_DS_INVOICE_G
  • RPRO_DS_INVOICE_ITEM_G
  • RPRO_DS_INVOICE_ITEM_ADJ_G
CreditMemoItem
  • Account
  • Subscription
  • CreditMemo
  • CreditMemoItem
  • RPRO_DS_ACCOUNT_G
  • RPRO_DS_SUBSCRIPTION_G
  • RPRO_DS_CREDIT_MEMO_G
  • RPRO_DS_CREDIT_MEMO_ITEM_G
DebitMemoItem
  • Account
  • Subscription
  • DebitMemo
  • DebitMemoItem
  • RPRO_DS_ACCOUNT_G
  • RPRO_DS_SUBSCRIPTION_G
  • RPRO_DS_DEBIT_MEMO_G
  • RPRO_DS_DEBIT_MEMO_ITEM_G