Skip to main content

Hi everyone!


I have a question about the Time Tracking column.


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):

Screenshot 2023-09-21 at 10.57.18


In 2023-07, I could use the field ‘additional_info’ to gather the info on the sessions:

Screenshot 2023-09-21 at 10.56.20


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.

hi @Vania_Omnidea


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

  }

}

image

Amazing, this is exactly what I was looking for! Thanks!

Thank you very much @basdebruin !!

Reply


Terms & ConditionsCookie settings