Hey all, experimenting with permissions at our studio,
For artist visual clarity we’ve decided to restrict artists to an access group with folder read set to ‘assigned’.
(ideally we’d pull this from SG but that’s a whole different can of worms)
This works great and only shows artists the shots/assets in which they have tasks assigned.
When doing this however, unassigned tasks are visible, and saving any workfile results in an error (the file does save, strangely)
Artists view of the launcher
In this case, the artist is assigned to only a roto task, but all other tasks are visible. Not the end of the world but potentially unintended behaviour
Work files window
This error appears when saving, regardless of if the task is assigned.
Removing “Restrict folder read” fixes this
Work files error
Traceback (most recent call last):
File "C:\Users\user\AppData\Local\Ynput\AYON\addons\openpype_3.18.8\openpype\tools\ayon_workfiles\control.py", line 540, in save_as_workfile
self._save_as_workfile(
File "C:\Users\user\AppData\Local\Ynput\AYON\addons\openpype_3.18.8\openpype\tools\ayon_workfiles\control.py", line 732, in _save_as_workfile
self.save_workfile_info(folder_id, task_id, dst_filepath, None)
File "C:\Users\user\AppData\Local\Ynput\AYON\addons\openpype_3.18.8\openpype\tools\ayon_workfiles\control.py", line 449, in save_workfile_info
self._workfiles_model.save_workfile_info(
File "C:\Users\user\AppData\Local\Ynput\AYON\addons\openpype_3.18.8\openpype\tools\ayon_workfiles\models\workfiles.py", line 679, in save_workfile_info
self._entities_model.save_workfile_info(
File "C:\Users\user\AppData\Local\Ynput\AYON\addons\openpype_3.18.8\openpype\tools\ayon_workfiles\models\workfiles.py", line 498, in save_workfile_info
workfile_info = self._get_workfile_info(
File "C:\Users\user\AppData\Local\Ynput\AYON\addons\openpype_3.18.8\openpype\tools\ayon_workfiles\models\workfiles.py", line 460, in _get_workfile_info
for workfile_info in ayon_api.get_workfiles_info(
File "C:\Users\user\AppData\Local\Ynput\AYON\addons\openpype_3.18.8\openpype\vendor\python\common\ayon_api\server_api.py", line 5360, in get_workfiles_info
for parsed_data in query.continuous_query(self):
File "C:\Users\user\AppData\Local\Ynput\AYON\addons\openpype_3.18.8\openpype\vendor\python\common\ayon_api\graphql.py", line 381, in continuous_query
raise GraphQlQueryFAILED(
ayon_api.exceptions.GraphQlQueryFAILED: GraphQl query FAILED: missing FROM-clause entry for table "task" on item 'project/workfiles' (Line 3 Column 5)
Is anyone able to reproduce this error?