<div dir="ltr">Sounds like something the Rules module might be able to handle.<br></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Mon, Feb 25, 2013 at 11:34 AM, Metzler, David <span dir="ltr"><<a href="mailto:metzlerd@evergreen.edu" target="_blank">metzlerd@evergreen.edu</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">You're going to at minimum write custom SQL, but if you're wiling to do that, consider <a href="http://drupal.org/project/forena" target="_blank">http://drupal.org/project/forena</a> which will help you get from SQL to presentation.<br>
<br>
Full Disclosure: I'm the maintainer of that module.<br>
<br>
Dave<br>
<div class="HOEnZb"><div class="h5"><br>
-----Original Message-----<br>
From: <a href="mailto:support-bounces@drupal.org">support-bounces@drupal.org</a> [mailto:<a href="mailto:support-bounces@drupal.org">support-bounces@drupal.org</a>] On Behalf Of Joel Willers<br>
Sent: Monday, February 25, 2013 5:28 AM<br>
To: <a href="mailto:support@drupal.org">support@drupal.org</a><br>
Subject: Re: [support] Filter views by comparing two fields?<br>
<br>
You'd have to break into the code for that. You could programmatically call the View (probably the best bet) or you could go into the Views display and do a test in there (not suggested).<br>
<br>
Joel<br>
<br>
<br>
From: <a href="mailto:support-bounces@drupal.org">support-bounces@drupal.org</a> [mailto:<a href="mailto:support-bounces@drupal.org">support-bounces@drupal.org</a>] On Behalf Of Wipe_Out<br>
Sent: Saturday, February 23, 2013 6:21 AM<br>
To: <a href="mailto:support@drupal.org">support@drupal.org</a><br>
Subject: [support] Filter views by comparing two fields?<br>
<br>
Hi,<br>
<br>
I have a content type with two date fields both with start and end dates..<br>
<br>
I need to create a view filter that if the start date and time of fieldA is more than 15 minutes before or after the start date and time of FieldB then show it in the view..<br>
<br>
Obviously views can compare dates to "now" or now relative to a time period but I can't see a way for views to filter based on the comparison of the value of two fields..<br>
<br>
Anyone have any ideas?<br>
<br>
Thanks..<br>
--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br>
--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br>
</div></div></blockquote></div><br></div>