About ahanberry

ahanberry · ‎08-06-2019

I need export all customers that DO NOT have at lease one active subscription with a term end date in the future. I need to do this in a Workflow at the Rate Plan Charge level. So pull all rate plan charges for all subscriptions for all customers that DO NOT have at least one active subscription with a future term end date. So if a customer has at least one active subscription with a term end date in the future, exclude them. If a customer DOES NOT have at least one active subscription with a term end date in the future, include them (but I must pull it at the rate plan charge level for additional filtering). Any help with this would be much appreciated. The Zuora documentation on ZOQL aggregate functions is not sufficient to help work through this. Also, please note I'm not looking for all customers who have canceled subscriptions or all customers who have an inactive subscription but all customers who DO NOT have an active subscription. Thank you.

Heng · ‎06-13-2019

Hi @ahanberry Workflow doesn't have its own syntax. It uses Liquid template language for data operations. I think Liquid doesn't have a dedicated operator for "does not contain", but you can try "unless". For example, {% unless Variable_A contains String_A %} Do something {% endunless %} Hope this helps.

ahanberry · ‎04-17-2019

Thank you so much, this worked perfectly and goes a long way towards helping us calculate non-prorated amounts for growth opportunities. Much appreciated.

ahanberry · ‎04-11-2019

Zuora changed the naming convention in workflows for the object you exported/will iterate over so when you look at example workflows that come with Connect, the naming convention will be different. The zip file is the name of the object you will iterate over.

ahanberry · ‎09-21-2018

How do I implement/access this custom event framework please? Is it an add on I need to purchase? Thanks, April

jasong · ‎09-20-2018

You bet. Another thing they added a couple weeks ago was a way to "pause". You can query an object, and if it doesn't have the value you want, you can pause for X seconds, and requery it (by connecting the pause task's arrow back to the query task) and when it has the value you want, you can have the "if" test move on to the "true" steps. Sure, you can end up with an infinite loop if the thing you're querying for never changes. I haven't figured out how to mitigate that case yet. (I could potentially check the workflow.startDateTime against now() and if it's over X seconds, send an email and stop)

Happy Business Starts Here

Vision

Products

Zuora Central Platform

Products

Zuora Marketplace

Solutions

By Industry

By Role

Customers

Resources

Resources

Subscribed

Support

Company

ZOQL Aggregate functions - query help

Re: Workflow syntax - does not contain

Re: Quote Charge Summaries for primary quote only

Re: How to iterate over an object (not the exported file or custom liquid statement).

Re: How We Implemented a Custom Event Framework

Re: How to iterate over an object (not the exported file or custom liquid statement).