Mailing-List: contact java-user-help@lucene.apache.org; run by ezmlm
Precedence: bulk
Reply-To: java-user@lucene.apache.org
Received-SPF: pass (asf.osuosl.org: domain of jeff.rodenburg@gmail.com
 designates 66.249.82.205 as permitted sender)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;
        b=AuOG/Gzs/gVMy2HpOdEKtZ/NloqEHPXUNeQigmNFmdhsad/j+KiLFu1sWfDmy73y1i69bLZM46j9arJuCSo6IHZhUWZe8+iMvcnhMQjqAohh8AmWp6gdKnjcTgB+kJswMJM+z/ALqW6z9c8rZj+6ig0PoVWVTFCVrsfn2MoBZAc=
Message-ID: <50f433360511151238t101fb332y198f63eab6b324eb@mail.gmail.com>
Date: Tue, 15 Nov 2005 12:38:05 -0800
From: Jeff Rodenburg <jeff.rodenburg@gmail.com>
To: java-user@lucene.apache.org
Subject: Re: Items in multiple category: distinct search?
In-Reply-To: <BF9F5EC4.17CB%jpowers@configureone.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_22732_7670942.1132087085558"
References: <BF9F5EC4.17CB%jpowers@configureone.com>

------=_Part_22732_7670942.1132087085558
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi John -

It sounds like you're thinking of your index in terms of sql constructs --
multiple rows for the same record. We do this very same thing with
categories; if you have a record that lives in multiple categories, just ad=
d
additional category field/value pairs for your original record. It's ok to
use multiple fields with the same name. Once stored, if you want to see
records in category "A", just query lucene for category "A". Thinking of it
in terms of SQL constructs makes it more difficult than it needs to be.

Hope this helps.


On 11/15/05, John Powers <jpowers@configureone.com> wrote:
>
> Hello, I have done a search for this issue, but I didnt really see an
> answer.
>
> if i want to store things in a hierarchy, but i want items to be in
> multiple
> categories at any level. i'd like to be able to search for an item and
> only show it once, but maybe (not required) show what categories the
> results
> are in. but if i look in a category (search on that category) then i want
> to see that item there obviously only the once that it is there.
>
> so i've got the hierarchy part..but its getting items to be in multiple
> categories. i can put them there as duplicate entries of that itemNumber,
> however when i search i dont want to get back the 7 times that one item i=
s
> used.. i dont mind if its in 7 categories and they each show one usage,
> but
> i'd like for my total hit count to reflect just that this item exists
> once... i could iterate through the whole Hits list and put them into a
> unique result list, but i'd like lucene to do that for me. any way to do
> that? custom filter? i've looked at the query language..i didnt see a
> "distinct" clause...
>
> any help is greatly appreciated.
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: java-user-unsubscribe@lucene.apache.org
> For additional commands, e-mail: java-user-help@lucene.apache.org
>
>

------=_Part_22732_7670942.1132087085558--