Hi list! I am trying to search for items with an attribute (a price) in a defined range, but I also need to match those which have None in that attribute. The index is a FieldIndex, Zope is at version 2.10 Is there any way to do that without doing two separated queries or installing specific Products? Thank you. Andrea Ratto
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Andrea Ratto wrote:
Hi list! I am trying to search for items with an attribute (a price) in a defined range, but I also need to match those which have None in that attribute.
The index is a FieldIndex, Zope is at version 2.10
Is there any way to do that without doing two separated queries or installing specific Products?
No. Any query against a standard FieldIndex must be either a range query (closed or half-open) or query for a specific value. Tres. - -- =================================================================== Tres Seaver +1 540-429-0999 tseaver@palladion.com Palladion Software "Excellence by Design" http://palladion.com -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFIpEG0+gerLs4ltQ4RArgrAJ9r70Oam4lndCpAj7upLdRJwzlgbQCgpPWx nRKto1o0FbjFWRRQm85g2kE= =u7aX -----END PGP SIGNATURE-----
Andrea Ratto wrote at 2008-8-14 10:25 +0200:
I am trying to search for items with an attribute (a price) in a defined range, but I also need to match those which have None in that attribute.
The index is a FieldIndex, Zope is at version 2.10
Is there any way to do that without doing two separated queries or installing specific Products?
One of your options is to forget the restricted ZCatalog API and use "AdvanceQuery" instead. It has a "Between" query for your use case (and many other features and removed bugs). -- Dieter
participants (3)
-
Andrea Ratto -
Dieter Maurer -
Tres Seaver