Happy Business Starts Here

Student

ZOQL mysterious ways.

Hi, We are trying to do a select like this:

SELECT Id, AccountId,TermStartDate,TermEndDate,SubscriptionStartDate FROM Subscription WHERE Status='Active' and TermStartDate>='2016-08-23' and TermStartDate<='2016-08-25' and TermStartDate>SubscriptionStartDate

 

Without "and TermStartDate>SubscriptionStartDate" works perfect.

 

What's is wrong with this sentence ?.

 

Thanks in advance. My code is : 14418

1 REPLY 1
Zuora Support

Re: ZOQL mysterious ways.

Greeting - ZOQL is designed to support simple queries only in order to protect our Database from long-runtime query, SQL injection, etc.  Comparing two fields in the filter is not supported.

 

You can check out Zuora Object Query Language article for more details.



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