Do you mean with inner entity something like
<document>
<entity name="bodyshop" query="select id , customer_number
body_shops where state = 1>
<field name="id" column="ID" />
<field name="customer_number" column="CUSTOMER_NUMBER" />
<entity name="facility" query="select name from facilities
where body_shop_id=${bodyshop.ID}">
<field name="name" column="name" />
</entity>
</entity>
</document>
Yes that i could use. But i would use always the same entity in the
where clause of the sub-entity.
I would like to do something like
<!-- load a constant entity>
<entity name = "constant" query="select attr from constants where
state = 1">
</entity>
<document>
<entity name="bodyshop" query="select id , customer_number from
body_shops where state = 1>
<field name="id" column="ID" />
<field name="customer_number" column="CUSTOMER_NUMBER" />
<!-- use data of constant entity here -->
<entity name="facility" query="select name from facilities
where body_shop_id=${bodyshop.ID} and constant_attr = ${constant.attr}">
<field name="name" column="name" />
</entity>
</entity>
</document>
I would like to avoid that repeating join that is required with the
above "inner entity" method above.
Thanks for your support
Per
Am 12.12.2014 um 18:22 schrieb Alexandre Rafalovitch:
Sounds like a case for nested entity definitions with the inner entity
being the one that's actually indexed? Just need to remember that all
the parent mapping is also applicable to all children.
Have you tried that?
Regards,
Alex.
Personal: http://www.outerthoughts.com/ and @arafalov
Solr resources and newsletter: http://www.solr-start.com/ and @solrstart
Solr popularizers community: https://www.linkedin.com/groups?gid=6713853
On 12 December 2014 at 12:15, Per Newgro <per.new...@gmx.ch> wrote:
Hello,
i would like to load an entity before document import in DIH starts.
I want to use the entity id for a sub-select in the document entity.
Can i achieve something like that?
Thanks for helping me
Per