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..
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@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Wipe_Out Sent: Saturday, February 23, 2013 6:21 AM To: support@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..
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@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Joel Willers Sent: Monday, February 25, 2013 5:28 AM To: support@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@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Wipe_Out Sent: Saturday, February 23, 2013 6:21 AM To: support@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/ ]
Sounds like something the Rules module might be able to handle. On Mon, Feb 25, 2013 at 11:34 AM, Metzler, David <metzlerd@evergreen.edu>wrote:
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@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Joel Willers Sent: Monday, February 25, 2013 5:28 AM To: support@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@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Wipe_Out Sent: Saturday, February 23, 2013 6:21 AM To: support@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/ ] -- [ Drupal support list | http://lists.drupal.org/ ]
participants (4)
-
Joel Willers -
Metzler, David -
Shai Gluskin -
Wipe_Out