How do I change the where clause in the ajax auto search.
Using $_SESSION["language"] variable I would like to restrict the autosuggest to records only in the corresponding language.
example.
I have a record type called Category. On the record I have a field category_translated_into which holds the phprunner language code (English, Portuguese (Brazil) etc.)
I have three category records, each with a different category_translated_into value.
When I use the autosuggest search I want only the records with category_translated_into value of the $_SESSION["language"] to appear in the dropdown choices.
In earlier versions I could edit the [table]_search_suggest.php file. I have no idea where this is in the 5.2 version.
Where could I append the extra field in the where clause for auto suggest?
I hope this was clear.
Multilanguage is certainly a challenge.