How to query the form that not released but approver is quit (inactive)
Something like this should work :
select c.change_number, u.first_name || ‘ ‘ || u.last_name || ‘ (‘ || u.loginid || ‘)’
from change c, agileuser u, signoff s
where c.statustype not in (3,4)
and c.id = s.change_id and s.signoff_status = 0
and s.user_assigned = u.id and u.enabled = 0;
STATUSTYPE is used to define which state of a workflow the change is in, 3=Released and 4 = Implemented. It is not released if it is not in one of those values. Note that 0=Pending, 1 = Submitted, 2 = Review, 5 = Hold and 6 = Cancel. For SIGNOFF_STATUS, 0 means that the workflow is awaiting approval from the given user. And for users, ENABLED indicates if a user is active or not (0=Disabled, 1 = Enabled).