Jump to content

Query the AssetVersion based on the links

Andriy Babak

Recommended Posts


I'd like to get the AssetVersion objects which belong to some TypedContext. The same way as the web interface shows the versions belonging to some tasks of a shot.

When printing out the AssetVersion members, I see there's a list of "link" items with all the path entities up to the root project in the form of {"id", "type", "name"}. This looked very promising so I've created a query:

query = "select id from AssetVersion where link any (id is {})".format(entity_id)

But this returns an error:


ftrack_api.exception.ServerError: Server reported error: TypeError('NoneType' object has no attribute '__getitem__')

I tried a million of other variations but none of them worked either. Can you suggest soemthing?




Link to comment
Share on other sites

Hi Andriy,

The trouble is "link" is a string attribute so you need to use the like operator (https://mariadb.com/kb/en/like/):
project_tasks = session.query('Task where link like "%{}%"'.format(project['id'])).all()

Another option would be using the ancestors attribute like so:
project = session.query('Project').first()
proj_tasks = session.query('Task where ancestors any (id is "{0}") or project_id is "{0}"'.format(project['id'])).all()

Link to comment
Share on other sites

Hi Steve,

Thank you, this works! Is it documented somewhere? Are there any ways to see this actual data and its type?

If this is a string, how does it look like? What if I want to search just for names of the links? For example, to find all the names equal to "Shots" but not to match "Other Shots".

Thank you.



Link to comment
Share on other sites

I don't know that we document the link attribute specifically, though entity types are constructed dynamically in the Python client, and the full specifications are available as session.schemas. I've developed a few convenience methods for myself, but you can query this particular attribute type via:


It gets a little weird because what we actually send over the wire, the JSON response to a query, treats it as a list of dicts. Also, there's not a fixed representation of the link (or _link or _api_link) attr in the db, so you can't really inspect how exactly the link attribute looks, nor do you really need to. Using ancestors should give you the sort of control you want.


Including because I found it interesting:

	'AssetVersion where link like '


Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...