Nicholas Yue Posted September 26, 2022 Report Share Posted September 26, 2022 (edited) 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 September 26, 2022 by Nicholas Yue Accidentally hit the return key Link to comment Share on other sites More sharing options...
Patrick Boucher ftrack Posted October 21, 2022 Report Share Posted October 21, 2022 Hi @Nicholas Yue, Please use the following query. It should work. Our documentation is unfortunately out of date and we'll be looking into fixing this as soon as possible. assets = session.query('AssetVersion where asset.parent.project.name is "{project_code}"'.format(project_code=project_code)).all() Regards, Patrick Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now