[Zope] ZCatalog and OR searching

[Casey Duncan]

It would be wonderful if ZCatalog could support something like a SQL where
clause for doing complex searching. Is this anything anybody has in the
works or would be interested in working on?

I forsee something like Catalog(query_expr="title contains 'foo' and not
title contains 'bar' or title contains 'spam'"). Support for the simple
searching in existence now should of course remain.

Perhaps some code could be borrowed from Gadfly or something. I would be
interested in working on something such as this, but I don't want to
reinvent the wheel. Anyone with futher input or info, please let me know.

-Casey Duncan

----- Original Message -----
Date: Fri, 01 Sep 2000 11:43:30 +0100
From: Chris Withers <chrisw@nipltd.com>
Organization: New Information Paradigms
To: Dieter Maurer <dieter@handshake.de>
CC: Francois-Regis CHALAOUX <Francois-Regis.CHALAOUX@sanofi-synthelabo.com>,
Receipt Notification Requested <zope@zope.org>
Subject: [Zope] ZCatalog and OR searching

Dieter Maurer wrote:
> A ZCatalog search usually combines searches to the different
> indexes with an "And".
> You want to combine them with an "Or".

Don't you wish there was a decent query language for ZCatalog so this
kindof rediculous complexiting to achieve a simple outcome wasn't
necessary?

cheers,

Chris

PS: The example in the Advanced ZCatalog How-To does away with most of
the catalog's advantages (like lazy searches, small results set, etc)