It's easy enough to select entities that I own ordered by time_updated DESC to get the latest.
What I want to do is instead select the groups that those entities are in. E.g. I create a blog post in group 123, then later a discussion post in group 234. I want to return [234, 123].
I've posted the $options array that doesn't do this (I can't tell what it's doing).
I think this could be done with a subquery to first pull the entities, but I'd rather not, and it seems like it shouldn't be necessary.
Any ideas?
info@elgg.org
Security issues should be reported to security@elgg.org!
©2014 the Elgg Foundation
Elgg is a registered trademark of Thematic Networks.
Cover image by RaĆ¼l Utrera is used under Creative Commons license.
Icons by Flaticon and FontAwesome.
- Steve Clay@steve_clay
Steve Clay - 0 likes
- Arsalan Shah@arsalanlee
Arsalan Shah - 0 likes
- Matt Beckett@Beck24
Matt Beckett - 0 likes
You must log in to post replies.I solved it with a subquery, but would like a more efficient solution.
Thats good Steve
tricky, I just gave it a test and you're right it's not working but it looks like it should. I'm thinking you need to group on max time_updated or something