Webform submission view filter for multivalues

Created on 19 July 2019, almost 5 years ago
Updated 6 December 2023, 7 months ago

When I trying to filter the webform submission using a multivalue field, it shows the results not found.

The webform has a field Activity and it's a multiple selction option.

That means, if the differnet activitys are a,b,c,d,e.... then the field Activity can contain

  • a,b
  • b,c
  • a,b,c
  • ....

For this criteria, the views filter for Activity not working properly.

Please help.

🐛 Bug report
Status

Needs work

Version

5.0

Component

Code

Created by

🇮🇳India Rahulmon Johnson Cochin

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

  • Open in Jenkins → Open on Drupal.org →
    Core: 9.5.x + Environment: PHP 5.3 & MySQL 5.5
    last update about 1 year ago
    Composer error. Unable to continue.
  • 🇩🇪Germany daveiano

    Patch from #13 applies on 8.5 and solves the problem for me

  • 🇩🇪Germany stefan.korn Jossgrund

    If I am using patch from #13 I get a lot of duplicate result rows and also cannot get rid of them neither by filter setting for reducing duplicates nor by view database distinct setting.

    But if I only use first part of the patch, it works nice. No duplicate result rows and can filter after each delta value.

    I am absolutely not sure what is happening in the first and second part, so probably I am misunderstanding something here. But patch from #13 does not help in my case.

  • 🇩🇪Germany achikas Lower Saxony, Germany

    just installed patch #17 and now i can filter over all used taxonomy terms. thx @stefankorn
    i also need to get rid of the duplicates that the view will show now for any used term.

  • 🇩🇪Germany stefan.korn Jossgrund

    Yes, the unfiltered view still shows duplicates. I did not realize this yesterday, but with the full patch I get a lot of more duplicates.

    Seems to me that this is not the right solution either full patch or half patch. It is probably hard to solve because of the way that webform stores multiple values.

  • #17 worked for me but did create duplicates. However, I was able to fix by enabling Aggregation under the Advanced settings and also checking the Distinct checkbox under Query settings.

  • #17 works for me. I'm not seeing any duplicates (this might be because I only have a small number of results submissions).

Production build 0.69.0 2024