Mailing-List: contact solr-user-help@lucene.apache.org; run by ezmlm
Precedence: bulk
Reply-To: solr-user@lucene.apache.org
MIME-Version: 1.0
In-Reply-To: <1bfbc120-7571-d11a-3b29-27817af1dc60@elyograg.org>
References: <CALPm_-AvKOAe6Cz1H8hekjf_W57pFQWcYxFw7FqbTYoXd2u-Rw@mail.gmail.com>
 <1bfbc120-7571-d11a-3b29-27817af1dc60@elyograg.org>
From: Anil <anilklce@gmail.com>
Date: Fri, 27 May 2016 12:43:29 +0530
Message-ID: <CALPm_-BrVLq=1HDyNTkjCm68tcRbdP9483=ciqrXVPo77ouF5g@mail.gmail.com>
Subject: Re: Not (!) operator
To: solr-user@lucene.apache.org
Content-Type: multipart/alternative; boundary=001a114dd6d8294d550533cda747
archived-at: Fri, 27 May 2016 07:14:22 -0000

--001a114dd6d8294d550533cda747
Content-Type: text/plain; charset=UTF-8

Hi Shawn,

Thanks for reply. i am also worried wither performance.
I will check if there is another way to design the documents in case of
parent and child relationship.

Regards,
Anil

On 27 May 2016 at 12:39, Shawn Heisey <apache@elyograg.org> wrote:

> On 5/26/2016 11:13 PM, Anil wrote:
> > We have status text field in our solr document and it is optional.
> > search query status: !Closed returning documents with no status as
> > well. how to get only documents having status and it is !Closed ? one
> > way is status:* AND status:!Closed . any other way ? Thanks
>
> If you use status:* then you are doing a wildcard query.  If the status
> field has a large number of unique values, this will be VERY slow.
> Avoid wildcard queries unless they are the only way to accomplish what
> you need.
>
> If the status field has more than a few possible values, the most
> compact way to do this query efficiently would be:
>
> status:[* TO *]-status:Closed
>
> This could be written as:
>
> status:[* TO *] AND NOT status:Closed
>
> See this article about why this may not be the best way to write queries:
>
> https://lucidworks.com/blog/2011/12/28/why-not-and-or-and-not/
>
> The [] syntax is a range query.  By starting and ending the range with
> the * character, it means "all documents where status has a value".
>
> Thanks,
> Shawn
>
>

--001a114dd6d8294d550533cda747--