Hi everyone,
As a possible solution, you can check the "ReviewEvent" table. The event type for the phase change is 4. Ref1id is the old phase, and ref2id is a new phase, so you need to find rows that have the event type of 4 and ref2id of the needed phase, for example, 5 - completed.
So, you can look at all rows with event type 4 to view the phase changes. When you see ref2id with a value of 5, this means that the review was transferred to the completed phase. When you see ref1id of 5, that is a re-open phase, or a transition out of the completed phase. Don't always expect the review to go from the inspection phase to 'completed'. In fact, they can be transferred from almost any phase to completed if certain conditions are met. So, when you need the review to be transferred to the completed phase, don't specify any particular ref1id in your SQL.
Here are the current phase values:
1 Planning
2 Inspection
3 Fix Defects
4 Unused
5 Completed
6 Cancelled
7 Rejected
8 Annotating
Otherwise, you can check the "Notification" table that contains the triggered notifications. So, you can check the Notification title ("Review #.. canceled" or "Start inspection on new Review #.. (re-opened)") to determine the activity and the "Notification_CreatorID" value to find who causes it.
I hope this information helps!
