AnsweredAssumed Answered

List of All Files pending transition action from _a_particular_user

Question asked by Sameer Kelkar on Jul 15, 2020
Latest reply on Jul 21, 2020 by Sameer Kelkar

I need to come up with list of files which are pending transition action from a particular user.

 

For example I need to know list of all '%.SLDDRW' files which are pending for review from 'USER_A' where in 'USER_B' and 'USER_C' _might_ have reviewed them.

 

Once the 'USER_A' reviews the file he moves the file into a one of  the appropriate states. 

 

I am trying to use TransitionHistory table along with User but being new to SQL and internals of PDM databases I am finding it difficult.

 

Any help is much appreciated

Outcomes