Hi All,
Is there a table or a view in RSA database where the change request's additional information will be stored?
When a user is performing the approval, there is a section called "Additional Information". Please let me know in which table or view, this data will be stored? Below screenshot for reference.
Regards,
Devani N
Thank you for sharing details
Further to that I would echo the caution from Mostafa Helmy. You do not want to be trawling through that table to try find information in the workflow(s) for a change request. They are variables you have created yourselves anyway elsewhere in the overall request workflow, so you can refer to them in email/SQ/decision/etc. nodes as you will.
Couple of things to bear in mind …
Hope this helps.
I believe these are your workflow variables that you can easily access them from the workflow context.
They are stored in some internal WorkPoint table WP_USER_DATA (no views available) so I wouldn't really recommend doing and reports against those tables. Keep in mind that if you do write any heavy SQL queries/reports against internal workflow tables, this will affect the overall performance and, potentially, stability of all your workflows and environment.