I need a real and demonstrable Solr Expert for a 3 table mysql search job.
JOBS MUST BE DONE
Setting up sorl in our server and configure it for a 3 table search in one unique result.
The result must be integrated with our frontend jquery autocomplete script, crons should be set up to keep the sorl index updated.
The site is in SPANISH so the Solr should be optimized for the Spanish language search.
Search in 3 different tables (usernames, post title ,tags) and output in one some result in our frontend jquery autocomplete script.
if I search for house in the frontend jquery autocomplete, it should return results matching results in 3 different tables.
EXAMPLE RESULTS FOR house
post title result: Dr. house is a very interesting
category result: house building
username result: Amy_whinehouse
post title result: The white house is in Washington
post title result: I don