function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
vasu sfdc_21vasu sfdc_21 

soql query for opportunity status

Hi Folk,

Trying to write  a soql query on opportunity for Opportunity Status value but getting error bacause value not coming.

Please help me out  soql query for opportunity status value.
How can we wrtite Opportunity status field in the result. 

Any
Open
Closed
Colsed One


 
Best Answer chosen by vasu sfdc_21
CharuDuttCharuDutt
Hii Vishal 
SELECT Id, Name, StageName,Type FROM Opportunity

SELECT Id, Name, StageName,Type  FROM Opportunity WHERE StageName = 'Closed Won'

SELECT Id, Name, StageName,Type FROM Opportunity WHERE StageName = 'Closed Won' AND Type != null

SELECT Id, Name, StageName,Type FROM Opportunity WHERE StageName = 'Closed Won' AND Type == 'Existing Customer - Upgrade'
Please Mark it As Best Answer  So It Helps Others In Future
Thank You!
 

All Answers

CharuDuttCharuDutt
Hii Vishal
Try Below Query 
SELECT Id, Name, StageName  FROM Opportunity WHERE StageName = 'Closed Won'
Please Mark it As Best Answer  If It Helps
Thank You!
 
vasu sfdc_21vasu sfdc_21
Thanks Charu !!
StageName coming but with this i need type also of StageName

below is StageName type
Open
Closed/Lost
Closed/Won


 
CharuDuttCharuDutt
Hii Vishal 
SELECT Id, Name, StageName,Type FROM Opportunity

SELECT Id, Name, StageName,Type  FROM Opportunity WHERE StageName = 'Closed Won'

SELECT Id, Name, StageName,Type FROM Opportunity WHERE StageName = 'Closed Won' AND Type != null

SELECT Id, Name, StageName,Type FROM Opportunity WHERE StageName = 'Closed Won' AND Type == 'Existing Customer - Upgrade'
Please Mark it As Best Answer  So It Helps Others In Future
Thank You!
 
This was selected as the best answer
vasu sfdc_21vasu sfdc_21
Thanks Charu !!