My code is pulling through Opportunity
records where the StageName
is equal to 'Closed won - Signed Contract'
or 'Closed Lost'
. However it shouldn't be pulling through these records. What is wrong with my query?
listOpportunity = [SELECT Id, OwnerId,Name,Owner.FirstName,(SELECT Id, Product2.Name FROM OpportunityLineItems
WHERE Product2.Convert_to_Service_Catalogue_Emailed__c = FALSE
AND Product2.Convert_to_Service_Catalogue_Initiated__c = TRUE)
FROM Opportunity
WHERE (StageName != 'Closed Won - Signed Contract' OR StageName != 'Closed Lost')
AND Id in
(SELECT OpportunityId FROM OpportunityLineItem
WHERE Product2.Convert_to_Service_Catalogue_Emailed__c = FALSE
AND Product2.Convert_to_Service_Catalogue_Initiated__c = TRUE)];