Here is my query:
<entity name="multipay" pk="mp_id" transformer="DateFormatTransformer"
query="
SELECT CONCAT('product_', CAST(sessions.id AS CHAR)) AS uniquekey,
* my Fields *
FROM sessions
LEFT JOIN product
ON sessions.id = product.session_id
WHERE sessions.product IS NOT NULL "
deltaQuery="SELECT id FROM sessions WHERE created BETWEEN DATE_ADD( NOW(),
INTERVAL - 1 HOUR ) AND NOW()
OR modified BETWEEN '${dataimporter.last_index_time}' AND DATE_ADD( NOW(),
INTERVAL - 1 HOUR ) "
deltaImportQuery="
SELECT CONCAT('product_', CAST(sessions.id AS CHAR)) AS uniquekey,
* my Fields *
FROM sessions
LEFT JOIN product
ON sessions.id = product.session_id
WHERE sessions.product IS NOT NULL
AND WHERE sessions.id = '{dataimporter.delta.id}'
--
View this message in context:
http://lucene.472066.n3.nabble.com/commit-true-has-no-effect-tp1952567p1959429.html
Sent from the Solr - User mailing list archive at Nabble.com.
