Mailing-List: contact solr-user-help@lucene.apache.org; run by ezmlm
Precedence: bulk
Reply-To: solr-user@lucene.apache.org
Received-SPF: pass (athena.apache.org: domain of tommy.chheng@gmail.com
 designates 72.14.220.157 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:user-agent:mime-version:to:subject:references
         :in-reply-to:content-type:content-transfer-encoding;
        b=pM035bnl5KtOWvAsH0nQHKnqmhR7iD1x5mZ3AOBGNAXwdfUZiBfPNR5Uc+Yix/9068
         AH+10dIu3c9mLMG3qBKRdTy73sIIbeCxIoaQHPQrCcc6MKBskdQbDw+oZ1aBONi3aIjn
         5pOBWFmRQ/S2R9jI6WUavwz0xkH7hrYhmsyxk=
Message-ID: <4B578033.8080106@gmail.com>
Date: Wed, 20 Jan 2010 14:14:11 -0800
From: Tommy Chheng <tommy.chheng@gmail.com>
User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en-US;
 rv:1.9.1.7) Gecko/20100111 Thunderbird/3.0.1
MIME-Version: 1.0
To: solr-user@lucene.apache.org
Subject: Re: filter querying working on dynamic int fields but not dynamic
 string fields?
References: <4B577531.9040202@gmail.com>
 <BDA339D9-3287-4033-8EB0-8C92B751D4EE@gmail.com>
In-Reply-To: <BDA339D9-3287-4033-8EB0-8C92B751D4EE@gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Thanks,  quoting it fixed it. I'm also going to strip the 
leading/trailing whitespace at index time.

Tommy

On 1/20/10 1:47 PM, Erik Hatcher wrote:
>
> On Jan 20, 2010, at 4:27 PM, Tommy Chheng wrote:
>
>> I'm having trouble doing a filter query on a string field. Any ideas 
>> why it's working on dynamic int fields but not dynamic string fields?
>>
>> ex.
>> http://localhost:8983/solr/select?indent=on&version=2.2&q=climate - 
>> correct
>> http://localhost:8983/solr/select?version=2.2&q=climate&fq=awardedamounttodate_i%3A88900 FQ 
>> with dynamic int field returns one result - correct
>> http://localhost:8983/solr/select?indent=on&version=2.2&q=climate&fq=awardinstrument_s:Continuing+grant returns 
>> zero results - Incorrect
>
> fq=field:value with spaces
>
> is problematic - it is being parsed as a SolrQueryParser expression.  
> It should work if you quote it - fq=field:"value with spaces"
>
> However, as I mentioned earlier today on the list, I think the best 
> option for facet narrowing on string fields is this:
>
>    fq={!raw f=field}value with spaces
>
> Of course all of the above need to be URL encoded too.
>
>> <str>+awardinstrument_s:Continuing +text:grant</str></arr>
>
> This explains the problem exactly.  Note how it parsed the second word 
> to the text field, not the field you specified.
>
>     Erik
>
>