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.

Best Regards

kamal