Hi, I am new to solar and trying for MySQL data import handler. I have 3 tables in mysql.
1) user 2) mast_data 3) child_data The child_data table has foreign key ref of master_data and user. In child_data table, i have the following columns. 1) date 2) fee 3) location 4) type 5) text 6) user_id 7) master_data_id In the user table, display name field might get changed at any time. In the master table certain fields must be indexed in solar. So combining these 3 tables and trying to index ..... this is for search page ... the data will get added to these tables at any time and also the fields might get changed at any time .... I am not sure, how to keep the solr updated whenever there is any change in the table ........... Also, looking for deleting the index in solr based on the date field .... Please help me on this .... Thanks, Baskar.S