Happy Business Starts Here

Highlighted
Support SME
Support SME

Quote error: invalid operator

Question or Problem Statement:
When I click select product button in a quote, I get "invalid operator" error:
Error is in expression '{!lcc.theOptions}' in component <zqu:listcomponent> in component zqu:listcomponent
An unexpected error has occurred. Your solution provider has been notified. (zqu)







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
Support SME

Re: Quote error: invalid operator


Solution:
Turn on SFDC debug then reproduce the error. If you can see the query in the debug log,
select name,zquskuc,zqudescriptionc,zquallow_feature_changesc from zquZProductc WHERE Id IN ( '' ) AND Deletedc = false AND EffectiveStartDatec <= null AND EffectiveEndDate__c >= null LIMIT 10000

then, in the product query it is invalid to select from product table where the EffectiveStartDatec <= null and zquEffectiveEndDatec >= null. These dates are compared to a null value because the StartDate was not being set on the quote.

We also need Currency. So, please add StartDate and Currency while creating a quote, it should fix this issue.



Supporting References:
https://knowledgecenter.zuora.com/DC_Developers/SOAP_API/E1_SOAP_API_Object_Reference






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