custom attribute Custom attribute timestamps

[TeJa TJ]

Hi Ftrack Community and Team,

In my recent client project, I got a request to retrieve first and last stamp of boolean type custom attributes when they are checked. Therefore, I have gone through the api reference but the custom attribute entity has no attribute that helps my query. 

Can you please suggest me a way or approach to tackle this problem?

Product>custom_attributes : ContextCustomAttributeValue {} > 

ContextCustomAttributeValue

entity_id : string * Primary key immutable

configuration_id : string * Primary key immutable

configuration : CustomAttributeConfiguration

key : string

value : variable

 

Best regards,

TJ

[Lorenzo Angeli]

Hi @TeJa TJ

to see when  a custom attribute has been last changed you can query the Event entities as such:
 

custom_attribute_events = session.query(select insert, parent_id from Event where insert is "update.custom_attribute" and parent_id is "<your-task-id>").all()

this will return an Event object which will hold the timestamp on the created_at field and the previous and current value under the data field

hope it helps.
L.