Hey guys I've been experimenting with different queries to try and get all Chatter Posts and their comments within the last 24hr period, but realize that doing this without Apex Triggers is much more difficult with pure SOQL than not.
I've tried using Multi-level Relationships on Chatter Comments example but this doesn't seem to work for me as I am not using objects. I'm hoping someone could give me a hand with creating the correct SOAP soql call to get Chatter Posts (and replies) that have been created or commented on in the last 24 hours.
Thanks guys!
Best Answer
This will Select correctly based on the question above, hope this helps someone else. Cheers.
A good way to test this is to flip the
to
and use something like this to run through it