How to query the form that not released but approver is quit (inactive)

Hi,

How to query the form that not released but approver is quit (inactive) by SQL ?

for example change form.

tnanks.

Agile User Asked on February 5, 2020 in Agile PLM (v9).
Add Comment
1 Answer(s)

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).

Agile Angel Answered on February 5, 2020.

Hi Kevin,

Very thank you.

on February 6, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.