okay, found a work around for string fields for NOT queries This query does not filters for NOT:
curl --data-urlencode "stmt=select id, name from collection where NOT (name = 'defaultmail')" 'http://server:port/solr/collection/sql' but after adding sth trivial i.e id > 0 o the where clause as curl --data-urlencode "stmt=select id, name from collection where id > 0 AND NOT (name = 'defaultmail')" 'http://server:port/solr/collection/sql' i am not seeing any name field with 'defaultmail' in the response. I am not sure if this is a bug or just a wrong syntax while using NOT in the where clause as a single criteria though ----- Zeki ama calismiyor... Calissa yapar... -- Sent from: http://lucene.472066.n3.nabble.com/Solr-User-f472068.html
