I have 5 different webforms which all share a common select option data field (e.g. status: submitted, in progress, completed or rejected). I have successfully created a view which shows a summary of all the webform submissions, along with the STATUS field. However, I am unable to add a filter to the view based on the status field (i.e. I want to show ALL of the webform submissions which are in a Completed Status). I have both the data fields for each form defined in the view, as well as the corresponding relationship defined. I came across the Webform MySQL Views module which looks like it might work, but I saw one forum entry that it is not longer supported on the 4.x version of Webform. It also looks like a nightmare to implement. Suggestions?

Comments

DanChadwick’s picture

Status: Active » Fixed

Filtering requires the raw data which is accessed by a relationship. You will need to ensure that your status field has the came component id in all your webforms. This may be difficult to achieve if they aren't all clones of each other. I can't recommend editing the database directly, but that is what I would do. You may break the database and need a restore.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.