function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
ColealarsColealars 

Need soql query against opportunitylineitem for active products

Can someone help me modify the query below to filter on Product2.isActive = true

 

Select description, PricebookEntry.isActive FROM OpportunityLineItem WHERE PricebookEntry.IsActive = true

ministe_2003ministe_2003

Select description, PricebookEntry.isActive FROM OpportunityLineItem WHERE PricebookEntry.IsActive = true AND PricebookEntry.Product2.isActive = true