Hi, we are currently trying to set up a filter query in the browser. Goal is to list all latest version of assets for one project which have the status "approved" or "Artist Reviewed".
We have come up with the following query:
"(status.name is 'Artist Reviewed' or status.name is 'Approved' ) and (task.type.name is 'Compositing' and asset.name not_like '%preRender%')"
The thing is that we only want to see one result, the lastest, and not all versions matching the criteria.
I have read in the forum that "limit and order by" statements are not possible in the filter query.
Do you have a hint for us to get the result we want?
thanks!