Add custom filter for CCK Datetime Fields

You could use hook_apachesolr_modify_query(). See also #632962: Using hook_apachesolr_modify_query()

/**
 * Implementation of hook_apachesolr_modify_query
 */ 
function YOUR_MODULE_apachesolr_modify_query(&$query, &$params, $caller) {
   // Do the magick here
}

The above snippet is to alter the query. It's not a configurable filter.

For creating a configurable filter, you need to implement 2 hooks
hook_views_handlers()
hook_views_data()
and most likely implement a handler which extends one of the views_handler_filter subclasses.

There is no date filter for apachesolr_views yet, so I would put this now under a feature request. So, try to look at how Scott has made the other filter handlers and try perhaps to extend the views_handler_filter_date class.

Well you can't use views_handler_filter_date but instead you need to extend it and make a date filter for apachesolr_views. Check out how the other filter handlers are extending the default views handlers and override the query() function. So this work is a little OO coding, rather than the usual procedural coding.

I'm not a guru on this matter, but I have been trying to do the things you are doing now with my own CCK fields. However, that didn't include a date field yet. Sorry I can't help any further.

Hi, I'm looking to do something really similar to adding a custom filter, but to reflect different currencies, i.e. a drop down list of three options 'GBP', 'USD', and 'Others'. I'm not sure if this is as complicated as the current issue here. Am I best creating a new issue to request support? or just add it here?

So far I've got new fields added to the index, one called 'ss_cck_price_currency', which takes its input from the Money CCK module. I would now like to add a filter which can be exposed to users allowing them to select from either 'GBP', 'USD', and 'Others'.

I think I need to code like this below, but I don't know what I'm missing? I've been updating this post as I've been trying more code out. Here's the latest....

Any advice?
cheers
scotjam

in my custom module...

	function extras_views_api() {
	return array('api' => '3.0-dev');}

	function extras_views_data_alter(&$data) {
		$data['apachesolr_node']['ss_cck_price_currency'] = array(
			'title' => t('Currency type'),
			'help' => t('Currency type. Drop down box with either USD, GBP or All Others'),
			'filter' => array(
			'handler' => 'apachesolr_views_handler_optionwidget_filter',
			),
			);
        }

in extras.views.inc...

<?php

/**
 * Implementation of hook_views_handlers() to register all of the basic handlers
 * views uses.
 */
function extras_views_handlers() {
  return array(
    'info' => array(
      'path' => drupal_get_path('module', 'extras'),
    ),
    'handlers' => array(
      'extras_views_handler_filter_currency' => array(
        'parent' => 'views_handler_filter_in_operator',
      ),
    ),
  );
}

in extras_views_handler_filter_currency.inc

<?php

class extras_views_handler_filter_currency extends views_handler_filter_in_operator {
  function get_value_options() {
      $options['USD'] = 'USD';
      $options['GBP'] = 'GBP';
      $options['Others'] = 'Others';
      $this->value_options = $options;
  }
  
  function operator_options() {
    return array(
      'in' => t('Is one of'),
    );
  }

  public function query() {
    if (empty($this->value) && ($this->options['exposed'] && empty($this->options['expose']['optional']))) {
      // Add term that will yield no results
      $this->query->add_filter('nid', apachesolr_views_query::escape_term('-1'));
    }
    else {
      $this->get_value_options();

      foreach ($this->value_options as $type => $name) {
        if (!in_array($type, $this->value)) {
          $this->query->add_filter($this->real_field, $type, TRUE);
        }
      }
    }
  }
}

Latest update... I've updated to code above since originally posting, and it appears now to work! Though it's all hardcoded.

Can someone kindly check if this looks right? and suggest improvements to avoid hard coding?

+1

Something related: #642430: Date argument handlers for created and updated fields, but as arguments.

related, but for core node date fields: #595610: Node Creation/Change date filter

Version 6.x is no longer supported due to Drupal 6 End of Life. For Drupal 8.x, use Search API Solr Searchinstead.