I came across a problem when I added some multiple value fields to my view (integer and text fields). I tried it on a fresh install to be sure that non of my other modules is causing the problem. An example of the setup of my view:
I have a own content type called "product" which has some fields (product attributes):
Field A (text field - 1 value allowed) Field B (text field - 1 value allowed) Field C (text field - unlimited values allowed) Field D (integer - unlimited values allowed) Field E (integer - unlimited values allowed) Field F (integer - unlimited values allowed) ...
Now, I created a page view that lists all my products in form of a table and where only Field A and Field B are shown (by clicking on Field A all other details of the product is shown).
I want users to be able to "search" the product list depending on their needs. Therefore, I use the exposed sort and filter from the module Better Exposed Filter (BEF). For instance, the integer fields can be filtered by the jquery slider from BEF.
The problem is, that the view displays some products multiple times on the table. I found out that this is due to the multiple value fields. For example, if a product has 4 values in Field D, the product is listed four times. Plus, if this product has 3 values in Field E, the product is listed seven times in the view.
Struggling with this problem, I noticed that there is a setting for multiple value field within the views settings. Altought my multiple value fields are not part of the views display I added them in the views settings and checked "Hide from display". "Display all values in the same row" in the multiple field settings was already enabled. Unfortunaltely, this has no effect. This is strange because the tooltip of the setting is exactely describes my problem.
What can I do to display each product only once in the view regardless if it has multiple values for some fields? Plus, filter and sorts should work for field with mulitple values.
Does someone has experience with this?