Django-Haystack less than or equal to is not working properly

[sharzzsharon]

• Tested with the latest Haystack release
• Tested with the current Haystack master branch

Expected behaviour

I am using django-haytsack in my django-application. I have to filter Searchqueryset based on salary which is a integer field. Trying to filter using lte but its not giving proper result.

Actual behaviour

if i give filter(salary__lte=int(min_sal) ,where min_sal=5000,Its give results for 1000,13000,13000,354675.

models.py

class UserSkillsProfile(models.Model):
...
salary = models.IntegerField(blank=True, null=True)

search_inndexes.py

class UserSkillsProfileIndex(indexes.SearchIndex, indexes.Indexable):
...
salary = indexes.IntegerField(model_attr='salary',null=True)

Query

  search_models = [UserSkillsProfile]
  qs = SearchQuerySet().order_by('last_updated_time').filter(salary__lte=int(min_sal)).models(
                *search_models)

Configuration

• Operating system version:ubuntu 14.04 KTS
• Python version:3.6.8
• Django version:2.1.2
• Haystack version:2.4.1

[acdha]

Can you test this with the latest Haystack release? Which search engine backend are you using? Do you have a reproducible test case?

[sharzzsharon]

Can you test this with the latest Haystack release? Which search engine backend are you using? Do you have a reproducible test case?

I am new to haystack. Iam using Elasticsearch as SearchEngine and Postgres sql as backend. Currently I am not using any test cases. I tried with haystack 2.4.1 version