How can I report on feedback multiline text from incident surveys where they are not satisfied?

[rdriemeyer]

Been playing with some of the asmt_assessment tables but no luck so far.

[Mekhala · Accepted solution]

HI @rdriemeyer ,

You can check first which survey is used for incidents (table: asmt_metric_type) then check on respective Metric categories and trigger conditions for the survey.

asmt_assessment and asmt_metric_result table could help to distinguish on surveys values received.

Kindly mark helpfull if this answers your query.

Thanks,

[rdriemeyer]

Also, I can find the string value with positive and negative feedback (comments) but the values types are all equal to -1 in this table so I can't find a way to only get the negative feedback.

[Mekhala · Accepted solution]

HI @rdriemeyer ,

You can check first which survey is used for incidents (table: asmt_metric_type) then check on respective Metric categories and trigger conditions for the survey.

asmt_assessment and asmt_metric_result table could help to distinguish on surveys values received.

Kindly mark helpfull if this answers your query.

Thanks,

[Mekhala · Accepted solution]

Hi @rdriemeyer ,

There should be one particular question which is deciding the survey is satisfied or dissatified. 

Please check on the Questions asked on survey form and its value range.

Thanks