I was going through the views module which is a fantastic module. I can use the order by and filter, but I could not see any group by clause. Does any one know how to do that. There is a group multiple values, but I could not find what difference it made to my view.
What I want to do is something like: Create a paged list view based on a specific field say date. Using the theme wizard, I could get the group by, but the problem is that nodes per page is always hardcoded in the view, where as I need it to be dynamic, because if the date A has (say 10 nodes) then it should show 10 nodes, and when I click on the page2, it should automatically show the number of nodes for dateB (and there could be just 5 nodes for dateB).
PS: I can use the argument field for date and get a list of all nodes for that date, but that is not what I want. I hope I could make it clear, for example it would look like:
1 2 3 4 5 .... next>> Last>>
clicking on 2/next should show:
1 2 3 4 5 .... next>> Last>>
If there was a group by clause at the view definition and not at the theme level this should be easily possible. Right now the number of node is hard coded in the nodes per page defined for that view.
Thanks.
