Skip to main content

Using custom attributes links

info

The code examples in this article is only documented with the Python API Client. While many concepts still apply for the JavaScript API, implementation details might differ.

Custom attributes can be queried from entities using the custom_attribute_links and custom_attribute_links_from relations. The "from" relation represents the reverse direction of a custom attribute link. Say you have a link between Task and AssetVersion, then custom_attribute_links represent "Task -> AssetVersion" while custom_attribute_links_from represent "AssetVersion -> Task". The relations can only be used to query and filter the result, to read the actual values you need to query CustomAttributeLink objects directly.

Below are a few examples of how to query and filter using the custom_attribute_links relation:

for task in session.query(
  'select name from Task where custom_attribute_links any '
  '(configuration.key is "supervisor" and user.username is "foobar")'
):
  print(task['name'])

for user in session.query(
  'select username from User where custom_attribute_links_from any '
  '(configuration.key is "supervisor" and context.bid > 1)'
):
  print(user['username'])

Below is an example of how to read the values of custom attribute links:

for value in session.query(
  'select user from CustomAttributeLink where '
  'configuration.key = "supervisor" and from_id = "MY_TASK_ID"'
):
  print(value['user'])

Relations​

The CustomAttributeLink object have relations to the entities that can be used when filtering a query. In the above examples we are using the "user" and "context" relations. You can see these relations in the API reference documentation available on your ftrack workspace if you look for "CustomAttributeLink" objects that are prefixed such as "UserCustomAttributeLink" and "ContextCustomAttributeLink".

To create a link between two entities you need to create a CustomAttributeLink entity like this:

session.create('CustomAttributeLink', {
  'from_id': my_task_id,
  'to_id': my_user_id,
  'configuration_id': my_configuration_id
})

If you need to create the CustomAttributeLinkConfiguration entity, please read this.

Limitations​

Projections​

It is currently not possible to use the custom_attribute_links relation as a projection.