CA Service Management

Expand all | Collapse all

Survey Report in Jasper

Jump to Best Answer
  • 1.  Survey Report in Jasper

    Posted 01-24-2018 06:28 AM

    Someone already did a Survey Results report in Jasper?



  • 2.  Re: Survey Report in Jasper
    Best Answer

    Posted 01-25-2018 05:35 PM

    Hi Paulo,

     

    The tables that need to be linked together to view the results are: survey, survey_answer, and survey_question.

     

    The survey table will give you the object_type and object_id in which you can relate back to the persid of a ticket from which a survey was completed.

    The survey_answer table is the available answer values, NOT the actual results of the survey.

    The survey_question table stores the response and any comments.

     

    Thanks,

    Scott