<div dir="ltr"><div>Chris,<br><br>For showing only 2 items, you can use Distinct Node, which will fetch only distinct results, hence removing any duplicates.<br><br></div>Secondly, for the dates, you will have to add another check, where date is higher than todays or some specified date, I believe this should help you in fetching the desired result.<br>
</div><div class="gmail_extra"><br><br><div class="gmail_quote">On Wed, Nov 20, 2013 at 5:06 AM, Chris Miller <span dir="ltr"><<a href="mailto:cjm@tryx.org" target="_blank">cjm@tryx.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div><div style="font-size:10pt;font-family:arial,helvetica,sans-serif"><div>Hi Folks,<br></div><div><br></div><div>I have a really sticky problem.</div><div><br></div><div>I have a content-type called "Coming Event" which has zero or more dates that represent the occurrence of the event. I have a view of these where I want each coming event to appear exactly once in the order of the earliest date in their list. So, let's suppose I have Event A and Event B and they are happening in this order A, B, B, A, B. My view should show me "A B". After the first completion of A, I should see "B A". So this is not a difficult idea.<br>
</div><div><br></div><div>Any sort that I specify results in one row for each date, so in the case of my example, I see five entries in my view. I should be able to aggregate these rows by some field, but I can't seem to find the magic formula and I get, believe it or not, HTML instead of rendered pages.<br>
</div><div><br></div><div>I expect there to be a filter problem as some of the dates pass and are filtered out, and I don't know if that will be independent of this question.<span class="HOEnZb"><font color="#888888"><br>
</font></span></div><span class="HOEnZb"><font color="#888888"><div><br></div><div><span name="x"></span>Chris.</div></font></span></div></div><br>--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br></blockquote></div><br><br clear="all"><br>-- <br>Regards,<br>Vaibhav Jain
</div>