So I'm new to Ftrack, and just learning about tuning projections in queries to gain a little more speed, and came across an error trying to get status.name for assigned task from a user. I get this error;
KeyError("Multiple schemas [u'Project', u'TypedContext'] found for relationship u'status'.")
I'm sure there's a way to focus on a single schema, but I'm unsure how to write it.
Can someone point me in the right direction?
Here's the existing query with the broken item in strikethrough;
user = session.query(
'select \
assignments.context._link, \
assignments.context.name, \
assignments.context.parent.name, \
assignments.context.status.name, \
assignments.context.parent.parent.name from User \
where is_active is "True" and email is "{}"'.format(user_email)).one()
Less of a concern for me, but another question is, can I select an index in a list? I only want the first item in assignments.context._link.
Thanks!
M.