Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

How do i query for all opportunities which has the type "Closed/won" on opportunityStage not the stage "Closed/Won". We have a few stages which are of Type Closed/Won but not with the stagename as closed/won


share|improve this question
up vote 5 down vote accepted

Use the IsWon field in your SOQL condition expression. For example,

SELECT Id, Name FROM Opportunity WHERE IsWon = TRUE

will return all Opportunities with any StageName of Type Closed/Won.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.