Nebukadhezer 2 Report post Posted November 9 Hey I was wondering if one can get all Tasks/Versions etc by a group name if any assignee is in that group... GROUP_NAME = "Ape" test = session.query("AssetVersion where task.assignments.resource.memberships.group.name is {}".format(GROUP_NAME)).one() This results in a KeyError("Multiple schemas [u'Group', u'User'] found for relationship memberships.") Can I narrow down that I only want type group ? Cheers Johannes Share this post Link to post Share on other sites
Steve Petterborg 3 Report post Posted November 9 Hi Johannes, Towards the bottom of this page (search for "subclass") we show some examples of casting a result to a single type: https://help.ftrack.com/en/articles/1040506-query-syntax In your case, I believe you query string would be: "AssetVersion where task.assignments.resource[User].memberships.group.name is {}" 1 Nebukadhezer reacted to this Share this post Link to post Share on other sites
