Unfortunately, I don't know value1, value2, value3, etc.
This goes back to my question about access control lists. So, I have all my
documents, which are products. And then someone suggested that I have a
separate user document type with a multi-value field of productIDs.
In SQL, this would be the equivalent of:
"SELECT * from product where ... AND productId IN (SELECT productId from user
where userId = ?)"
So, my main search clause is a normal search. But, I want to filter the results
by the values in a completely different document where they match on some field.
----- Original Message ----
From: Erik Hatcher <[EMAIL PROTECTED]>
To: solr-user@lucene.apache.org
Sent: Tuesday, May 6, 2008 6:03:34 PM
Subject: Re: complex queries
On May 6, 2008, at 8:57 PM, Kevin Osborn wrote:
> I don't think this is possible, but I figure that I would ask.
>
> So, I want to find documents that match a search term and where a
> field in those documents are also in the results of a subquery.
> Basically, I am looking for the Solr equivalent of doing a SQL IN
> clause.
"search clause" AND field:(value1 OR value2 OR value3)
does that do the trick for you? If not, could you elaborate with
an example?
Erik
