0

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.

2
  • whith SOQL we don't do this, i tried in Force.com Explorer but i have an error
    – KhaledZero
    Jul 8, 2013 at 11:10
  • 1
    @KhaledZero: You're likely to get voted down because your question does not show any research or attempted SOQL. Try reading some of the SOQL documentation or using Workbench first (blogs.developerforce.com/developer-relations/2013/05/…) and posting what you have tried and you'll get better responses.
    – Mike Chale
    Jul 8, 2013 at 13:11

2 Answers 2

4

You may want to query the CollaborationGroup object directly:

Select Owner.Name, Name, LastModifiedDate 
From CollaborationGroup 
Where LastModifiedDate < 2013-04-20T14:00:00.000Z
6
  • Thx but i want get Username of User in the same query
    – KhaledZero
    Jul 8, 2013 at 11:49
  • @KhaledZero Owner.Name is the name of the owner (user). Jul 8, 2013 at 12:46
  • @mastOr Username is like this "[email protected]" and it is a premary key
    – KhaledZero
    Jul 9, 2013 at 8:48
  • 1
    @KhaledZero Well, then use Owner.Username! Jul 9, 2013 at 9:17
  • @mastOr when I use Owner.Username I have this result: hpics.li/dc9a067 but me I want in Owner things lik this '[email protected]' .... and not 'Owner' for all groups thx
    – KhaledZero
    Jul 9, 2013 at 10:00
0
SELECT Owner.Username, LastFeedModifiedDate, Name, OwnerId FROM CollaborationGroup WHERE LastModifiedDate < LAST_N_DAYS:90

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .