Happy Business Starts Here

Highlighted
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 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
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 √

View solution in original post

1 REPLY 1
Highlighted
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 √

View solution in original post