passing a word as an argument to a views 'filter' condition

Hi, i think that something like this will do the job :

  $view = views_get_view('my_view');
  $view->exposed_input['my_filter']= 'the word or var with the word';
  
// the type of display for the view
  $result = $view->preview('default');
 
  print $result;

If the word is in the url you can get it with arg() or $_GET[' ']

Hi,

I think you should be using an argument condition not a filter condition.

Change your filter to an argument.

Andrew

Add an argument instead of a filter.

A views argument acts as a variable filter. It is generally read from within the URL so the URL entered will be something like www.mysite.com/myview/titleword.

Have a look at the documentation on views arguments. You may need to use PHP code if the avaqilable argument options don't give you what you want.

Hello there,
To give a solution to your problem, I created a view and used arguments. Please follow the steps below :
1. Create a new view
2. Add Page display
3. Give path to page "myview/%"
4. Select appropriate fields you want to show.
5. Click + of arguments (To add an argument)
6. Select Node : Title and add
7. Give some title
8. Select "Display empty text" (You'll have to give some value in Empty field)
9. Case in path : Lower case
10. Check : Transform spaces to dashes in URL
11. Update
11. Save the view

Now go to "www.yoursite.com/myview/test node" and you will see if you have any node named "Test Node".
Now the limitation I saw is that it will perform exact match and return only single node.
It will not display anything if you will simply give "www.yoursite.com/myview/node"

I am not pretty sure how to make it search part of the title. For example, if I give "/myview/test" then it should display all the nodes with the word test in title rather then single node with title Test.

Can anyone put some light on this? It will be enlightening me as well.

Thanks in advanced.

This is a view that will display nodes with a keyword in the url if you go to node/% where % is the keyword you want to filter on. So if you go to www.mysite.com/node/test it will only list nodes with 'test' included in the title. If you need to change the url architecture to something like node/mine/cars/test, then you will need to modify the arg() function in the code.. See arg() in the handbook.

$view = new view;
$view->name = 'test';
$view->description = 'test';
$view->tag = '';
$view->view_php = '';
$view->base_table = 'node';
$view->is_cacheable = FALSE;
$view->api_version = 2;
$view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */
$handler = $view->new_display('default', 'Defaults', 'default');
$handler->override_option('fields', array(
'title' => array(
'label' => 'Title',
'alter' => array(
'alter_text' => 0,
'text' => '',
'make_link' => 0,
'path' => '',
'link_class' => '',
'alt' => '',
'prefix' => '',
'suffix' => '',
'target' => '',
'help' => '',
'trim' => 0,
'max_length' => '',
'word_boundary' => 1,
'ellipsis' => 1,
'strip_tags' => 0,
'html' => 0,
),
'empty' => '',
'hide_empty' => 0,
'empty_zero' => 0,
'link_to_node' => 1,
'exclude' => 0,
'id' => 'title',
'table' => 'node',
'field' => 'title',
'relationship' => 'none',
),
));
$handler->override_option('arguments', array(
'title' => array(
'default_action' => 'default',
'style_plugin' => 'default_summary',
'style_options' => array(),
'wildcard' => 'all',
'wildcard_substitution' => 'All',
'title' => '',
'breadcrumb' => '',
'default_argument_type' => 'php',
'default_argument' => '',
'validate_type' => 'none',
'validate_fail' => 'not found',
'glossary' => 0,
'limit' => '0',
'case' => 'none',
'path_case' => 'none',
'transform_dash' => 0,
'id' => 'title',
'table' => 'node',
'field' => 'title',
'validate_user_argument_type' => 'uid',
'validate_user_roles' => array(
'2' => 0,
'3' => 0,
'4' => 0,
),
'relationship' => 'none',
'default_options_div_prefix' => '',
'default_argument_user' => 0,
'default_argument_fixed' => 'test',
'default_argument_php' => '$keyword = arg(1);
return $keyword;
',
'validate_argument_node_type' => array(
'product' => 0,
'seminar' => 0,
'ucnc_document' => 0,
'anytime_seminar' => 0,
'credit_letter' => 0,
'infoblock' => 0,
'page' => 0,
'question' => 0,
'story' => 0,
),
'validate_argument_node_access' => 0,
'validate_argument_nid_type' => 'nid',
'validate_argument_vocabulary' => array(
'2' => 0,
'1' => 0,
),
'validate_argument_type' => 'tid',
'validate_argument_transform' => 0,
'validate_user_restrict_roles' => 0,
'validate_argument_php' => '',
),
));
$handler->override_option('access', array(
'type' => 'none',
));
$handler->override_option('cache', array(
'type' => 'none',
));
$handler = $view->new_display('page', 'Page', 'page_1');
$handler->override_option('path', 'node/%');
$handler->override_option('menu', array(
'type' => 'none',
'title' => '',
'description' => '',
'weight' => 0,
'name' => 'navigation',
));
$handler->override_option('tab_options', array(
'type' => 'none',
'title' => '',
'description' => '',
'weight' => 0,
));

Just copy the above code and import it into a view. Keep the $5.

Okay. This is the way to go. ussher nailed it.

I had put off learning to make a module and that was a mistake. It's drop-dead simple.

This solution is the bomb. Ignore all of my blathering in the succeeding posts.

I followed the module building tutorial for Drupal 6 here and below is the contents of the two files necessary to implement the fix.

view_query.info

<?php
name = View Query
description = Customize View queries
core = 6.x
dependencies[] = views 
version = "6.x-1.0"
?>

view_query.module

<?php
/**
* Display help and module information
* @param path which path of the site we're displaying help
* @param arg array that holds the current path as would be returned from arg() function
* @return help text for the path
*/
function view_query_help($path, $arg) {
  $output = '';  //declare your output variable
  switch ($path) {
    case "admin/help#view_query":
      $output = '<p>'.  t("Supplies modified queries to Views") .'</p>';
      break;
  }
  return $output;
} // function view_query_help

/**
* Valid permissions for this module
* @return array An array of valid permissions for the view_query module
*/
function view_query_perm() {
 return array('access view_query', 'create view_query', 'administer view_query');
} // function view_query_perm()

/* DEBUG */
/*
function view_query_views_query_alter(&$view, &$query) {
    if($view->name == 'title_search'){
       print_r($query);
    }
}
*/

function view_query_views_query_alter(&$view, &$query) {
    if($view->name == 'title_search'){
     $query->where[0]['clauses'][0] = "node.status = 1";
     $query->where[0]['clauses'][2] = "node.type in ('comic', 'blog')";
     $query->where[0]['clauses'][1] = "LOWER(node.title) LIKE LOWER('%%%s%')";
    }
}
?>