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 panel for one collection, we do not get the records but when we hit the query q= (-msg_content1:(ASI-STD-ITB*) OR -(status_id:1020 AND project_id:2143947)) and fq= recordRetentionPolicyStatus:0 in Solr admin panel for one collection, we get the records. If we remove brackets like q= -msg_content1:(ASI-STD-ITB*) OR -(status_id:1020 AND project_id:2143947) AND recordRetentionPolicyStatus:0 then records are coming but not sure it is proper records come or not.
Can you please help me what is issue here? Why is it not working if we add bracket? Regards, Vishal