Remus Avram 54 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 post Share on other sites
instinct-vfx 33 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 post Share on other sites
Remus Avram 54 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 post Share on other sites
JPrydz 18 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 Remus Avram 1 Link to post Share on other sites
Remus Avram 54 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 post Share on other sites
JPrydz 18 Posted February 19, 2019 Report Share Posted February 19, 2019 We will update our documentation regarding MariaDB 10 shortly. /Johan Remus Avram 1 Link to post Share on other sites
instinct-vfx 33 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 post Share on other sites
JPrydz 18 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 post Share on other sites
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