Date with database

[tt74...@gmail.com]

Hello,

I crawl mysql database and i want to add  "my date" field (mysql field) to last_modifed field (solr field)

Can i do that with a SQL query in my job ?

Thank you for your help.

Mikael

[Olivier Tavard]

Hello,

Yes it is possible.

You just need to map the mysql field into the Solr last_modified field.

To do that, add this into your MCF query :

SELECT id AS $(IDCOLUMN), data AS $(DATACOLUMN), url AS $(URLCOLUMN), mysql_field AS last_modified FROM mytable WHERE id IN $(IDLIST)

Best regards,

Olivier