AnsweredAssumed Answered

How are change requests and users related?

Question asked by Paul Duer on May 16, 2016
Latest reply on May 16, 2016 by Ryan Godfrey

Can someone give me a primer on how Change Requests for Accesses are related to the Users that they are requested for?


Really I am looking for the SQL. Most of the report requests we have open are for reports that will show Request numbers with ALL the users that they are requesting. We know that it's a bulk action, that 1 change request can have many users or just one.


I am using the Public View tables, as I should. Can someone give demonstrations of the SQL that will relate a PV_Change_Request to the users that the request is for?


We're on VIA 6.9.1