How to use less than and greater than in data-config file of solr

[madhav bahuguna <ma...@gmail.com>]

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 &gt;=
'${businessmasters.business_point}' AND
business_rating_to &lt; '${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 &lt;
${business_colors.business_rating_from} AND business_point &gt;=
 ${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

Re: How to use less than and greater than in data-config file of solr

[Ahmet Arslan <io...@yahoo.com.INVALID>]

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 <ma...@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 &gt;=
'${businessmasters.business_point}' AND
business_rating_to &lt; '${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 &lt;
${business_colors.business_rating_from} AND business_point &gt;=
${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