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' )
Cheers,
Chris.