Question

I have a haystack search which has the following SearchIndex:

class GrantIndex(indexes.SearchIndex):
    """
    This provides the search index for the Grant application.
    """
    text = indexes.CharField(document=True, use_template=True)
    year = indexes.IntegerField(model_attr= year__year )
    date = indexes.DateField(model_attr= date )
    program = indexes.CharField(model_attr= program__area )
    grantee = indexes.CharField(model_attr= grantee )
    amount = indexes.IntegerField(model_attr= amount )
site.register(Grant, GrantIndex)

If I want to search filtering out any programs that ARE NOT Health , I run the following query:

from haystack.query import SearchQuerySet

sqs = SearchQuerySet()
sqs = sqs.filter(program= Health )

Unfortunately, this also produces objects from the program HealthOther and HealthCardiovascular . How do I stop the search from allowing those other programs in?

I run Ubuntu 9.10 with Xapian as my search back-end.

Answer 1

You ve problably solved the problem already, but I just stumbled over the same problem with the Whoosh backend. Maybe the Xapian and Whoosh backends behave the same? Seems Whoosh is stemming all CharFields by default, and searching inside them with some kind of contains-query. Switching to a custom backend, without stemming enabled on CharFields, fixed this issue for me.

Hopefully this will push someone else in the right direction.

Answer 2

you can use field lookups as described here.

sqs = sqs.filter(program__exact= Health )

Answer 3

use "prepare_data" for program field and get rid of healthlabla things

Answer 4

For solr backend I need to use _exact (just one underline instead of two).

Answer 5

Disclaimer: I m the maintainer of Xapian-Haystack.

I believe this happens because Xapian-Haystack was using a term generator that was escaping special characters like /.

So, in your case, "HealthOther" was being indexed as "health" and "other". This was recently fixed in the master branch of Xapian-Haystack, see e.g. here.

友情链接