Finding the search fireEvent call

odannyc

I'm looking to modify the search function to limit the search to only some categories.

After hours of looking around, I came to this piece of code that builds out the where clause: $this->fireEvent('Search');
Can someone point me to the right direction in where this get's built out?

R_J

That event is fired by the search model. What makes it quite hard to work with it is that there are no useful EventArguments.

The SearchModel holds an array _SearchSql which comprises different sqls. They are filled by e.g. the VanillaSearchModel to the SearchModel. This way other addons, like the articles addon, can add their custom search sql. And the result is, that also custom content can be searched if the addon author implemented that.

But sadly, you do not have access to those sqls. With the event AfterBuildSearchQuery you could get access to the (not yet) finished text sql, but you most probably do not want to start changing that by adding some regex transformations here...

Look at the code:

$this->EventArguments['Search'] = $Search;
$this->fireEvent('Search');

(...)

// Perform the search by unioning all of the sql together.
$Sql = $this->SQL
    ->select()
    ->from('_TBL_ s')
    ->orderBy('s.DateInserted', 'desc')
    ->limit($Limit, $Offset)
    ->GetSelect();

(...)

$this->EventArguments['Sql'] = $Sql;
$this->fireEvent('AfterBuildSearchQuery');

At the event "Search" there is no sql to change and at "AfterBuildSearchQuery" it is only a string that you shouldn't want work with.
But what you can do is to add your Category restrictions beforehand!

You can access the sql already before it is used by hooking into the search event and adding Gdn::sql()->where(). That will do the trick!

rbrahmson

What is the syntax to put in that Where clause so it would perform a search for a string within a column (I can live with the performance in my small forum)?

rbrahmson

@hgtonight - I tried to use the following but it didn't work. I suspect I am using the wrong syntax. Any clues?

$Sender->SQL->Where($Searchcolumn.' LIKE ', $searchvalue);

R_J

Try Gdn::sql() - >where and searchcolumn must be in the results. Look at how the sql looks at afterBuiltQuery

hgtonight

@rbrahmson Use the Gdn_SQLDriver::like() method:

$sender->SQL->like('field_name', 'match text', 'side');

The side can be 'left', 'right', or the default 'both'. It appends the appropriate characters for you.

rbrahmson

Got it. Apparently I did it the right way and then blew it up. Thanks for reassuring I was on the right track!