Happy Business Starts Here

ZOQL excludes tiered RatePlanCharges when Price field is requested

Highlighted
Newly Enrolled

ZOQL excludes tiered RatePlanCharges when Price field is requested

We are running this query:

select Id, Price, Quantity, ProductRatePlanChargeId, ChargeModel, ChargeType from RatePlanCharge where RatePlanId=? and IsLastSegment=true
the rate plan has two charges, a flat fee charge, and a tiered charge with two tiers, a flat fee tier and a per unit tier. If Price is included in the field list, we only get the flat fee charge. Removing Price from the list of fields returns both charges.

Tags (1)
1 REPLY 1
Highlighted
Support SME

Re: ZOQL excludes tiered RatePlanCharges when Price field is requested

@jlesueur - For charges using Tiered Pricing model, the prices are stored in RatePlanChargeTier level, as a result, when you add Price field in your query, using RatePlanCharge object, those types of charges will not be returned.

 






If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √