Hi Gurus,
I am trying to use the Solr DIH CachedSqlEntityProcessor. In my case, I
also need to reference another column from the parent entity in the child
entity. How can that be done?
<entity name="product" query="SELECT product_id, category_id, *product_name*
FROM Products">
<field name="id" column="product_id"/>
<entity name="category" query="SELECT id AS c_id, '*${product.product_name}*'
as product_name FROM Categories" processor="CachedSqlEntityProcessor"
where="c_id=product.category_id">
<field name="category_name" column="name"/>
</entity>
</entity>
Observe the product_name column from the parent entity that I am trying to
use in the child entity.
This does not give me any error but produces an incorrect end result. ..
Any thoughts?
Regards,
Nilesh
