I’ve been tasked with updating a drupal site for work. One of the errors that has been reported is that the view of a webform submissions is displaying duplicate entries. There are two types of webform submissions that are stored in the same database with different nid’s.
I’ve tried using the distinct in the query settings, as well as the aggregate settings turned on. It does filter out the duplicates, however it shows all values in the webform submissions database. I have the filter criteria set to have the nid equal to the number needed for this view. However in order to filter out distinct, I change the filter criteria from “group together” to “count distinct”.
I have been looking all over the internet for answers and just keep hitting dead walls.