Jump to content

Querying assets in a project ?


Nicholas Yue

Recommended Posts

I am trying to following the example query here

```

AssetVersion where asset.parent.project.name is "project_code" or parent.name is "project_code"
```

My project name is "magician" when I try this out

project_code = 'magician'
assets = session.query('AssetVersion where asset.parent.project.name is "{project_code}" or parent.name is "{project_code}"'.format(project_code=project_code)).all()
for asset in assets:
print(asset['name'])

I get the following errors

```

Server reported error: KeyError(u"No attribute parent exists for schema u'AssetVersion'.")
NoneType: None
Traceback (most recent call last):
  File "main.py", line 20, in <module>
    assets = session.query('AssetVersion where asset.parent.project.name is "{project_code}" or parent.name is "{project_code}"'.format(project_code=project_code)).all()
  File "/data1/nyue/temp/ftrack/dev_venv/lib/python3.7/site-packages/ftrack_api/query.py", line 123, in all
    return list(self)
  File "/data1/nyue/temp/ftrack/dev_venv/lib/python3.7/site-packages/ftrack_api/query.py", line 94, in __len__
    self._fetch_more()
  File "/data1/nyue/temp/ftrack/dev_venv/lib/python3.7/site-packages/ftrack_api/query.py", line 110, in _fetch_more
    records, metadata = self._session._query(expression)
  File "/data1/nyue/temp/ftrack/dev_venv/lib/python3.7/site-packages/ftrack_api/session.py", line 869, in _query
    results = self.call(batch)
  File "/data1/nyue/temp/ftrack/dev_venv/lib/python3.7/site-packages/ftrack_api/session.py", line 1687, in call
    raise ftrack_api.exception.ServerError(error_message)
ftrack_api.exception.ServerError: Server reported error: KeyError(u"No attribute parent exists for schema u'AssetVersion'.")

```

 

Edited by Nicholas Yue
Accidentally hit the return key
Link to comment
Share on other sites

  • 4 weeks later...

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...