Sorry to revive an old thread, but is there any way to change the user for the Activity also? The change suggested by @Mattias Lagergren definitely changes the "Published By" property, but the Activities tab for the Asset Version still shows "<api user> published..." instead of the user I specify in the `user_id`.
The filter that you need requires multiple queries.
And the web gui can't handle that, at the moment.
This is something that we are aware of and that's being discussed.
Can't giva any guarantees, but hopefully we could get even better possibilities for queries in future release(s)of ftrack.
In the meantime, as mentioned by Julian, you could use the API.
Ah ok .. guess that’s by design.
you could setup an event handler that is listening to status changes and sets a ‘latest_approved’ flag on the most recent approved version. Then you could use that attribute in your queries.
Quite involved for what you want but it should work. Would be welcome if something like that could be accomplished with the filter queries instead.