[Zope] FieldIndex NOT

[Chris McDonough]

There's currently no way to do this in a single query, but you can do 
(inefficient/torturous):

unique_states = catalog.uniqueValuesFor('state')
l = []
for state in unique_states:
     if state != 'California': l.append(state)
notCalifornia = catalog.searchResults({'state':l})

There is a proposal in the fishbowl that, implemented properly, would 
provide a difference function that would allow you to do this more 
efficiently 
(http://dev.zope.org/Wikis/DevSite/Proposals/UnionAndIntersectionOperations).

HTH,

- C



Brian Brinegar wrote:
> I'm probably overlooking this, but has a NOT usage been implemented in
> fieldIndexes. I would like to have something like
> 
> catalog.searchResults({'state':'California','state_usage':'not'})
> 
> return a list of everything that did not have "California" as the value for
> state.
> 
> --Brian
> 
> 
> 
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> http://lists.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists - 
>  http://lists.zope.org/mailman/listinfo/zope-announce
>  http://lists.zope.org/mailman/listinfo/zope-dev )
> 


-- 
Chris McDonough                    Zope Corporation
http://www.zope.org             http://www.zope.com
"Killing hundreds of birds with thousands of stones"