How can i query for the type in opportunity stage?

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

Answers:

Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.

Method 1

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.


All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

0 0 votes
Article Rating
Subscribe
Notify of
guest

0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x