How to find the user who made an edit using Lookback API

Products

• Rally On-Premise
• Rally SaaS

Issue/Introduction

How to find the user who made an edit using Lookback API

Environment

Release:
Component: ACSAAS

Resolution

Per Lookback API documentation, there is a _User field specific to LBAPI:

• _User. User who made the edit

Note this this field is not directly available in WS API. It is possible to get to the author of a revision in WS API indirectly by traversing from RevisionHistory to Revisions collection to individual revision object and eventually to User on that revision, but it is cumbersome and inefficient.

Here is an example of a LookbackAPI endpoint that returns user stories where ScheduleState was changed from Completed to Accepted:

https://rally1.rallydev.com/analytics/v2.0/service/rally/workspace/<WORKSPACE_OID>/artifact/snapshot/query.js?find={"Project":<PROJECT_OID>,"_TypeHierarchy":"HierarchicalRequirement","ScheduleState": "Accepted", "_PreviousValues.ScheduleState": "Completed"}&fields=["ObjectID","_ValidFrom","_ValidTo","FormattedID","ScheduleState","_PreviousValues.ScheduleState","_User"]&hydrate=["ScheduleState","_PreviousValues.ScheduleState"]&compress=true

Here is an example of result:

• {

  • _ValidFrom: "2013-06-17T18:54:21.112Z",
  • _ValidTo: "2013-10-31T23:24:31.304Z",
  • ObjectID:<OBJECT_ID> ,
  • _User:<USER_OID> ,
  • ScheduleState: "Accepted",
  • _PreviousValues: {

    • ScheduleState: "Completed"

    },
  • FormattedID: "US7"

  },

User cannot be hydrated in Lookback API.