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