9

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

image

12

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.

  • 2
    If someone is looking for the opposite, it's the IsClosed field. – Tobias Mühl Jul 27 '18 at 4:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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