[CPS-devel] zctextindex: everything except 'some words'

[Winterflood, Jonathan]

Hi,
 
I'm doing a search in the ZCatalog on a ZCTextIndex, and I'm not getting any results on a particular search

The different modes I'm using are 'ET', 'OU', and 'SAUF' (just in my form)
  'ET' is all the requested words > the query I use is "word AND word AND word"
  'OU' is any of the requested words > "word OR word OR word"
  'SAUF' is none of the words > "NOT word AND NOT word AND NOT word"

The first two work just fine, but the last one never returns anything, even in combination with other query requirements:
e.g.:
{'sort_on': 'dateSignature', 'cps_filter_sets': {'operator': 'and', 'query': ['searchable']}, 'portal_type': ('dbr_loi', 'dbr_loi_partie'), 'path': '/DBR/sections', 'dateSignature': {'query': ['8/3/2003', '8/3/2010'], 'range': 'minmax'}, 'title': 'NOT workflow '}
does not return anything, even though
{'sort_on': 'dateSignature', 'cps_filter_sets': {'operator': 'and', 'query': ['searchable']}, 'portal_type': ('dbr_loi', 'dbr_loi_partie'), 'path': '/DBR/sections', 'dateSignature': {'query': ['8/3/2003', '8/3/2010'], 'range': 'minmax'}}
does, and the results don't all have 'workflow' in their title
 
Must there necesarily be a inclusive term in the ZCTextIndex query?
Is there a super-wildcard that includes everything?
 
I noticed * and ? can only be used with at least one letter before them, so "* AND NOT word" doesn't work either...
 
TIA,
Jonathan
 


This message contains information that may be privileged or confidential and is the property of the Capgemini Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient,  you are not authorized to read, print, retain, copy, disseminate,  distribute, or use this message or any part thereof. If you receive this  message in error, please notify the sender immediately and delete all  copies of this message.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.nuxeo.com/pipermail/cps-devel/attachments/20070308/b720f351/attachment.html