RE: Negative Query not working when use brackets in Solr 8.9.0

2023-07-10 Thread Vishal Patel
)) +recordRetentionPolicyStatus:0 Why + sign add? Regards, Vishal From: Alessandro Benedetti<mailto:a.benede...@sease.io> Sent: 10 July 2023 14:08 To: users@solr.apache.org<mailto:users@solr.apache.org> Subject: Re: Negative Query not working when use brackets in Solr 8.9.0 I s

Re: Negative Query not working when use brackets in Solr 8.9.0

2023-07-10 Thread Alessandro Benedetti
I see plenty of questionable practices here that can be improved: 1) wildcard queries -> unless really necessary, you should avoid them as much as possible and design a proper text analysis chain (indexing and query time) instead 2) negative queries -> they are tricky, some query parsers manage pur

Re: Negative Query not working when use brackets in Solr 8.9.0

2023-07-10 Thread Mikhail Khludnev
Hello Vishal. It seems like it made a pure negative query which it can't work around. A few notes: * +- syntax is more predictable than AND/OR * (perhaps) Json Query DSL even more predictable * it's always worth to check how query is parsed via debugQuery=true I'd rather put this query as: q=+*

Negative Query not working when use brackets in Solr 8.9.0

2023-07-10 Thread Vishal Patel
We are using Solr 8.9.0. We have configured Solr cloud like 2 shards and each shard has one replica. We have used 5 zoo keepers for Solr cloud. When we hit the query q= (-msg_content1:(ASI-STD-ITB*) OR -(status_id:1020 AND project_id:2143947)) AND recordRetentionPolicyStatus:0 in Solr admin pane