function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
SimplySfdcSimplySfdc 

filter on relationship query

Hi,

I use enterprise wsdl version 9.

select count() FROM OpportunityLineItem oli WHERE oli.PricebookEntry.Product2.Fileds1__c <> 0

and compare to

select count() FROM OpportunityLineItem oli

I get the same results, although in data, their are some data Product2.Fileds1__c = 0
So, filtering on above seems not working, anyone get this issue and how to fix it? Thanks

sq
SuchitraSuchitra
Hi sq,

Please try this out

select count() FROM OpportunityLineItem oli WHERE oli.PricebookEntry.Product2.Fileds1__c > 0

not  "oli.PricebookEntry.Product2.Fileds1__c <> 0"

Regards
Suchitra Insert Smilies