Blog

Main » 2017 » May » 05
Select Product__r.Id, Product__r.Name, Product__r.Category__c 
FROM Order_Lines__c 
WHERE Order__r.eWinery_Date_Completed__c = LAST_N_DAYS:365 
AND Order__r.Status = 'Completed' 
AND Product__r.Category__c = ''