Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Lakshmi SLakshmi S 

SOQL query issue on Opportunity ?

Hi Team,

I have generated a report on Opportunity with same filter condition, for this filter i am using below soql query. But Report and developer cosole fetching different records (Records mismatch ).

SOQL Query :
---------------------- 
Select id,Name from Opportunity WHERE (Category__c = 'Red Zone / Awarded, Negotiating Contract' OR  Category__c = 'Top Pursuits' OR  Category__c ='Cultivation Targets')
 AND (Region__c != 'Portfolio Services' OR Region__c !='KLMK' OR Region__c != 'Competitors ')
 AND Top_10__c = 'Yes'
 AND (Pursuit_Type__c ='New' OR Pursuit_Type__c ='Expansion' OR Pursuit_Type__c ='Renewal' OR Pursuit_Type__c ='Extension')
 AND (NOT Name Like '%Dummy%')
Report Filter  :
------------------------ 
Filtered By:   Edit 
   	Category equals "Red Zone / Awarded, Negotiating Contract",Top Pursuits,Cultivation Targets Clear 
   	AND Selling Team not equal to Portfolio Services,KLMK,Competitors Clear 
   	AND Growth Report Pursuit equals Yes Clear 
   	AND Pursuit (Type) equals New,Expansion,Renewal,Extension Clear 
   	AND Opportunity Name does not contain Dummy Clear

Please let me know any one......
How can we resolve this issue...

 
Best Answer chosen by Lakshmi S
Waqar Hussain SFWaqar Hussain SF
Hi Lakshmi,

Have you set the correct api name of Selling team field and Growth Report Pursuit field?

If yes, then try below SOQL query
  
Select id,Name from Opportunity WHERE 
 (Category__c = 'Red Zone / Awarded, Negotiating Contract' OR Category__c = 'Top Pursuits' OR Category__c = 'Cultivation Targets') 
   	AND (Region__c != 'Portfolio Services'  AND Region__c != 'KLMK' AND Region__c != 'Competitors')
   	AND Top_10__c = 'Yes'
   	AND (Pursuit_Type__c =  'New' OR Pursuit_Type__c = 'Expansion' OR Pursuit_Type__c = 'Renewal' OR Pursuit_Type__c = 'Extension')
   	AND (NOT Name Like '%Dummy%')

 

All Answers

Waqar Hussain SFWaqar Hussain SF
Hi Lakshmi,

Have you set the correct api name of Selling team field and Growth Report Pursuit field?

If yes, then try below SOQL query
  
Select id,Name from Opportunity WHERE 
 (Category__c = 'Red Zone / Awarded, Negotiating Contract' OR Category__c = 'Top Pursuits' OR Category__c = 'Cultivation Targets') 
   	AND (Region__c != 'Portfolio Services'  AND Region__c != 'KLMK' AND Region__c != 'Competitors')
   	AND Top_10__c = 'Yes'
   	AND (Pursuit_Type__c =  'New' OR Pursuit_Type__c = 'Expansion' OR Pursuit_Type__c = 'Renewal' OR Pursuit_Type__c = 'Extension')
   	AND (NOT Name Like '%Dummy%')

 
This was selected as the best answer
Lakshmi SLakshmi S
Hi Waqar Hussain,

Thanks for you reply.
Instead of this i am using below query. 
Select id,Name from Opportunity WHERE Category__c IN ('Red Zone / Awarded, Negotiating Contract','Top Pursuits','Cultivation Targets')
 AND Region__c NOT IN ('Portfolio Services','KLMK','Competitors') AND Top_10__c = 'Yes'
 AND Pursuit_Type__c IN ('New','Expansion','Renewal','Extension')
 AND (NOT Name Like '%Dummy%')

Regards,
Lakshmi.
 
Waqar Hussain SFWaqar Hussain SF
Hi Lakshmi,

Your query looks fine. What issue are you facing, Can you please explain.

Thanks
Lakshmi SLakshmi S
Hi Waqar,

Thanks for you reply.
I have modified query using IN operator, now its working fine. As well as your query also working fine.
Thank you once again.

Regards,
Lakshmi
Waqar Hussain SFWaqar Hussain SF
Please don't for get to mark best answer for the most helpful answer.