Query Builder - State promotion date

[Darquise]

I'd like to create a report that will generate a list of my custom type at a specific state. Basically, I would search to see if the state changed between a certain date.

Which type and attribute do I add to my query build to get the state and date information?

[MikeLockwood]

State changes are shown as "Maturity History for each object on it's info pages and available Query Builder as Life Cycle History type, with the timestamp when the object reached a certain state as the "Created" date of that event.

Join Life Cycle History to your object type.

Use fixed criteria:

- Object.state = (select the state you care about)

- Object.Action = Enter_Phase

Enter date range of interest when running the report.

Results will be the timestamps when each object reached the state within the date range. On the select tab, include the object.