• lokesh reddy 7
  • NEWBIE
  • 10 Points
  • Member since 2016

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 13
    Questions
  • 4
    Replies
Hi,

I need a help in SOQL , 

Select id,subject,CreatedDate__c from task where whoid in (select leadId from CampaignMember where Campaign.id = '70128000000BAgd') and task.CreatedDate__c > (select startdate from campaign where id = '70128000000BAgd')

Iam trying retrieve the records with whoid in campaignmember and createddate of activity greater than camapaign StartDate but iam getting error .can some one advise what is the error here in this query.

Thanks
Kiran
Hi ,

I Have one trigger on opportunity on before insert ,before update .In that trigger iam changing owner id on update.Here i need to query the old opportunity team members related to the old owner.But iam not getting opportunity team members.Can any one advise on this.

Regards,
lokesh

Hi ,

How to get the user field details from the lead object .
 

Thanks
lokesh