Hi Folks,
I have a content-type, "Coming Events", which has zero or more "Happening" dates that represent the schedule for some event. I have a view which produces a block showing the brief content, one appearance per event regardless of the event schedule. So far so good.
The "natural" sort order is apparently content creation order, but I want to sort the view to list each event once by the soonest "Happening" date per event. This causes an entry in the view for EACH date in EACH event. I've tried aggregation and gotten aggravation. (-: There is no combination of view options that lets me filter the events to one occurrence per event and sort by "Happening" date. I thought I might avoid the problem with a single occurrence date field that simply copied the first "Happening" date, but I found no way to mirror a field. It is really a double selection: select the unique events then select the earliest "Happening" date, for each event. I'm not exactly sure how I'd write that in SQL, but I am reasonably sure that it can be done.
Does anybody have any insight into how this particular problem is solved?
Chris.
Hi Chris,
Do check these out
https://drupal.org/node/1565480 http://drupal.stackexchange.com/questions/4770/how-do-i-group-elements-in-a-...
Thanks Anoop
|-- | Zyxware Technologies | http://www.zyxware.com |-- | Be the change you wish to see in the world, M. K. Gandhi |--
On Tue, Oct 22, 2013 at 8:40 PM, Chris Miller cjm@tryx.org wrote:
Hi Folks,
I have a content-type, "Coming Events", which has zero or more "Happening" dates that represent the schedule for some event. I have a view which produces a block showing the brief content, one appearance per event regardless of the event schedule. So far so good.
The "natural" sort order is apparently content creation order, but I want to sort the view to list each event once by the soonest "Happening" date per event. This causes an entry in the view for EACH date in EACH event. I've tried aggregation and gotten aggravation. (-: There is no combination of view options that lets me filter the events to one occurrence per event and sort by "Happening" date. I thought I might avoid the problem with a single occurrence date field that simply copied the first "Happening" date, but I found no way to mirror a field. It is really a double selection: select the unique events then select the earliest "Happening" date, for each event. I'm not exactly sure how I'd write that in SQL, but I am reasonably sure that it can be done.
Does anybody have any insight into how this particular problem is solved?
Chris.
-- [ Drupal support list | http://lists.drupal.org/ ]
From: "Anoop John" anoop.john@zyxware.com To: support@drupal.org Sent: Tuesday, October 22, 2013 8:45:29 AM Subject: Re: [support] Content with multiple fields
Do check these out
https://drupal.org/node/1565480 http://drupal.stackexchange.com/questions/4770/how-do-i-group-elements-in-a-...
Hi Anoop,
Thanks for the help.
These don't address my case. In my case I have one field, "Happening" with zero or more values, which is causing the SQL query to return one row for each value in that one field. In no way can I group these row to express only the earliest "Happening" date for each "Coming Event".
I have tried exhaustive combinations of Grouping, "Use aggregation", and "Query settings". This may be a bug, but I don't know, because I can't find any specifications of Views to compare with my results.
It seems clear to me that I can't do what I need with Views, unless I am missing something and someone that has done this can tell me what I have fumbled. Can I do what I need with Panels or Display Suite or something else?
Chris.
Then perhaps check these out
http://drupal.stackexchange.com/questions/80229/d7-multivalue-field-displays... https://drupal.org/node/1223448 https://drupal.org/node/171226#comment-7771943
Thanks Anoop
|-- | Zyxware Technologies | http://www.zyxware.com |-- | Be the change you wish to see in the world, M. K. Gandhi |--
On Tue, Oct 22, 2013 at 10:00 PM, Chris Miller cjm@tryx.org wrote:
From: "Anoop John" anoop.john@zyxware.com To: support@drupal.org Sent: Tuesday, October 22, 2013 8:45:29 AM Subject: Re: [support] Content with multiple fields
Do check these out
https://drupal.org/node/1565480 http://drupal.stackexchange.com/questions/4770/how-do-i-group-elements-in-a-...
Hi Anoop,
Thanks for the help.
These don't address my case. In my case I have one field, "Happening" with zero or more values, which is causing the SQL query to return one row for each value in that one field. In no way can I group these row to express only the earliest "Happening" date for each "Coming Event".
I have tried exhaustive combinations of Grouping, "Use aggregation", and "Query settings". This may be a bug, but I don't know, because I can't find any specifications of Views to compare with my results.
It seems clear to me that I can't do what I need with Views, unless I am missing something and someone that has done this can tell me what I have fumbled. Can I do what I need with Panels or Display Suite or something else?
Chris.
-- [ Drupal support list | http://lists.drupal.org/ ]
From: "Anoop John" anoop.john@zyxware.com To: support@drupal.org Sent: Tuesday, October 22, 2013 9:46:28 AM Subject: Re: [support] Content with multiple fields
http://drupal.stackexchange.com/questions/80229/d7-multivalue-field-displays... https://drupal.org/node/1223448 https://drupal.org/node/171226#comment-7771943
Hi Anoop,
https://drupal.org/node/1223448 is my use case exactly ! They are even dealing with event schedules. Thanks for the help.
Chris.
-
Anoop John -
Chris Miller