Remus Avram Posted February 11, 2019 Report Share Posted February 11, 2019 Hi, I would like to assign 50 users to a task in Ftrack. I used the ftrack_api to add automatically all the users to the project and assign them to a single task using the code from below. import ftrack_api session = ftrack_api.Session() project = session.query("Project where name is <project_name>").one() users = session.query("User where is_active is True").all() task = session.query( "select assignments.resource_id " "from Task " "where project.name is '<project_name>' and name is '<task_name>'").one() already_assigned = [_['resource_id'] for _ in task['assignments']] already_members = [_['resource_id'] for _ in project["allocations"]] for user in users: if user["id"] not in already_members: session.create("Appointment", { "context": project, "resource": user, "type": "allocation" }) if user['id'] not in already_assigned: session.create('Appointment', { 'context': task, 'resource': user, 'type': 'assignment' }) session.commit() When I opened the Ftrack web interface and click to the Assignee column of the task, it displays only 27 users. Once I click outside of the box, it displays as there were changes to the task. If I save the changes, then it removes some users and keeps only 27. Is this the normal behaviour, or I am doing something wrong? Ftrack version: 4.1.5 Best, Remus Link to comment Share on other sites More sharing options...
instinct-vfx Posted February 18, 2019 Report Share Posted February 18, 2019 This is a front-end limitation, you can assign and unassign more through the API. We worked around it by managing tasks that need more than the supported user count in the UI in a separate local tool. It can seemingly be worked around also by changing a MariaDB setting. You may want to talk to support directly if you want to go down that route (we felt that managing that many users from the current legacy resource selector is not exactly fun anyways). Link to comment Share on other sites More sharing options...
Remus Avram Posted February 18, 2019 Author Report Share Posted February 18, 2019 Hi @instinct-vfx yes, assigning more then 27 users via API works, but then we need to not allow users to assign via the web interface anymore. Also there is not possible to lock an entity so the users can't change it via the web interface. Link to comment Share on other sites More sharing options...
JPrydz Posted February 18, 2019 Report Share Posted February 18, 2019 Hi, When having lots of assignees on a task the following variable in mysql will cause problems in the Tasks spreadsheet:https://mariadb.com/kb/en/library/server-system-variables/#group_concat_max_len From MariaDB 10.2.4 the default value has changed and will no longer result in this problem. If you are facing this issue now you can change the setting to be 1M. Updating this variable will solve the problems in the tasks spreadsheet but there is no guarantee other places in the UI will not suffer from other presentational issues when having a large number of assignees on a single task. /Johan Link to comment Share on other sites More sharing options...
Remus Avram Posted February 18, 2019 Author Report Share Posted February 18, 2019 Thanks @JPrydz for letting us know. Is Ftrack going to support MariaDB 10.2.4 soon? Link to comment Share on other sites More sharing options...
JPrydz Posted February 19, 2019 Report Share Posted February 19, 2019 We will update our documentation regarding MariaDB 10 shortly. /Johan Link to comment Share on other sites More sharing options...
instinct-vfx Posted March 5, 2019 Report Share Posted March 5, 2019 Does this change lead to "way more" being supported but still limited? Or will this completely remove the limit? Link to comment Share on other sites More sharing options...
JPrydz Posted March 6, 2019 Report Share Posted March 6, 2019 Hi, As seen in this document:https://mariadb.com/kb/en/library/server-system-variables/#group_concat_max_len the default value has been increased to 1M in version 10.2.4 and later. So still an upper limit, but quite substantial increase from earlier version. /Johan Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.