You can get what you want - unique lists of values from docs matching
your query - for a single field (using facets), but not for the
co-occurrence of two field values. So you could combine the two fields
together, if you know what they are going to be "in advance." Facets
also give you counts, so in some special cases, you could get what you
want - eg you can tell when there is only a single pair of values since
their counts will be the same and the same as the total. But that's all
I can think of.
-Mike
On 9/11/2011 12:39 PM, Mark juszczec wrote:
Here's an example:
PK FLD1 FLD2 FLD3 FLD4 FLD5
AB0 A B 0 x y
AB1 A B 1 x y
CD0 C D 0 a b
CD1 C D 1 e f
I want to write a query using only the terms FLD1 and FLD2 and ONLY get
back:
A B x y
C D a b
C D e f
Since FLD4 and FLD5 are the same for PK=AB0 and AB1, I only want one
occurrence of those records.
Since FLD4 and FLD5 are different for PK=CD0 and CD1, I want BOTH
occurrences of those records.
