I need to retrieve one latest EventLogEntry for each of the Tasks I have.
I could call find() for all EventLogEntries and do a loop to find the latest but the find()'s result would be too large and cause performance hit. And I can't add date filter since the Tasks activities are uneven. As I understand, there is no MAX filter for Shotgun.
Is there a way to do this with one find() call?
Just to give you an idea about the speed:
Querying all EventLogEntries for 17 Tasks returns 6770 rows and takes around 9.3 seconds.