Hi,How can I to customize search queries in order to use MYSQL fulltext capabilities.elio42
Can you provide us some example for this?
Use Recordset_Selecting server event (see Server Events and Client Scripts) to set your WHERE clause.
Hi,Example of the syntax:
select * from articles where match (body) against (‘database’)
Basically, in advanced search we must change “body like ‘% database%’” by “match (body) against (‘database’)”
As Webmaster said, you can simply use Recordset_Selecting server event, for example:function Recordset_Selecting(&$filter) {
ew_AddFilter($filter, “match(body) against(‘database’)”); // Add your own filter expression
}
Hi,First, I apologize for my English.I understand that ew_filter adds a new clause. I would like to modify the user query on Advanced Search.
What is the event that I can capture the SQL generated by Advanced search?
Try to use “Recordset_Searching” server event.
Recordset_Selecting or Recordset_Searching, you can set the $filter as what you need directly, not necessarily adding a filter. The user input can be obtained by the field object’s SearchValue property, see Server Events and Client Scripts in the help file.
ThanksSolved my problem.
HiSorry for opening this thread again.
Will “highlight feature” work if I use Recordset_Searching with mysql Fulltext?
- The above discussion does not really using MySQL’s fulltext search,
- The highligting will not work because the search criteria is in the server event added by yourself.