[support] Drupal 7 - Strange behavior with Apache SOLR search

[John Summerfield]

On 22/05/13 09:21, Kamal Palei wrote:
>
> Dear All
> I have indexed a salary field for all individuals. If I search without
> any conditions, I get all the records properly.
>
> Now I need to search with conditions. Need to get records where salary
> is in a particular range.
>
> I am trying a simple code as below.
>
> *$conditions['fq'][0] = 'salary:[2 TO 6]';
> $results = apachesolr_search_search_execute($keys, $conditions);
> *
> I get almost 90% records correct. But I got few records where salary
> value is 22.
> Clearly 22 is not in the range of 2 to 6. Can somebody point out whats
> the wrong here.
>
> In another case I tried to search as
>
> *$conditions['fq'][0] = 'salary:[2 TO 10]';
> $results = apachesolr_search_search_execute($keys, $conditions);
> *
> I did not get any record. I wanted to get records where salary is in
> between 2 to *10*. I do not know whats wrong here, mostly the presence
> of 10 is creating problem.
>
> Somebody please help.., or at least point to documentation where I can
> refer and learn.

If you log SQL statements, you can see the SQL it generates and that 
will probably lead you to the solution.


I know it's easy to do this with Postgres, I've no idea how easy it is 
with the alternatives.