Fernando

quickest way to retrieve users from a task in ftrack: session.query('select assignments.resource from Task where […]')

@Dan Tennant-Ralphs since you asked me to tag you

Hello, Something that has eluded me for a while is how to quickly retrieve the assigned user(s) of a task in a query. The webapp seems to do this very quickly for a lot of tasks. Is there a way to use projections to query a task and it's assigned user(s) directly? Currently after having queried a task we have to use its id to query the user like this: 'User where assignments any (context_id is {id})' Is there a more efficient way? Cheers, Fernando

I got a reply from Erik, and I'll post it here for if anyone else needs it: The solution is to use 'ancestors.thumbnail_id' instead of 'parent.thumbnail_id' in the projection

Hello, We have encountered a small bug when querying the thumbnail of an object in a projection, for example: 'select parent.name, parent.thumbnail_url, status.name, name from Task where parent.parent.name is "100 MAP" ' The parent.thumbnail_url will throw an error: ftrack_api.exception.ServerError: Server reported error: AttributeError(type object 'Context' has no attribute 'thumbnail_url') Even though the follozing works in our case (the parent of the task is a shot that has a thumbnail): task['parent']['thumbnail_url']['url'] It would be cool to directly get the thumbnail_url in our initial query, is there a reason why this doesn't work? Cheers, Fernando

Hi Dan, Thank you for replying to all my forum questions! Cheers, Fernando

Hello, It appears that sometimes with a remove event the order of the parents will be wrong (starting from the current object being removed to the project) This happens when you remove an entity that contains other entities, for instance a Folder containing a Task and deleting the Folder. Here you can see the event for the task getting removed and the parents being out of order: {'action': 'remove', 'changes': {'bid': {'new': None, 'old': 0.0}, 'context_type': {'new': None, 'old': 'task'}, 'created_by': {'new': None, 'old': '7304e7ca-6b30-4883-9ac3-2790e0f2863d'}, 'description': {'new': None, 'old': ''}, 'enddate': {'new': None, 'old': None}, 'id': {'new': None, 'old': '9aa5e865-7166-4263-ad35-84235c29e8d6'}, 'isopen': {'new': None, 'old': False}, 'isrequirecomment': {'new': None, 'old': False}, 'name': {'new': None, 'old': 'Task name'}, 'object_typeid': {'new': None, 'old': '11c137c0-ee7e-4f9c-91c5-8c77cec22b2c'}, 'parent_id': {'new': None, 'old': 'ded66c29-a108-4040-8e4e-5c41277f3be8'}, 'priorityid': {'new': None, 'old': '9661b320-3a0c-11e2-81c1-0800200c9a66'}, 'project_id': {'new': None, 'old': '21ab25fe-1326-11ed-8f22-226b2eaee502'}, 'showid': {'new': None, 'old': '21ab25fe-1326-11ed-8f22-226b2eaee502'}, 'sort': {'new': None, 'old': 0.0}, 'startdate': {'new': None, 'old': None}, 'statusid': {'new': None, 'old': 'b8da42a6-d1fa-11ec-bd18-c2c2635a447b'}, 'taskid': {'new': None, 'old': '9aa5e865-7166-4263-ad35-84235c29e8d6'}, 'thumbid': {'new': None, 'old': None}, 'typeid': {'new': None, 'old': 'eb42a444-cfca-11ed-bc56-8207c690cda3'}}, 'entityId': '9aa5e865-7166-4263-ad35-84235c29e8d6', 'entityType': 'task', 'entity_type': 'Task', 'keys': ['id', 'taskid', 'thumbid', 'created_at', 'context_type', 'name', 'parent_id', 'created_by', 'bid', 'description', 'startdate', 'enddate', 'statusid', 'typeid', 'priorityid', 'isopen', 'isrequirecomment', 'object_typeid', 'showid', 'sort', 'project_id'], 'objectTypeId': '11c137c0-ee7e-4f9c-91c5-8c77cec22b2c', 'parentId': 'ded66c29-a108-4040-8e4e-5c41277f3be8', 'parents': [{'entityId': '9aa5e865-7166-4263-ad35-84235c29e8d6', 'entityType': 'task', 'entity_type': 'Task', 'parentId': 'ded66c29-a108-4040-8e4e-5c41277f3be8'}, {'entityId': '21ab25fe-1326-11ed-8f22-226b2eaee502', 'entityType': 'show', 'entity_type': 'Project', 'parentId': None}, {'entityId': 'ded66c29-a108-4040-8e4e-5c41277f3be8', 'entityType': 'task', 'entity_type': 'Folder', 'parentId': '2019772d-e121-4537-95a0-ec86503e6bcc'}, {'entityId': '2019772d-e121-4537-95a0-ec86503e6bcc', 'entityType': 'task', 'entity_type': 'AssetBuild', 'parentId': '61cd032f-398a-4e80-98e2-0d137519c7a6'}, {'entityId': '61cd032f-398a-4e80-98e2-0d137519c7a6', 'entityType': 'task', 'entity_type': 'Folder', 'parentId': '88d47da3-369b-4190-8de0-01c4b63b6c3d'}, {'entityId': '88d47da3-369b-4190-8de0-01c4b63b6c3d', 'entityType': 'task', 'entity_type': 'Folder', 'parentId': '6cd61c6c-1d46-4fb3-9ed8-740407ce22e4'}, {'entityId': '6cd61c6c-1d46-4fb3-9ed8-740407ce22e4', 'entityType': 'task', 'entity_type': 'Folder', 'parentId': '21ab25fe-1326-11ed-8f22-226b2eaee502'}]} This is problematic for me because I was relying on parents[-1] being the project, while in this case the project is the second element of the list. Is this a bug, or should I not expect the parents to be in order?

Hello, I believe we encountered a bug when filtering Due Dates of tasks. I set the Due Date of a task to 2023-05-09 And then tried filtering with the following filter, but the task does not appear: However, when I set the filter to "is not", the task does appear: Am I misunderstanding something? To me it seems like the filter has a bug. Cheers, Fernando

Hello, In the time sheet task drop down you can not select an assigned task that has been set to a "Done" state. I get why this is done, because otherwise the list of tasks would become very long during production. However, what would be the proper way to still log time for a task that was set to a "Done" status in the timesheet? Is it possible to still display "Done" tasks here? Cheers, Fernando

Hi Pat, It seems that the Update Task event isn't always generated when you change the assignee of a task (sometimes it is though). So while I would like to make it a feature request to add the old/new user ids in the changes of a Update Task event, it seems that it wont always work. I guess I do indeed need to work with Appointment events instead. Small side note: I never got a notification that you replied to my last message so my apologies for the late reply. Cheers, Fernando

Hi Daniel, That is exactly what I was looking for! I thought it had to do with the entity type but didn't know how to change it. Thank you so much! Cheers, Fernando

Hello, I'm trying to understand how a back-up of a project would work in ftrack. Could it be possible to restore a project to 24h hours ago? I've read this documentation: https://ftrack.zendesk.com/hc/en-us/articles/360005305477-Backups But we aren't running ftrack on-prem. We are switching to a full production in ftrack, and I would like to know how I could restore data if something went wrong, such as a user deleting entire entities by accident. Normally this shouldn't happen, but it's better to be prepared Cheers, Fernando

Hello, I have created a custom object type called "Variant Category" and I would like to set its status without there being any underlying tasks. The idea is that this custom object will be linked to tasks and have a status that gets automatically updated if all linked tasks are set to final for example, but it won't have the tasks directly underneath it in the hierarchy view. As you can see in this example this "geometry" Variant Category is linked to tasks and I set the status to the lowest status of those tasks through the API ("in_progress" in this case) However, the Variant Category in the hierarchical view does not display the status since it is acting like a "folder object". Is it possible to create my own object type that handles like a task object? or alternatively - if that is not possible- can I create a task with a different icon than the classic task icon? Ideally I would want it to be a different type than a Task, to be able to quickly query all the objects of this type. I guess another solution would be to have a task underneath the Variant Category that is linked to all the other tasks instead, but this seems redundant. Cheers, Fernando

Hello, Currently in the activities tab of a task, I can see changes of the following types: status/assignee/note/asset-published. Is it possible to also save other types of changes to the task, such as start-date/end-date changes and who made them in the activities tab? Could I do that through the API when catching an update task event? Cheers, Fernando

Hi Erik, In your example you are accessing the user who made the change. What I am actually looking for is the new and old assigned user to a task. I now understand that I can find this information in the "appointment" add and remove event that also occur next to the task update entity within the event, but this is a very roundabout way of getting that info (I have to look at a different entity). Shouldn't the new and old user id be in the task update entity since 'userids' is one of the keys? Cheers, Fernando