You need to sign in to do that
Don't have an account?
Srini
Opportunity Soql Query
Hi Team,
How to write a SOQL: In opportunity Object we have Related lists like Teammembers and open activities.I want get the fields like Teammembers role = 'AB' along with the open activities details from same opportunity .
Select id,Opportunity.RecordType.name,LastModifiedDate,Opportunity.LastModifiedDate,TeamMemberRole FROM OpportunityTeamMember where TeamMemberRole = 'ABC'
But i want to include openactivites fields also. How to add this query from above one.
Please help us.
Thanks
How to write a SOQL: In opportunity Object we have Related lists like Teammembers and open activities.I want get the fields like Teammembers role = 'AB' along with the open activities details from same opportunity .
Select id,Opportunity.RecordType.name,LastModifiedDate,Opportunity.LastModifiedDate,TeamMemberRole FROM OpportunityTeamMember where TeamMemberRole = 'ABC'
But i want to include openactivites fields also. How to add this query from above one.
Please help us.
Thanks
Select id,Opportunity.RecordType.name,LastModifiedDate,Opportunity.LastModifiedDate,TeamMemberRole,(SELECT Subject FROM OpenActivities) FROM OpportunityTeamMember where TeamMemberRole = 'ABC'