Reporting on Rejected Change Requests

[stevekeiper]

Looking at the Change Request data, I see a field called Approval (approved rejected, no longer required etc.)  and one called Approval History (which is date based)   These values seem to record the current value/state of a given change.   In other words, if a change is rejected and never re-submitted, its easy to find in a query as its current approval value will be = rejected.   However, if the same ticket is later re-submitted and subsequently approved, the approval value updates to = approved.   How can I tell that this ticket had ever been rejected?   Does anyone know if there is a historic rejected value/date that is stored and query-able?   I want to be able to identify Changes that were never rejected and were approved the first time, and also changes that were rejected at one time, but later approved.   Have others done this with the existing data that is recorded without creating cusomt fields/data?

[Janine Miraglia]

I also have that same request.  I would like to be able to determine what state the change was in when it was rejected.

Thanks,

Janine

[mark chris]

I'd want to reopen this discussion because I'd like to obtain the same information as before, but with one more piece of information. "changes that were rejected and the state (assess/authorize) in which they were rejected" I considered making a report using the "change Request metric" database, filtering rejected modifications and grouping them by state. However, the current state of the change in the metric table is always state. Is it possible to obtain the state of change after it has been rejected? More information may be found by clicking here.

[Janine Miraglia]

The link in your response above is an incorrect link.  Please update it.  Thank you.

[Janine Miraglia]

The link above from mark chris is still pointing to a crossbow website.  Can the correct URL please be posted? Thanks.