Duplicated request feedback

[Alberto M]

Hello all.

I found that I have a request where I got duplicated feedback data from the user.

Is this something that happened to anybody here before?

What can cause this?

I'm planning to delete the duplicated records using Database Direct - will this be fine?

(sorry if this seems to be very basic questions, but I'm not yet very experienced in Hornbill Admin)

Thanks and regards,

A.

 

[ArmandoDM]

Hi @Alberto M

because h_field_type is a multiOptions (list of checkboxes) , then the same question may have multiple answers.

So, for h_feedback_question_id = 68, for example, the customer checked 2 options: the number 1 and the number 5.

It doesn't seem they are duplicates.

Regards

Armando

[Alberto M]

Thanks, @ArmandoDM

So, I need to check how the feedback is configured.

 

[ArmandoDM]

@Alberto M

yes. This is done in the Service page.  Here is a screenshot of the popup where you can create a feedback question. As you can see, you may add question of different type, including 'Checkbox group' 

 

[Alberto M]

@ArmandoDM,

 

I've checked and I have it set as "options group".

 

[ArmandoDM]

@Alberto M

let me double check for you

 

[ArmandoDM]

Hi @Alberto M

I investigated on this and actually you should have only 1 record for each multiOption , as the user is obliged to select only 1 answer.
I run a few tests and I was unable to replicate. Is this an issue currently happening  ? 

Armando

[Alberto M]

@ArmandoDM

I believe this never happened in the past - but the admin here was another person that left the company.

I can delete the unwanted responses from the feedback and leave it like that for now and try to monitor the db with a simple SQL script from time to time.

Thanks for your help and investigation.

 

[ArmandoDM]

Thank you @Alberto M

I raised a ticket internally in order to fix this issue and to prevent adding duplicates.

Armando