lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mikhail Khludnev <mkhlud...@griddynamics.com>
Subject Re: Nested query in SOLR filter query (fq)
Date Mon, 15 Jul 2013 12:21:30 GMT
Hello,

it sounds like FieldCollapsing or Join scenarios, but given the only
information which you provided, it can be solved by indexing statuses as
multivalue field:
 -ID-  -STATUS-
  id1        (1 2 3 4)
  id2        (1 2)
  id3        (1)

q=*:*&fq=STATUS:1&fq=NOT STATUS:3




On Mon, Jul 15, 2013 at 3:19 PM, EquilibriumCST <valeri_hot4o@abv.bg> wrote:

> Hi all,
>
> I have the following case.
>
> Solr documents has fields --> id and status. Id is not unique. Unique is
> the
> combination of these two elements.
> Documents with same id have different statuses.
>
> List of Documents
>
>  -ID-  -STATUS-
>   id1        1
>   id1        2
>   id1        3
>   id1        4
>   id2        1
>   id2        2
>   id3        1
>
> I need to make query that takes all documents with specific status and to
> exclude documents that don't have other specific status.
> As an example I need to get all documents with status 2 and don't have
> status 3.
> The expected result should be document :
>      id2    2
>
> Another example: all documents with status 1 and don't have status 3. Then
> the result should be:
>      id2        1
>      id3        1
>
> Here is my query that don't work
>
> http://192.168.130.14:13080/solr/select/?q=status:1&version=2.2&start=0&rows=10&indent=on&fl=id,status&fq=-id:(*:*%20AND%20status:2)
> The problem is in filter query(fq) part. In fq must be the ids of the
> documents with status 2 and if the current document id is in this list to
> be
> excluded.
> I guess some subquery must be used in fq part or something else.
> Just for information we are using APACHE SOLR 3.6 and document count is
> around 100k.
>
> Thanks in advance!
>
>
>
> --
> View this message in context:
> http://lucene.472066.n3.nabble.com/Nested-query-in-SOLR-filter-query-fq-tp4078020.html
> Sent from the Solr - User mailing list archive at Nabble.com.
>



-- 
Sincerely yours
Mikhail Khludnev
Principal Engineer,
Grid Dynamics

<http://www.griddynamics.com>
 <mkhludnev@griddynamics.com>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message