Hi,
Since it is an xml file you need to encode greater than sign. >
Ahmet
On Thursday, October 16, 2014 8:52 AM, madhav bahuguna
<madhav.bahug...@gmail.com> wrote:
I have two tables and i want to link them using greater than and less than
condition.They have nothing in common,the only way i can link them is using
range values.Iam able to do this in Mysql but how do i do this in solr in
my data-config.xml file This is how my data-config file looks
<entity name="business_colors" query="SELECT business_colors_id,
business_rating_from,business_rating_to,business_text,hex_colors,rgb_colors,business_colors_modify
from business_colors where business_rating_from >=
'${businessmasters.business_point}' AND
business_rating_to < '${businessmasters.business_point}'"
deltaQuery="select business_colors_id from business_colors where
business_colors_modify >
'${dih.last_index_time}'"
parentDeltaQuery="select business_id from businessmasters where
business_point <
${business_colors.business_rating_from} AND business_point >=
${business_colors.business_rating_from}">
<field column="business_colors_id" name="id"/>
<field column="business_rating_from" name="business_rating_from"
indexed="true" stored="true" />
<field column="business_rating_to" name="business_rating_to"
indexed="true" stored="true" />
<field column="business_text" name="business_text" indexed="true"
stored="true" />
<field column="hex_colors" name="hex_colors" indexed="true" stored="true" />
<field column="rgb_colors" name="rgb_colors" indexed="true" stored="true" />
<field column="business_colors_modify" name="business_colors_modify"
indexed="true"
stored="true"/>
When i click full indexing data does not get index and no error is shown.
What is wrong with this,Can any one help and advise.What i have seen is
that if i replace AND with OR it works fine or just use one condition
instead of both it works fine . Can any one advise and help How do i
achieve what i want to do.
I have also posted this question in stackoverflow
http://stackoverflow.com/questions/26397084/how-use-less-than-and-greater-than-in-data-config-file-of-solr
--
Regards
Madhav Bahuguna
