Dan Stewart Posted June 6, 2024 Posted June 6, 2024 Hi everyone - hoping someone has the knowledge to help me out with a request that has come my way. Without going into too much detail, we have a Service Request for 'access to a mailbox', one of the questions within the intelligent capture form is a drop down list asking if it is for a 'generic mailbox' or 'personal mailbox' - does anyone know how to produce a report that would query a specific question/answer within an intelligent capture form so that I can provide the results of how many 'personal mailbox' requests we have had in a specific period? Any help would be much appreciated.
Steve Giller Posted June 6, 2024 Posted June 6, 2024 Intelligent Capture answers are stored in the h_itsm_questions table. The h_entity_ref column holds the Request ID so you can link to the Requests table if required, and the h_form_id column the name of the form within the Capture. 1
Sam P Posted June 7, 2024 Posted June 7, 2024 My report is written slightly differently (no expert here ) I join the Tables like this and then add a filter. You can't use more than one question per report though, which is a shame. 1
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now