Re: exact match lookup

[Paul Libbrecht]

if you want to have exactly the same effect as the SQL equality, you need more.

The phrase query matches anything with words Social followed by news.



Having a "verbatim analyzer" could be the trick (is it good?).


paul

Le 04-nov.-09 à 18:15, Jérôme Etévé a écrit :

It would also match feedClass:"... finished. Social News In Our Bulletin". As noted elsewhere on the thread you need to query this on a field thats' analyzed "little". Having an analyzer that puts start and end marks would also be the trick.

you need to quote your phrase when you search for 'Social News':

feedClass:"Social News" (URI encoded of course).

otherwise your request will become (I assume you're using a standard
query parser) feedClass:Social defaultField:News . Well that's the
idea.

It should then work using the type string.

Cheers!

J.


2009/11/4 Joel Nylund <jnyl...@yahoo.com>:

Hi,

I have a field that I want to do exact match lookups using.

no like clause so where feedClass = "Social News")

For example the field is called feedClass and im doing:

http://localhost:8983/solr/select?q=feedClass:Blog

http://localhost:8983/solr/select?q=feedClass:Social%20News


with spaces in them.


new type called:

   <fieldType name="text_nows" class="solr.TextField"
positionIncrementGap="100">
  </fieldType>


This didnt seem to help either.


results

For example:

<response>
−
<lst name="responseHeader">
<int name="status">0</int>
<int name="QTime">5</int>
−
<lst name="params">
<str name="q">feedClass:Social News</str>
</lst>
</lst>
−
<result name="response" numFound="3451" start="0">
−
<doc>
<str name="feedClass">Blog</str>
<str name="firstLetterTitle">N</str>
</doc>


any ideas?

thanks
Joel

(when I say exact match, im looking for equivalent to a sql query where with I tried using "text" and it seems to work pretty well except for classes So I tried using field type string, that didnt work. Then I tried defining a When I do these queries for this field with spaces, I seem to get random

--
Jerome Eteve.
http://www.eteve.net
jer...@eteve.net

smime.p7s
Description: S/MIME cryptographic signature