Tweeted twitter.com/#!/StackSalesforce/status/636540557196718080

occurred Aug 26, 2015 at 14:07

deleted 1 character in body

Source Link

edited Jul 13, 2015 at 18:30

I would like to retrieve the list of Opportunities which have at least one OpportunityContactRole with role equal to test

Right now, I am doing the below query but it retrieves all the rows in the opportunity table..

[SELECT Id,
    (SELECT Id FROM OpportunityContactRoles WHERE Role = 'test')
FROM Opportunity 
WHERE IsClosed = TRUE AND IsWon = TRUE)];TRUE];

Is there any better alternative for this??

I would like to retrieve the list of Opportunities which have at least one OpportunityContactRole with role equal to test

Right now, I am doing the below query but it retrieves all the rows in the opportunity table..

[SELECT Id,
    (SELECT Id FROM OpportunityContactRoles WHERE Role = 'test')
FROM Opportunity 
WHERE IsClosed = TRUE AND IsWon = TRUE)];

Is there any better alternative for this??

I would like to retrieve the list of Opportunities which have at least one OpportunityContactRole with role equal to test

Right now, I am doing the below query but it retrieves all the rows in the opportunity table..

[SELECT Id,
    (SELECT Id FROM OpportunityContactRoles WHERE Role = 'test')
FROM Opportunity 
WHERE IsClosed = TRUE AND IsWon = TRUE];

Is there any better alternative for this??

added 21 characters in body

Source Link

edited Jul 13, 2015 at 18:26

I would like to retrieve the list of Opportunities which have at least one OpportunityContactRole with role equal to test

Right now, I am doing the below query but it retrieves all the rows in the opportunity table..

[SELECT Id,
    (SELECT Id FROM OpportunityContactRoles WHERE Role = 'test')  
FROM Opportunity  
WHERE IsClosed = TRUE AND IsWon = TRUE)];

Is there any better alternative for this??

I would like to retrieve the list of Opportunities which have at least one OpportunityContactRole with role equal to test

Right now, I am doing the below query but it retrieves all the rows in the opportunity table..

[SELECT Id,(SELECT Id FROM OpportunityContactRoles WHERE Role = 'test') FROM Opportunity WHERE IsClosed = TRUE AND IsWon = TRUE)];

Is there any better alternative for this??

I would like to retrieve the list of Opportunities which have at least one OpportunityContactRole with role equal to test

Right now, I am doing the below query but it retrieves all the rows in the opportunity table..

[SELECT Id,
    (SELECT Id FROM OpportunityContactRoles WHERE Role = 'test') 
FROM Opportunity  
WHERE IsClosed = TRUE AND IsWon = TRUE)];

Is there any better alternative for this??

Source Link

asked Jul 13, 2015 at 18:07

How to get List of Opportunities with condition on OpportunityContactRole?

I would like to retrieve the list of Opportunities which have at least one OpportunityContactRole with role equal to test

Right now, I am doing the below query but it retrieves all the rows in the opportunity table..

[SELECT Id,(SELECT Id FROM OpportunityContactRoles WHERE Role = 'test') FROM Opportunity WHERE IsClosed = TRUE AND IsWon = TRUE)];

Is there any better alternative for this??

apex soql

Return to Question