[support] Filter views by comparing two fields?

[Metzler, David]

You're going to at minimum write custom SQL, but if you're wiling to do that, consider http://drupal.org/project/forena which will help you get from SQL to presentation. 

Full Disclosure:  I'm the maintainer of that module. 

Dave

-----Original Message-----
From: support-bounces at drupal.org [mailto:support-bounces at drupal.org] On Behalf Of Joel Willers
Sent: Monday, February 25, 2013 5:28 AM
To: support at drupal.org
Subject: Re: [support] Filter views by comparing two fields?

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).

Joel 


From: support-bounces at drupal.org [mailto:support-bounces at drupal.org] On Behalf Of Wipe_Out
Sent: Saturday, February 23, 2013 6:21 AM
To: support at drupal.org
Subject: [support] Filter views by comparing two fields?

Hi,

I have a content type with two date fields both with start and end dates..

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..

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..

Anyone have any ideas?

Thanks..
-- 
[ Drupal support list | http://lists.drupal.org/ ]