+ 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