3 Replies Latest reply on Dec 6, 2018 11:10 AM by Quang Du

    Cannot get Incident History object 'History Data' fields in a custom report type

    Dan Bontrager

      This discussion is a side discussion off of this post: Can a report type with incidents with incident history be created?

       

      I have tried a few scenarios with lookup fields, but I cannot seem to get a custom report type with the Incident History object that includes the ‘History Data’ bucket that contains the Field / Event, Old Value, and New Value fields. 

      When I create a report from the OTB report type Incident History, it has a ‘History Data’ bucket that contains the Field / Event, Old Value, and New Value fields and has the incident fields under Custom Fields:

       

      Before creating any lookup fields, I just tried creating a custom report type with primary object Incident History with a relationship to Incidents, hoping to see the Field / Event, Old Value, and New Value fields, but ‘History Data’ is not part of that custom report:

       

      I then tried to create a report type with primary object Incidents with a relationship to Incident History, but I could not select Incident History as a secondary object.

       

      I then created a lookup field from the Incident History object to Incident:

       

      I tried again to create a report type with primary object Incidents with a relationship to Incident History, and now could select Incident History based on having the lookup field:

      However, ‘History Data’ was not part of that custom report either:

       

      I then tried the reverse: I created a lookup field from the Incident object to Incident History:

       

      I tried to create a report type with primary object Incident History with a relationship to Incidents and could select Incidents based on having the lookup field:

      However, ‘History Data’ was not part of that custom report either:

      At this point, I am not sure what else I can do.  There must be a way get History Data fields I can use in reporting with custom report types that create relationships to other objects, like Categories and Category Type.