Hi everyone,
I created my own events node in CCK and specified "multiple values" for my date field to allow me to associate an event with multiple dates, and it works great when I create my nodes I can enter multiple dates. The problem comes when trying to display the event with Views.
I have my view setup as a table view showing the name of the event, and the dates. I want the one event with multiple dates grouped together so I choose "group multiple values" in the date field. This does what I want, but if i have 5 dates associated with one event, it will display the block of items 5 times. I have tried using "Node: distinct" as a filter for views, but it didn't do anything since it's not associated with multiple taxonomy terms, just multiple date fields.
I have posted a screen shot of what I mean here: http://www.children-first.ca/files/images/example.gif
Any insight would be greatly appreciated.
Comments
Solved
Looks like I solved the problem, I had specified a sort criteria of the date in ascending format. once I removed the sort it did exactly what I wanted.
---------------------------------------------------------------------
"I am a very model of a modern major general"
http://www.wiiliketopodcast.com
---------------------------------------------------------------------
"I am a very model of a modern major general"
http://www.arvinsingla.com
removing sort criteria solved this?
i had the exact same problem. so i took your advice and removed my sort criteria of date/ascending but i still have the same problem. is this the only thing you changed?
Yes, that's all I changed
Unfortunately that is all I changed to get mine working. I just removed the sort criteria completely and it worked perfectly. Have you made sure your date field is set to "Group Multiple Values" under the Handler section? This is also required to group the dates together.
---------------------------------------------------------------------
"I am a very model of a modern major general"
http://www.wiiliketopodcast.com
---------------------------------------------------------------------
"I am a very model of a modern major general"
http://www.arvinsingla.com
Luck
If this worked for you then it was luck. You probably entered your events in order from first to last. That's their "natural order" in the table and so that's the way they come out. However, I have a feeling that your luck eventually ran out. This seems totally absurd that simply removing the ORDER clause changes the behavior so drastically. There has to be a way to only show "unique" events.