We have created a request form called "XYZ mandatory leave". Now I want to pull this request form report from Reports -> Tabular -> Create Report, but unable to do so as there is no option to pull reports for request forms. I think we need to write a custom query for this. If its a custom Query Any help on this issue is greatly appreciated.
Thanks,
Nikhila
Hi Boris,
Thank you for the reply.
I tried that but I can see only a request form name with some other fields. My requirement is to Pull a request form with users data who requested for particular form and with start date, completion date of the request.
Thanks,
Nikhila
try using PV_CHANGE_REQUEST view, column FORM_ID
Similar post - Is there a way to audit Form usage
Hi Boris,
I tried but sorry it is not working . Please see the below screenshots.
Thanks,
Nikhila
with regards to query1.png: you need to write a SQL query
When I wrote "try using PV_CHANGE_REQUEST view, column FORM_ID", I meant that you should use the public view PV_CHANGE_REQUEST to retrieve the relevant change request information.
You can use the FORM_ID (in PV_CHANGE_REQUEST) column to perform a join between PV_CHANGE_REQUEST and PV_CHANGE_REQUEST_FORM
with regards to query2.png:
You should add avuser. before PV_CHANGE_REQUEST_FORM.
There is no FORM_ID column in PV_CHANGE_REQUEST_FORM
Here is an example:
(select id as form_identifier from avuser.PV_CHANGE_REQUEST_FORM)
Try avuser.PV_CHANGE_REQUEST_FORM