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.
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 √