I am interested in getting the single sessions’ data from the audit log of the time tracking column in my subitems (e.g., the two sessions in the screenshot):
However, I cannot find a way to do the same in 2023-10. Any ideas to get to the same output? For my use case, downloading the Excel file manually or clicking on the audit log from the UI is a bit inconvenient.
See: Time tracking and the history field. That field provides the same info in a much more structured way. Try below query in 2023-10. The time_tracking column supports history which gives you an array of objects with all kind of useful information.
{
items(ids: 123456789) {
column_values {
id
value
... on TimeTrackingValue {
history {
status
ended_at
started_at
started_user_id
manually_entered_end_date
}
}
}
id
}
}
