Hello, I've been wrestling with a query use case, perhaps someone has done this already? Is it possible to write a query that excludes results based on another query?
Scenario: I have an index that holds: 'customer' (textgen) 'product' (textgen) 'saledate' (date) I'm looking to return documents for 'customer' entries who have bought a 'product' in the past, but haven't bought in, say, the last month. (i.e. need to exclude *all* 'customer' documents who have bought 'product' in the last month, as well as those who have never bought 'product') A very simple query like this: q=products:Dog AND -(products:Dog AND saledate:[2011-01-01T00:00:00Z TO *]) returns 'Dog' documents prior to 1 Jan, but these need to be excluded if there are matches after 1 Jan. I wasn't expecting the above query to do the extra exclusion - it's just to illustrate the general problem that it operates at document level, not query level (like a SQL subquery). If I could could pipe the results of the above to another query, that would likely do the trick. I've tried negative boosts, magic _query_, query() and such, but with no luck. Is this possible? Any insight into how to write such a query would be much appreciated! Thanks, Peter