On Thu, Jul 28, 2005 at 03:57:45PM -0500, abgillette@allmail.net wrote:
Hi All,
I have a ZCatalog with two text indexes, news_subj and news_text. Each ZCatalog item also has a unique numeric ID.
I'd like to search news_subj and news_text simultaneously, with the results checked for duplicates. In other words, if catalog item 1001 has the word "foobar" in both the news_subj and news_text fields, I only want it to show up once in my search results.
Here's what I've got, so far:
<dtml-in expr="mp_catalog({'news_text':'foobar'}) + mp_catalog({'news_subj':'foobar'})"> <dtml-var news_subj><br> </dtml-in>
This correctly searches both fields, but, when "foobar" appears in both news_subj and news_text, the result is displayed twice.
Can anyone give me a pointer on suppressing dupes in a concatenated ZCatalog query? I'm sure there's an easy answer, but I haven't been able to find it.
I don't know if you can do that with ZCatalog alone. Try Dieter's AdvancedQuery product, it's been very helpful to me. http://www.dieter.handshake.de/pyprojects/zope/#AdvancedQuery -- Paul Winkler http://www.slinkp.com