Hello! I’m new to shotgun, and I’m currently playing around with filters, and I’m wondering if there’s a way to do this specific ‘Late Feedback’ query within the web UI:
Any tasks that were changed to the status ‘Sent to Client’ more than two days (48hrs) ago (floating day).
Or similarly, finding any tasks that were changed from a certain status to another within a date range.
I achieved this in Ftrack through their advanced query/SQL and was wondering if Shotgun can do so without usage of the API. I love the selection of filter options in Shotgun, just having trouble finding this kind of filter.