I want write this query whith SOQL
Selecte User.Username, CollaborationGroup.Name, CollaborationGroup.LastModifiedDate
From User, CollaborationGroup
Where User.Id = CollaborationGroup.OwnerID AND CollaborationGroup.LastModifiedDate < 2013-04-20T14:00:00.000Z
thx
11 respostas
Either way you can do something like this:
Select Id,IsActive, Email, userName From User Where Id IN (Select OwnerId FROM CollaborationGroup)
But now you will not get LastModifiedDate for the CollaborationGroup (Chatter Group)
As already mentioned, please use two queries for this.
Alternately, I request you to close this thread by marking an answer as best answer and asking the same question at http://boards.developerforce.com/t5/Apex-Code-Development/bd-p/apex
