solr4 - How add less than and greater than in data-config file of solr -



solr4 - How add less than and greater than in data-config file of solr -

this how goes have 2 tables

businessmasters business_id business_point 1 3.4 2 2.8 3 8.0 business_colors business_colors_id business_rating_from business_rating_to rating 1 2 5 ok 2 5 10 3 10 15 first-class

i want link 2 tables based business_rating_from , business_rating_to like

select business_colors_id,business_rating_from,business_rating_to,rating business_rating_from >= 2 , business_rating_to < 5;

now want index them solr.this how 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 business_colors business_rating_from &gt;= '${businessmasters.business_point}' , business_rating_to &lt; '${businessmasters.business_point}'" deltaquery="select business_colors_id business_colors business_colors_modify > '${dih.last_index_time}'" parentdeltaquery="select business_id businessmasters business_point &lt; ${business_colors.business_rating_from} , 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 click total indexing info not index , no error shown. wrong this,can 1 help , advise. how accomplish want have seen if replace , or works fine.so why or working , and not working

the fact query may not homecoming record case in one. since mention

if replace , or works fine.so why or working , and not working

solr solr4

Comments

Popular posts from this blog

xslt - DocBook 5 to PDF transform failing with error: "fo:flow" is missing child elements. Required content model: marker* -

mediawiki - How do I insert tables inside infoboxes on Wikia pages? -

Local Service User Logged into Windows -