lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Chris Hostetter <>
Subject Re: complex queries
Date Thu, 08 May 2008 23:24:04 GMT

: 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.

Assuming we're talking about a plugin here (request handler or 
QueryComponent)  youd do the "iner" query first, get your results, and 
then use it to cronst the query for the outer query.

but assuming productId is a uniqueKey, this is really just a less 
efficient way of filtering on a DocSet/BitSet you've manually constructed  
containing all of the "products" you know the user has. (which as i recall 
is what you said you were currently doing in the other thread)


View raw message