Happy Business Starts Here

Support SME

How to use RatePlanCharge.TriggerEvent as filter in Export ZOQL

 

Question/Problem Statement:

 

When using RatePlanCharge.TriggerEvent field as filter in UI Data Soure Exports, you can easily select any of the following:

  • Upon Service Activation
  • Upon Customer Acceptance
  • Upon Contract Effective
  • Upon a Specific Date

 

Screen Shot 2016-05-30 at 3.44.33 PM.png

 

But when passing the same values via ZOQL Export it will produce an error:

 

 

...
<ns1:Code>INVALID_VALUE</ns1:Code>
<ns1:Message>The expression " Upon Service Activation" could not be parsed as a value of type picklist.</ns1:Message>
...

 






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

1 REPLY 1
Support SME

Re: How to use RatePlanCharge.TriggerEvent as filter in Export ZOQL

Solution:

When using RatePlanCharge.TriggerEvent field as filter in Export ZOQL, please pass the following values:

 

  • UCE
  • USA
  • UCA
  • USD

Sample:

 

...
<ns1:create>
<ns1:zObjects xsi:type="ns2:Export">
....
<ns2:Name>test</ns2:Name>
<ns2:Query>Select Id,TriggerEvent From RatePlanCharge where TriggerEvent = 'USA'</ns2:Query>
</ns1:zObjects>
</ns1:create>
...

 






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

Tags (2)