Jump to content

A report that queries the answers within a question on an intelligent capture form


Recommended Posts

Posted

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.

Posted

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.

  • Like 1
Posted

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.

image.png.9ca3246fe8abe5b1270c86c69ffecdf8.png

image.png.fe39357cd91d4f0e31d05ededf12721b.png

  • Like 1

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...