Is there a way to do 'DISTINCT' in an API query

I'm curious if there is a way to do a sort of SELECT DISTINCT query through the Shotgun API?

For instance, if I want to get a list of PublisheFileType entities that have actually been used in a PublishedFile, If there have been a thousand publishes of type 'maya_file' and a thousand publishes with type 'alembic_file', I don't want to get two thousand results, I just want two.

So a query something along the lines of:

find( 'PublishedFile', [], fields = [ 'published_file_type'], distinct_on = 'published_file_type' )



0 条评论