The database records I'm trying to index with Zend_Search_Lucene are
split in two tables, "foo" and "foo_i18n"

"foo" contains all the non-translatable columns and "foo_i18n" contains
all the translatable columns, plus a "culture" column

When I index these records, I add a document for each row in "foo_i18n"
and include a "culture" field

Unfortunately when I do a search, the same record sometimes appears
multiple times in the results, if the query matched multiple
translations of the same record

I tried adding "culture:fr" to my query to avoid duplicates, but
unfortunately this also excludes records for which a French translation
doesn't exist : (

Any suggestions how to index these records with Zend_Search_Lucene such
that each document which matches a query appears in the results exactly
once?

Reply via email to