You need to sign in to do that
Don't have an account?
Sandra Wicket
SOQL: List of task ordered by last modified date of parent object (lead or account)
Hey Guys,
i want to create a simple list of task ordered by the last modified date of the parent record. It is no problem to the the account last modified date but i am unable to catch the last modified date of the lead object. It would be ok to seperate it in to lists.
Any solution for this ?
Thanks for your help guys !
i want to create a simple list of task ordered by the last modified date of the parent record. It is no problem to the the account last modified date but i am unable to catch the last modified date of the lead object. It would be ok to seperate it in to lists.
Any solution for this ?
Thanks for your help guys !
List<Task> lsttsk = [Select Id,LastModifiedDate From Task ORDER BY Opportunity__r.LastModifiedDate];
for(Task tsk : lsttsk )
DateTime dt= tsk.LastModifiedDate;
Let me know if you know if you have any challange
thanks for your reply, but i want to catch the last modified date of the lead object .