Remus Avram Posted April 7, 2017 Report Posted April 7, 2017 Hi, is it possible to get the sequence name in the Expression of a custom attribute?
Mattias Lagergren Posted April 8, 2017 Report Posted April 8, 2017 On 07/04/2017 at 8:07 AM, Remus Avram said: is it possible to get the sequence name in the Expression of a custom attribute? No I'm afraid not. The expressions are quite limited in how you can traverse upwards or downwards in the hierarchy.
Remus Avram Posted April 10, 2017 Author Report Posted April 10, 2017 I understand. Then we will do it with an action.
Remus Avram Posted April 13, 2017 Author Report Posted April 13, 2017 Are there any plans to improve the query into the expression custom attribute? Where is this helpful? At the moment, our production keeps the daily/weekly client report into an excel file and share between them. Really old school :). We created some custom attributes in Ftrack and a view, similar to the excel sheet, and whenever they want to send the report to the client, they export the view to excel. It works pretty nice for them. They like it. But unfortunately, they still need to fill in all the information manually. And there are quite a lot of custom attributes and shots/asset builds. But actually, all the custom attributes can be automated based of the existing data. Noting should be fill in manually. One workaround is to use actions, but a better approach is to set them as an expression. Unfortunately, at the moment the query in the expression is quite limited....
Mattias Lagergren Posted April 13, 2017 Report Posted April 13, 2017 Hi Remus, thank you the background it is always nice to hear how things are used. The expression attributes are definitely a bit limited in what they support, but at the moment we're not sure how to best move on with this advanced feature. Reason being that the expression attribute is heavily based on the old backend and does not have any support in our new API. We've been considering alternative solutions (a expression attribute 2.0 if you will): Allow the user to emit an event in the spreadsheet and remotely load data to the columns using event listers + our api. This gives maximum freedom and could even be used to access external systems or fetch custom data from somewhere else. Have something that works the same way as expression attributes but leveraging our new api syntax and technology. These are things that we still discuss and are just ideas being tossed around at the moment. Back to your use-case; I would suggest having an action to export these excels. That should give you maximum freedom for this whilst removing the need to do manual work in those excel sheets.
Remus Avram Posted April 13, 2017 Author Report Posted April 13, 2017 Thank you for your answer! Regarding the client report, we will create an action to export the excel sheet. I will let you know the progress. Regarding the custom attributes, we will be happy if it will get improved and we can query data for multiple levels.
Conor Bowes Posted September 29, 2017 Report Posted September 29, 2017 Is there still no way to access parent information data from these expressions? Something as simple as parent.name would simplify our sorting requirements quite a lot
Mattias Lagergren Posted October 3, 2017 Report Posted October 3, 2017 On 29/09/2017 at 3:45 AM, Conor Bowes said: Is there still no way to access parent information data from these expressions? Something as simple as parent.name would simplify our sorting requirements quite a lot I'm afraid that is the case and I do not have any dates on when it will be available.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.