Hi everyone,
I’m facing strange Solr behavior, which could be better described in examples:
With indexed but not stored IndexDate field:
1) With this query everything works fine, I’m getting the results back:
/select?fl=taskid,docid,score&q=*:*&fq=((((category:"Security")))+AND+(datasource:(sites)))&fq={!frange+l%3D0}query($q)&sort=IndexDate+desc&rows=100&start=0
2) With this query I get nothing:
/select?fl=taskid,docid,score&q=*:*&fq=((((category:"Security")))+AND+(datasource:(sites))+AND+(IndexDate:[NOW/DAY-27DAYS+TO+NOW/DAY%2B1DAY]))&fq={!frange+l%3D0}query($q)&sort=IndexDate+desc&rows=100&start=0
Document’s IndexDate fit specified timeframe for sure.
3) With this query there is no category filter, but there is timeframe filter
and everything works fine:
/select?fl=taskid,docid,score&q=*:*&fq=((datasource:(sites))+AND+(IndexDate:[NOW/DAY-27DAYS+TO+NOW/DAY%2B1DAY]))&fq={!frange+l%3D0}query($q)&sort=IndexDate+desc&rows=100&start=0
Then I decided that it might be related to IndexDate as it is not stored. I
reindexed data with stored IndexDate field and now query number 2 works just
fine.
However, I don’t get the logic here, why it doesn’t work in some particular
case? Can someone explain?
Thank you in advance
P.S. category field is indexed but not stored in all cases.
Regards
Stanislav
