Forums

Hi, Im a bit lost on filtering in Ftrack. From the web interface using the Task view I have a Task Query filter.    name is "Animation"  and  status.name is "Approved" and ( status_changes.date > 2024-07-01 and status_changes.date < 2024-07-10 ) But the status_changes.date isn't really doing what I want. I want to find all Shots where the task "Animation" his status changed within a certain time frame and I only want to list the ones where the task status is "Approved".  In the result I seem not to be able to change the before part of the date. So changing 2024-07-10 to 2024-07-02 has no influence at all. What's the proper way to filter on status changes between a certain time range? Thanks!    

Hi TJ all these types of urgent queries are best to be sent into support at ftrack.com.  currently there isn't a way for you to restore the data but support cna help you do that.  if you supply the name of the project and what was deleted, and when it was deleted we can restore those for you. in order to restore it is also important that the objects and tasks that were deleted are not recreated with the same Names otherwise there will be a conflict when trying to restore. you can use the api to query for deletion, but it is not shown in the UI.

This is great, thanks Daniel!

Hi Emma, no the left hand side Navigator always displays a summary, though you can change it from displaying the STATE colors to the Status colors that is under system settings>workflow>settings>Show status in progress also when you mark certain objects in the hierarchy with a status that is of the STATE of BLOCKED it will show the line items as being struck out also the outliner on the left acts as a filter for the Task, Versions spreadsheets and Dashboards part of the page so you can quickly drill into the details by using the combination. Cheers, Daniel