how to add contains, not contains like parameters in string search

[R3dian]

HI i am trying to modifying search on string in which it can not only give the results of first matching string but also in between names and that string not contains like searching. But so far i am unable to locate where to do these changes. can anybody help me out?

[R3dian]

no worries done it achieve the functionality

[yanina]

How did you fix this?

Thanks!

[rafael.q.g@hotmail.com]

Normally when I need to use custom operators on search, I customize the file list.view.php of my module, and on some method as preDisplay the attribute $query is edited with string replacements and the desired sql query is built.

[christianknoll]

I would rather use SearchFields.php ... ;-)

Normally when I need to use custom operators on search, I customize the file list.view.php of my module, and on some method as preDisplay the attribute $query is edited with string replacements and the desired sql query is built.

[rafael.q.g@hotmail.com]

You are right searchfields.php is a really better solution, I did not knew its usage.
So here is a better answer, to add contains filter in your query you could change the searchfields.php file adding to the desired field the follow code:

  'your_field'=> array(  
             'query_type' => 'default',  
             'operator' => 'subquery',  
             'subquery' => array(
                 'SELECT id FROM module_table where your_field LIKE '            
            ),  
            'db_field' => array(  
                 'id',  
             )  
        ),