Hi All.

We're seeing a really interesting problem when searching by
date range.  

We have two fields of type "date" in our index (they are both
indexed and stored).  They are:

content_date
and
created_date

We can run any date-range query we want against content_date 
and we get expected results.  However, when we run similar
queries against created_date we get 0 results from the query
consistently.

Now, here's the interesting part -- if we do a plain search
without a date range, BUT sort by created_date desc we get 
properly sorted results.

So, it seems like the index works for sorting but not for
searching.  Does that make any sense?  Anyone have an ideas
on how we can diagnose this issue?

Here's the relevant block from our schema (before you ask):

   <field name="id" type="string" indexed="true" stored="true"/>
   <field name="content_date" type="date" indexed="true" stored="true" />
   <field name="media_type" type="string" indexed="true" stored="true" 
multiValued="true" />
   <field name="location" type="string" indexed="true" stored="true" 
multiValued="true" />
   <field name="country_code" type="string" indexed="true" stored="true" 
multiValued="true" />
   <field name="text" type="text" indexed="true" stored="false" 
multiValued="true"/>
   <field name="content_source" type="string" indexed="true" stored="true" />
   <field name="title" type="string" indexed="true" stored="true" />
   <field name="site_id" type="string" indexed="true" stored="false" />
   <field name="journalist_id" type="string" indexed="true" stored="false" />
   <field name="network" type="string" indexed="true" stored="false" />
   <field name="created_date" type="date" indexed="true" stored="true" />

TIA,

Dave W.

Reply via email to